人力资源管理系统论文(6)

sql2 = \

fuli(YuanGongId,TrueName,FuLiTime,FuLiIntro,IsSign) \;

sql2 += \ + ddlYuanGong.SelectedItem.Value + \ + ddlYuanGong.SelectedItem.Text + \ + txtFuLiTime.Text + \ + txtFuLiIntro.Text + \ + rblIsSign.SelectedValue + \; }

else//修改 {

sql2 = \

YuanGongId='{0}',TrueName='{1}',FuLiTime='{2}',FuLiIntro='{3}',IsSign='{4}' where fuliid=\ + id;

sql2 = string.Format(sql2,

ddlYuanGong.SelectedItem.Value, ddlYuanGong.SelectedItem.Text, txtFuLiTime.Text, txtFuLiIntro.Text, rblIsSign.SelectedValue); }

SqlConnection cn = DB.OpenConnection(); SqlCommand cmd = new SqlCommand(sql2, cn); cmd.ExecuteNonQuery(); cn.Close(); cn.Dispose();

Common.ShowMessage(this.Page, \信息保存成功！\, \, \); }

catch (Exception ex) {

Common.ShowMessage(this.Page, \信息保存失败，请稍后重试。\, \);

return; }

5.3.4 培训机构管理

截图与部分代码：

26

try

{

string sql2 = string.Empty;

if (string.IsNullOrEmpty(id))//添加 {

sql2 = \into jigou(JiGouName,Address,Tel,Content) \;

sql2 += \ + txtJiGouName.Text + \ +

txtAddress.Text + \ + txtTel.Text + \ + txtContent.Text + \; }

else//修改 {

sql2 = \

JiGouName='{0}',Address='{1}',Tel='{2}',Content='{3}' where jigouid=\ + id;

sql2 = string.Format(sql2, txtJiGouName.Text, txtAddress.Text, txtTel.Text, txtContent.Text); }

SqlConnection cn = DB.OpenConnection(); SqlCommand cmd = new SqlCommand(sql2, cn); cmd.ExecuteNonQuery(); cn.Close(); cn.Dispose();

Common.ShowMessage(this.Page, \信息保存成功！\, \, \); }

catch (Exception ex) {

27

Common.ShowMessage(this.Page, \信息保存失败，请稍后重试。\, \);

return; }

5.3.5 培训课程管理

截图与部分代码：

try

{

string sql2 = string.Empty;

if (string.IsNullOrEmpty(id))//添加 {

sql2 = \; sql2 += \ + txtKeChengName.Text + \ + txtContent.Text + \; }

else//修改 {

sql2 = \

KeChengName='{0}',Content='{1}' where KeChengid=\ + id;

sql2 = string.Format(sql2, txtKeChengName.Text, txtContent.Text); }

28

SqlConnection cn = DB.OpenConnection(); SqlCommand cmd = new SqlCommand(sql2, cn); cmd.ExecuteNonQuery(); cn.Close(); cn.Dispose();

Common.ShowMessage(this.Page, \信息保存成功！\, \, \); }

catch (Exception ex) {

Common.ShowMessage(this.Page, \信息保存失败，请稍后重试。\, \);

return; }

5.3.6 培训计划管理

截图与部分代码：

try

{

29

string sql2 = string.Empty;

if (string.IsNullOrEmpty(id))//添加 {

sql2 = \

peixun(KeChengId,KeChengName,JiGouId,JiGouName,JiangShi,PeiXunTime,Content) \;

sql2 += \ + ddlKeCheng.SelectedItem.Value + \ + ddlKeCheng.SelectedItem.Text + \ +

ddlJiGou.SelectedItem.Value + \ + ddlJiGou.SelectedItem.Text + \ + txtJiangShi.Text + \ + txtPeiXunTime.Text + \ + txtContent.Text + \;

}

else//修改 {

sql2 = \

KeChengId='{0}',KeChengName='{1}',JiGouId='{2}',JiGouName='{3}',JiangShi='{4}',PeiXunTime='{5}',Content='{6}' where peixunid=\ + id;

sql2 = string.Format(sql2, ddlKeCheng.SelectedItem.Value, ddlKeCheng.SelectedItem.Text, ddlJiGou.SelectedItem.Value,

ddlJiGou.SelectedItem.Text, txtJiangShi.Text, txtPeiXunTime.Text, txtContent.Text); }

SqlConnection cn = DB.OpenConnection(); SqlCommand cmd = new SqlCommand(sql2, cn); cmd.ExecuteNonQuery(); cn.Close(); cn.Dispose();

Common.ShowMessage(this.Page, \信息保存成功！\, \, \); }

catch (Exception ex) {

Common.ShowMessage(this.Page, \信息保存失败，请稍后重试。\ + ex, \);

return; }

5.3.7 绩效考核管理

截图与部分代码：

30