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

try

{

string sql2 = string.Empty;

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

sql2 = \

kaohe(YuanGongId,TrueName,KaoHeTime,Xiang1,Xiang2,Xiang3,Xiang4,Xiang5,Xiang6) \;

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

ddlKaoHeTime.SelectedValue + \ + txtXiang1.Text + \ +

txtXiang2.Text + \ + txtXiang3.Text + \ + txtXiang4.Text + \ + txtXiang5.Text + \ + txtXiang6.Text + \; }

else//修改 {

sql2 = \

YuanGongId='{0}',TrueName='{1}',KaoHeTime='{2}',Xiang1='{3}',Xiang2='{

31

4}',Xiang3='{5}',Xiang4='{6}',Xiang5='{7}',Xiang6='{8}' where kaoheid=\ + id;

sql2 = string.Format(sql2,

ddlYuanGong.SelectedItem.Value, ddlYuanGong.SelectedItem.Text, ddlKaoHeTime.SelectedValue, txtXiang1.Text, txtXiang2.Text,

txtXiang3.Text, txtXiang4.Text, txtXiang5.Text, txtXiang6.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, \信息保存失败，请稍后重试。\, \);

return; }

5.3.8 招聘信息管理

截图与部分代码：

32

try

{

string sql2 = string.Empty;

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

sql2 = \

ZhaoPin(ZhiWei,RenShu,JingYan,YaoQiu,ZhiZe,DaiYu) \;

sql2 += \ + txtZhiWei.Text + \ + txtRenShu.Text + \ + ddlJingYan.SelectedValue + \ + txtYaoQiu.Text + \ + txtZhiZe.Text + \ + txtDaiYu.Text + \; }

else//修改 {

sql2 = \

ZhiWei='{0}',RenShu='{1}',JingYan='{2}',YaoQiu='{3}',ZhiZe='{4}',DaiYu='{5}' where ZhaoPinId=\ + id;

sql2 = string.Format(sql2, txtZhiWei.Text,

txtRenShu.Text, ddlJingYan.SelectedValue, txtYaoQiu.Text, txtZhiZe.Text, txtDaiYu.Text); }

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

33

cn.Close(); cn.Dispose();

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

catch (Exception ex) {

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

5.3.9 员工考勤管理

截图与部分代码：

try

{

string sql2 = string.Empty;

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

sql2 = \

34

KaoQin(YuanGongId,TrueName,KaoQinTime,KaoQinStatus) \;

sql2 += \ + ddlYuanGong.SelectedItem.Value + \ + ddlYuanGong.SelectedItem.Text + \ + txtKaoQinTime.Text + \ + ddlKaoQinStatus.SelectedValue + \; }

else//修改 {

sql2 = \

YuanGongId='{0}',TrueName='{1}',KaoQinTime='{2}',KaoQinStatus='{3}' where KaoQinid=\ + id;

sql2 = string.Format(sql2,

ddlYuanGong.SelectedItem.Value, ddlYuanGong.SelectedItem.Text, txtKaoQinTime.Text, ddlKaoQinStatus.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.10 管理员管理

截图与部分代码：

35