protected void btnupdate_Click(object sender, EventArgs e) //修改/删除
{
string cmdstring;
int dr1 = -1;
if (btnupdate.Text == "增加")
{
if (Radiogrouportw.SelectedValue == "0")//增加工种
{
#region
if (addhasexist("TBDS_JOBCATINFO", "JC_NAME", DEP_NAME.Text.ToString().Trim(), "JC_DEPID", fatherdept.SelectedValue.ToString())) //判断增的工种名称是否存在，不允许添加相同名称的工种
{
Response.Write("<script>alert('工种名称“" + DEP_NAME.Text.ToString().Trim() + "”已存在，不允许添加相同名称的工种，请重新输入！')</script>");
DEP_NAME.Focus();
//lblupdate.Visible = true;
//lblupdate.Text = "操作失败";
}
else
{
cmdstring = "insert into TBDS_JOBCATINFO(JC_ID,JC_NAME,JC_DEPID,JC_MANCLERK,JC_FILLDATE,JC_NOTE) values(@JC_ID,@JC_NAME,@JC_DEPID,@JC_MANCLERK,@JC_FILLDATE,@JC_NOTE)";
dr1 = tbds_tyofwinf_update(DEP_CODE.Text.ToString(), DEP_NAME.Text.ToString().Trim(), fatherdept.SelectedValue.ToString(), DEP_MANCLERK.Text.ToString(), DEP_FILLDATE.Text.ToString(), DEP_NOTE.Text.ToString(), cmdstring);
}
#endregion
}
else //增加岗位/班组
{
#region
if (addhasexist("TBDS_DEPINFO", "DEP_NAME", DEP_NAME.Text.ToString().Trim(), "DEP_FATHERID", fatherdept.SelectedValue.ToString())) //判断增的部门名称是否存在，不允许添加相同名称的部门
{
Response.Write("<script>alert('部门名称“" + DEP_NAME.Text.ToString().Trim() + "”已存在，不允许添加相同名称的部门，请重新输入！')</script>");
DEP_NAME.Focus();
lblupdate.Visible = true;
lblupdate.Text = "操作失败";
}
else
{
lblupdate.Visible = true;
cmdstring = "insert into TBDS_DEPINFO(DEP_CODE,DEP_NAME,DEP_FATHERID,DEP_ISYENODE,DEP_CY,DEP_SFJY,DEP_MANCLERK,DEP_FILLDATE,DEP_NOTE,DEP_BZYN) values( @DEP_CODE,@DEP_NAME,@fatherdept,@DEP_ISYENODE,@DEP_CY,@DEP_SFJY,@DEP_MANCLERK,@DEP_FILLDATE,@DEP_NOTE,@DEP_BZYN)";
dr1 = tbds_depinf_update(DEP_CODE.Text.ToString(), DEP_NAME.Text.ToString().Trim(), fatherdept.SelectedValue.ToString(), DEP_ISYENODE.SelectedValue.ToString(), DEP_CY.SelectedValue.ToString(), DEP_SFJY.SelectedValue.ToString(), DEP_MANCLERK.Text.ToString(), DEP_FILLDATE.Text.ToString(), DEP_NOTE.Text.ToString(), rdbzyn.SelectedValue, cmdstring);
}
#endregion
}
}
else//修改
{
if (Radiogrouportw.SelectedValue == "0")//修改工种
{
#region
if (changehasexist("TBDS_JOBCATINFO", "JC_NAME", DEP_NAME.Text.Trim(), "JC_DEPID", fatherdept.SelectedValue.ToString(), "JC_ID", DEP_CODE.Text.Trim())) //判断修改的工种名称是否存在，不允许添加相同名称的工种
{
Response.Write("<script>alert('工种名称“" + DEP_NAME.Text.ToString().Trim() + "”已存在，不允许有相同名称的工种，请重新输入！')</script>");
DEP_NAME.Focus();
lblupdate.Visible = true;
lblupdate.Text = "操作失败";
}
else
{
cmdstring = "update TBDS_JOBCATINFO SET JC_ID=@JC_ID,JC_NAME=@JC_NAME,JC_DEPID=@JC_DEPID,JC_MANCLERK=@JC_MANCLERK,JC_FILLDATE=@JC_FILLDATE,JC_NOTE=@JC_NOTE WHERE JC_ID='" + Convert.ToString(Session["depcode"]) + "'";
dr1 = tbds_tyofwinf_update(DEP_CODE.Text.ToString(), DEP_NAME.Text.ToString().Trim(), fatherdept.SelectedValue.ToString(), DEP_MANCLERK.Text.ToString(), DEP_FILLDATE.Text.ToString(), DEP_NOTE.Text.ToString(), cmdstring);
}
#endregion
}
else//修改部门/岗位/班组
{
#region
if (changehasexist("TBDS_DEPINFO", "DEP_NAME", DEP_NAME.Text.Trim(), "DEP_FATHERID", fatherdept.SelectedValue.ToString(), "DEP_CODE", DEP_CODE.Text.Trim())) //判断修改的部门名称是否存在，不允许添加相同名称的部门
{
Response.Write("<script>alert('部门名称“" + DEP_NAME.Text.ToString().Trim() + "”已存在，不允许有相同名称的部门，请重新输入！')</script>");
DEP_NAME.Focus();
lblupdate.Visible = true;
lblupdate.Text = "操作失败";
}
else
{
cmdstring = "update TBDS_DEPINFO SET DEP_CODE=@DEP_CODE,DEP_NAME=@DEP_NAME,DEP_FATHERID=@fatherdept,DEP_ISYENODE=@DEP_ISYENODE,DEP_CY=@DEP_CY,DEP_SFJY=@DEP_SFJY,DEP_MANCLERK=@DEP_MANCLERK,DEP_FILLDATE=@DEP_FILLDATE,DEP_NOTE=@DEP_NOTE,DEP_BZYN=@DEP_BZYN WHERE DEP_CODE='" + Convert.ToString(Session["depcode"]) + "'";
dr1 = tbds_depinf_update(DEP_CODE.Text.ToString(), DEP_NAME.Text.ToString().Trim(), fatherdept.SelectedValue.ToString(), DEP_ISYENODE.SelectedValue.ToString(), DEP_CY.SelectedValue.ToString(), DEP_SFJY.SelectedValue.ToString(), Session["UserName"].ToString(), DEP_FILLDATE.Text.ToString(), DEP_NOTE.Text.ToString(), rdbzyn.SelectedValue, cmdstring);
}
#endregion
}
}
if (dr1 == 1)
{
// Response.Write("<script>javascript:window.close();</script>");
Response.Redirect("tbds_depinfo_detail.aspx");
}
else
{
lblupdate.Visible = true;
lblupdate.Text = "操作失败";
}
}
private void DropBind() //绑定下拉框信息
{
// List<DropDownList> ddl = new List<DropDownList>() { ST_GENDER, DEP_NAME, ST_SEQUEN };
// DropListBind(ddl);
string sql = "select DEP_NAME,DEP_CODE from TBDS_DEPINFO where DEP_CODE like '[0-9][0-9]'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sql);
DEP_NAME.DataSource = dt;
DEP_NAME.DataTextField = "DEP_NAME";
DEP_NAME.DataValueField = "DEP_CODE";
DEP_NAME.DataBind();
AddNew(DEP_NAME);
//性别
List <string> list = new List <string>()
{
"男", "女"
};
ST_GENDER.DataSource = list;
ST_GENDER.DataBind();
AddNew(ST_GENDER);
//岗位序列
list = new List <string>()
{
"管理", "技术", "操作"
};
ST_SEQUEN.DataSource = list;
ST_SEQUEN.DataBind();
AddNew(ST_SEQUEN);
//绑定名族
list = new List <string>()
{
"汉族", "蒙古族", "回族", "藏族", "维吾尔族", "苗族", "彝族", "壮族", "布依族", "朝鲜族", "满族", "侗族", "瑶族", "白族", "土家族", "哈尼族", "哈萨克族", "傣族", "黎族", "僳僳族", "佤族", "畲族", "高山族", "拉祜族", "水族", "东乡族", "纳西族", "景颇族", "柯尔克孜族", "土族", "达斡尔族", "仫佬族", "羌族", "布朗族", "撒拉族", "毛南族", "仡佬族", "锡伯族", "阿昌族", "普米族", "塔吉克族", "怒族", "乌孜别克族", "俄罗斯族", "鄂温克族", "德昂族", "保安族", "裕固族", "京族", "塔塔尔族", "独龙族", "鄂伦春族", "赫哲族", "门巴族", "珞巴族", "基诺族"
};
ST_PEOPLE.DataSource = list;
ST_PEOPLE.DataBind();
AddNew(ST_PEOPLE);
//绑定政治面貌
list = new List <string>()
{
"群众", "中共党员", "共青团员", "民主党派", "无党派", "农工民主党", "致公党", "九三学社", "预备党员"
};
ST_POLITICAL.DataSource = list;
ST_POLITICAL.DataBind();
AddNew(ST_POLITICAL);
//婚姻状况
list = new List <string>()
{
"未婚", "再婚", "丧偶", "离异", "已婚"
};
ST_MARRY.DataSource = list;
ST_MARRY.DataBind();
AddNew(ST_MARRY);
//第一学历 最高学历
list = new List <string>()
{
"本科", "大普", "大专", "中专", "高中", "初中", "小学", "研究生", "在职研究生"
};
ST_XUELI.DataSource = list;
ST_XUELI.DataBind();
AddNew(ST_XUELI);
ST_XUELIHI.DataSource = list;
ST_XUELIHI.DataBind();
AddNew(ST_XUELIHI);
//第一学位 最高学位
list = new List <string>()
{
"博士后", "博士", "硕士", "双学士", "学士", "无"
};
ST_XUEWEI.DataSource = list;
ST_XUEWEI.DataBind();
AddNew(ST_XUEWEI);
ST_XUEWEIHI.DataSource = list;
ST_XUEWEIHI.DataBind();
AddNew(ST_XUEWEIHI);
//技术职务（称）
list = new List <string>()
{
"技术员", "助理工程师", "工程师", "高级工程师", "教授级高级工程师", "助理经济师", "经济师", "高级经济师", "助理政工师", "政工师", "高级政工师", "会计员", "助理会计师", "会计师", "高级会计师", "助理国际商务师", "国际商务师", "高级国务商务师", "助理馆员", "馆员", "副研究馆员", "研究馆员", "护师", "主管护师", "主任护师", "助理统计师", "统计师"
};
ST_ZHICH.DataSource = list;
ST_ZHICH.DataBind();
AddNew(ST_ZHICH);
//职能等级
list = new List <string>()
{
"高级技师", "技师", "普通工", "初级工", "中级工", "高级工"
};
ST_ZHICHXU.DataSource = list;
ST_ZHICHXU.DataBind();
AddNew(ST_ZHICHXU);
//学历类型
list = new List <string>()
{
"普通统招", "成教", "自考", "专升本", "电大", "网络教育"
};
ST_XUELITYPE.DataSource = list;
ST_XUELITYPE.DataBind();
AddNew(ST_XUELITYPE);
//最高学历类型
list = new List <string>()
{
"普通统招", "成教", "自考", "专升本", "电大", "网络教育"
};
ST_XUELITYPEHI.DataSource = list;
ST_XUELITYPEHI.DataBind();
AddNew(ST_XUELITYPEHI);
}
