//借调结束
protected void OnJob_Click(object sender, EventArgs e)
{
string username = HttpContext.Current.Session["username"].ToString();
//查找借调状态
string[] onJob = new string[1];
string[] seList = { "transfer" };
sqlTable st = new sqlTable();
st.select_login(username, onJob, "Login", seList);
if (onJob[0] == "0")
{
Response.Write("<script>alert('您未被调至其他部门')</script>");
}
else if (onJob[0] == "1")
{
string[] soList = { "0" };
string[] usese = { "username", "password" };
string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() };
int res2 = st.table_update("Login", seList, soList, usese, useso);
//删除本月借调
string tableName = "Jiediao";
string[] delist = { "year", "month", "username" };
string[] deValue = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), HttpContext.Current.Session["username"].ToString() };
int res3 = st.table_delete(tableName, delist, deValue);
}
Response.Write("<script>alert('借调结束');;window.location.href= 'work.aspx ' </script>");
}
//经营工作量
protected void Manage_Working_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox number = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_number") as TextBox;
TextBox name = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_name") as TextBox;
TextBox project_name = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_project_name") as TextBox;
TextBox xunjia_baojia = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_xunjia_baojia") as TextBox;
TextBox tender = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_tender") as TextBox;
TextBox sign = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_sign") as TextBox;
TextBox toubiao = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_toubiao") as TextBox;
TextBox equip = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_equip") as TextBox;
TextBox test = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_test") as TextBox;
TextBox cuikuan = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_cuikuan") as TextBox;
TextBox contract = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_contract") as TextBox;
TextBox other = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_other") as TextBox;
TextBox PM_day = Manage_Working_Repeater.Items[itemIndex].FindControl("MW_PM_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string trueName = name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(trueName, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day" };
string[] source11 = { project_name.Text.ToString(), xunjia_baojia.Text.ToString(), tender.Text.ToString(), sign.Text.ToString(), toubiao.Text.ToString(), equip.Text.ToString(), test.Text.ToString(), cuikuan.Text.ToString(), contract.Text.ToString(), other.Text.ToString(), PM_day.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], number.Text.ToString() };
//插入
int res = st.table_update("Manage_Working", list, source11, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
//设计工作量
protected void Design_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox dr_number = Design_Repeater.Items[itemIndex].FindControl("dr_number") as TextBox; //获得改行的TextBox1
TextBox dr_name = Design_Repeater.Items[itemIndex].FindControl("dr_name") as TextBox; //获得改行的TextBox2
TextBox dr_project_number = Design_Repeater.Items[itemIndex].FindControl("dr_project_number") as TextBox;
TextBox dr_project_name = Design_Repeater.Items[itemIndex].FindControl("dr_project_name") as TextBox;
TextBox dr_drawing_number = Design_Repeater.Items[itemIndex].FindControl("dr_drawing_number") as TextBox;
TextBox dr_A1_number = Design_Repeater.Items[itemIndex].FindControl("dr_A1_number") as TextBox;
TextBox dr_zhehe_working_day = Design_Repeater.Items[itemIndex].FindControl("dr_zhehe_working_day") as TextBox;
TextBox dr_month_day = Design_Repeater.Items[itemIndex].FindControl("dr_month_day") as TextBox;
TextBox dr_program_day = Design_Repeater.Items[itemIndex].FindControl("dr_program_day") as TextBox;
TextBox dr_basic_design_day = Design_Repeater.Items[itemIndex].FindControl("dr_basic_design_day") as TextBox;
TextBox dr_leader = Design_Repeater.Items[itemIndex].FindControl("dr_leader") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string name = dr_name.Text;
string[] seleList = { "username" };
st.select_Name(name, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "project_number", "project_name", "drawing_number", "A1_number", "zhehe_working_day", "month_day", "program_day", "basic_design_day", "leader" };
string[] source1 = { dr_project_number.Text.ToString(), dr_project_name.Text.ToString(), dr_drawing_number.Text.ToString(), dr_A1_number.Text.ToString(), dr_zhehe_working_day.Text.ToString(), dr_month_day.Text.ToString(), dr_program_day.Text.ToString(), dr_basic_design_day.Text.ToString(), dr_leader.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], dr_number.Text.ToString() };
//插入
int res = st.table_update("Design", list, source1, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
//修改
protected void submit_Click(object sender, EventArgs e)
{
string power = Request.Form["Post"].ToString().Trim();//职位
if (power == "2")
{
power = Request.Form["fzr"].ToString().Trim();
}
string NewUserName = Username.Text.ToString().Trim(); //用户名
string NewUserPass = Pwd.Text.ToString().Trim(); //密码
string RealName = PeopleName.Text.ToString().Trim(); //真实姓名
string team = group2.Value; //获取小组
string transfer = JieDiao.Text.ToString().Trim(); //借调
if (transfer == "已借调")
{
transfer = "1";
}
else
{
transfer = "0";
}
string peonumber = StaffNumber.Text.ToString().Trim();//员工编号
string on_job = OnJob.Text.ToString().Trim();
if (on_job == "在职")
{
on_job = "1";
}
else
{
on_job = "0";
}
sqlTable st = new sqlTable();
string[] list01 = { "power", "password", "name", "team", "transfer", "peoplenumber", "on_job" };
string[] list02 = { power, NewUserPass, RealName, team, transfer, peonumber, on_job };
string[] list03 = { "username" };
string[] list04 = { NewUserName };
int res = st.table_update("Login", list01, list02, list03, list04);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
}
//编程/画面工作量
protected void Programming_Picture_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox ppr_number = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_number") as TextBox;
TextBox ppr_name = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_name") as TextBox;
TextBox ppr_project_name = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_project_name") as TextBox;
TextBox ppr_digital_number = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_digital_number") as TextBox;
TextBox ppr_analog_number = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_analog_number") as TextBox;
TextBox ppr_programing_picture = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_programing_picture") as TextBox;
TextBox ppr_programing_day = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_programing_day") as TextBox;
TextBox ppr_month_day = Programming_Picture_Repeater.Items[itemIndex].FindControl("ppr_month_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string name = ppr_name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(name, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day" };
string[] source1 = { ppr_project_name.Text.ToString(), ppr_digital_number.Text.ToString(), ppr_analog_number.Text.ToString(), ppr_programing_picture.Text.ToString(), ppr_programing_day.Text.ToString(), ppr_month_day.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], ppr_number.Text.ToString() };
//插入
int res = st.table_update("Programing_Picture", list, source1, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
protected void submit_Click(object sender, EventArgs e)
{
string NewUserName = add_username.Text; //用户名
string NewUserPass = add_userpass.Text; //密码
string newPass = add_newPass.Text; //新密码
string confirm = add_confirm.Text; //确认新密码
sqlTable st = new sqlTable();
string[] value = new string[5];
string[] list = { "power", "username", "password", "name", "team" };
st.select_login(NewUserName, value, "Login", list);
//查找用户，修改密码
if (value[1] != "root")
{
if (NewUserName == value[1])
{
if (NewUserPass == value[2])
{
if (newPass == confirm)
{
string[] newPwdList = { "password" };
string[] newPwdSource = { newPass };
string[] userNameList = { "username" };
string[] userNameSource = { NewUserName };
int res = st.table_update("Login", newPwdList, newPwdSource, userNameList, userNameSource);
Response.Write(" <script> alert( '修改成功！ ');window.location.href= 'Default.aspx' </script> ");
}
else
{
Response.Write(@"<script>alert('新密码两次输入不一致,请重新输入！');</script>");
}
}
else
{
Response.Write(@"<script>alert('原密码输入有误,请重新输入！');</script>");
}
}
else
{
Response.Write(@"<script>alert('用户名输入有误,请重新输入！');</script>");
}
}
else
{
Response.Write(@"<script>alert('ROOT用户名不可更改密码！');</script>");
}
}
//零星工日
protected void LingXing_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox number = LingXing_Repeater.Items[itemIndex].FindControl("LX_number") as TextBox;
TextBox name = LingXing_Repeater.Items[itemIndex].FindControl("LX_name") as TextBox;
TextBox chuchai_day = LingXing_Repeater.Items[itemIndex].FindControl("LX_chuchai_day") as TextBox;
TextBox jiaoliu_day = LingXing_Repeater.Items[itemIndex].FindControl("LX_jiaoliu_day") as TextBox;
TextBox other_day = LingXing_Repeater.Items[itemIndex].FindControl("LX_other_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string trueName = name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(trueName, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//更新列名以及数据源
string[] list = { "chuchai_day", "jiaoliu_day", "other_day" };
string[] source11 = { chuchai_day.Text.ToString(), jiaoliu_day.Text.ToString(), other_day.Text.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], number.Text.ToString() };
//插入
int res = st.table_update("LingXing", list, source11, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
//员工离职状态
protected void JobStatus_Click(object sender, EventArgs e)
{
string username = off_username.Text.Trim(); //用户名
string jobStatus = Request.Form["jobstatus"].ToString().Trim(); //工作状态
//查找是否有此用户
string[] pwd = new string[1];
string[] list01 = { "password" };
sqlTable st = new sqlTable();
st.select_onjob(username, pwd, "Login", list01);
if (pwd[0] == "NULL" || pwd[0] == "null")
{
Response.Write("<script>alert('员工姓名输入有误，请重新输入')</script>");
}
else
{
//更新状态
string[] list = { "on_job" };
string[] source = { jobStatus };
string[] selectList = { "name" };
string[] selectSource = { username };
int res = st.table_update("Login", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('修改成功')</script>");
Page_Load(sender, e);
}
else
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
//删除事件
protected void delete_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，无法删除')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); //添加索引
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Programing_Picture";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//查找原来日常工作量当月汇总
string[] list6 = { "year", "month", "username", "number" };
string[] source6 = { year, month, username, New_add_index };
int res = st.table_delete("Programing_Picture", list6, source6);
#region 修改number值
string[] tableName = { "Daily_Manage", "Debug", "Design", "LingXing", "Manage_Working", "Programing_Picture" };
string[] columns = { "number" };
String[,] temp = new String[30, 1];
String[,] temp1 = new String[30, 1];
string[] xianding = { "year", "month", "username" };
string[] xdValue = { year, month, username };
for (int k = 0; k < tableName.Length; k++)
{
for (int j = 0; j < temp.Length; j++)
{
temp[j, 0] = null;
}
//st.page_flash(temp, tableName[k], columns);//tableName[i]
st.selecet_number(temp, tableName[k], columns, xianding, xdValue);
for (int i = 0; i < temp.GetLength(0); i++)
{
if (temp[i, 0] == null)
{
break;
}
if (int.Parse(temp[i, 0]) > int.Parse(New_add_index))
{
temp1[i, 0] = temp[i, 0];
temp[i, 0] = (int.Parse(temp[i, 0]) - 1).ToString();
string[] temp2 = new string[1];
temp2[0] = temp[i, 0];
string[] upsource = { year, month, username, temp1[i, 0] };
st.table_update(tableName[k], columns, temp2, list6, upsource);
}
}
}
#endregion
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
//修改事件
protected void modifybtn_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，不可修改')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
string New_add_engineName = add_engineName.Text.Trim(); //项目名称
string New_add_onOffNum = add_onOffNum.Text.Trim(); //总开关量点数
string New_add_modeNum = add_modeNum.Text.Trim(); //总模拟量点数
string New_add_program = Request.Form["add_program"].ToString().Trim(); //编程/画面
string New_add_allDays = add_allDays.Text.Trim(); //总工日数
string New_add_finishedDays = add_finishedDays.Text.Trim(); //本月完成工日数
string New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Programing_Picture";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//更新列名以及数据源
string[] list = { "project_name", "digital_number", "analog_number", "programing_picture", "programing_day", "month_day", "remark" };
string[] source = { New_add_engineName, New_add_onOffNum, New_add_modeNum, New_add_program, New_add_allDays, New_add_finishedDays, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("Programing_Picture", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
//修改事件
protected void modifybtn_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，不可修改')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
string New_add_engineName = add_engineName.Text.Trim(); //项目名称
string New_add_quotation = add_quotation.Text.Trim(); //商务询价报价
string New_add_tender = add_tender.Text.Trim(); //标书制作
string New_add_sign = add_sign.Text.Trim(); //合同制作与签署
string New_add_bid = add_bid.Text.Trim(); //投标工作
string New_add_equip = add_equip.Text.Trim(); //设备招标采购
string New_add_test = add_test.Text.Trim(); //设备出厂检测
string New_add_dun = add_dun.Text.Trim(); //催款（要账）
string New_add_contract = add_contract.Text.Trim(); //合同管理
string New_add_others = add_others.Text.Trim(); //其他经营活动
string New_add_managerDays = add_managerDays.Text.Trim(); //项目经理
string New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Manage_Working";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//更新列名以及数据源
string[] list = { "project_name", "xunjia_baojia", "tender", "sign", "toubiao", "equip", "test", "cuikuan", "contract", "other", "PM_day", "remark" };
string[] source = { New_add_engineName, New_add_quotation, New_add_tender, New_add_sign, New_add_bid, New_add_equip, New_add_test, New_add_dun, New_add_contract, New_add_others, New_add_managerDays, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("Manage_Working", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
//日常管理工作量
protected void Daily_Manage_Repeater_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "confirm") //如果点击的是被标记为CommandName="del"的按钮，也就是确认按钮
{
int itemIndex = int.Parse(e.CommandArgument.ToString()); //藏在CommandArgument='<%#Eval("id")+","+(Container as RepeaterItem).ItemIndex%>'逗号后面的参数就是该行行号
TextBox number = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_number") as TextBox;
TextBox name = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_name") as TextBox;
TextBox management = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_management") as TextBox;
TextBox affair_gonghui = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_affair_gonghui") as TextBox;
TextBox affair_dangzu = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_affair_dangzu") as TextBox;
TextBox affair_tuanzu = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_affair_tuanzu") as TextBox;
TextBox examine = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_examine") as TextBox;
TextBox kaoqin = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_kaoqin") as TextBox;
TextBox other = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_other") as TextBox;
TextBox month_day = Daily_Manage_Repeater.Items[itemIndex].FindControl("DM_month_day") as TextBox;
//获取用户名
sqlTable st = new sqlTable();
string[] username = new string[1];
string tableName = "Login";
string trueName = name.Text.ToString();
string[] seleList = { "username" };
st.select_Name(trueName, username, tableName, seleList);
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
//当月总工日汇总
float monthSum = 0;//修改汇总
if (management.Text != "")
{
monthSum += float.Parse(management.Text.ToString());
}
if (affair_gonghui.Text != "")
{
monthSum += float.Parse(affair_gonghui.Text.ToString());
}
if (affair_dangzu.Text != "")
{
monthSum += float.Parse(affair_dangzu.Text.ToString());
}
if (affair_tuanzu.Text != "")
{
monthSum += float.Parse(affair_tuanzu.Text.ToString());
}
if (examine.Text != "")
{
monthSum += float.Parse(examine.Text.ToString());
}
if (kaoqin.Text != "")
{
monthSum += float.Parse(kaoqin.Text.ToString());
}
if (other.Text != "")
{
monthSum += float.Parse(other.Text.ToString());
}
//更新列名以及数据源
string[] list = { "management", "affair_gonghui", "affair_dangzu", "affair_tuanzu", "examine", "kaoqin", "other", "month_day" };
string[] source11 = { management.Text.ToString(), affair_gonghui.Text.ToString(), affair_dangzu.Text.ToString(), affair_tuanzu.Text.ToString(), examine.Text.ToString(), kaoqin.Text.ToString(), other.Text.ToString(), monthSum.ToString() };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username[0], number.Text.ToString() };
//插入
int res = st.table_update("Daily_Manage", list, source11, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
}
//修改事件
protected void modifybtn_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，不可修改')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
string New_add_business = add_business.Text.Trim(); //本月出差天数
string New_add_technical = add_technical.Text.Trim(); //技术交流天数
string New_add_others = add_others.Text.Trim(); //其他零星工日
string New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "LingXing";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//更新列名以及数据源
string[] list = { "chuchai_day", "jiaoliu_day", "other_day", "remark" };
string[] source = { New_add_business, New_add_technical, New_add_others, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("LingXing", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
//借调
protected void add_Click(object sender, EventArgs e)
{
int res = 5;
int res2 = 5;
string branch = "借调至";
branch += add_index.Text.Trim();//借调部门
string username = HttpContext.Current.Session["username"].ToString();
//查找借调状态
string[] onJob = new string[1];
string[] seList = { "transfer" };
sqlTable st = new sqlTable();
st.select_login(username, onJob, "Login", seList);
if (onJob[0] == "1")
{
Response.Write("<script>alert('您已被借调至其他部门')</script>");
}
else if (onJob[0] == "0")
{
string[] bra = new string[1];
string[] list = { "year", "month", "username" };
string[] source = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username };
st.select_easy(list, source, bra, "Jiediao", seList);
if (bra[0] == "null" || bra[0] == null || bra[0] == "NULL")
{
string[] list02 = { "year", "month", "username", "team", "transfer", "ratio" };
string t = HttpContext.Current.Session["team"].ToString();
string[] source02 = { DateTime.Now.Year.ToString(), DateTime.Now.Month.ToString(), username, t, branch, "无" };
res = st.table_insert("Jiediao", list02, source02);
string[] soList = { "1" };
string[] usese = { "username", "password" };
string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() };
res2 = st.table_update("Login", seList, soList, usese, useso);
#region 提示
if (res == 1 && res2 == 1)
{
Response.Write("<script>alert('借调成功')</script>");
}
else if (res == 0 || res2 == 0)
{
Response.Write("<script>alert('数组长度不一致，请联系管理员')</script>");
}
else if (res == 2 || res2 == 2)
{
Response.Write("<script>alert('程序异常，请联系管理员')</script>");
}
#endregion
}
else
{
string[] sour = { branch };
res = st.table_update("Jiediao", seList, sour, list, source);
string[] soList = { "1" };
string[] usese = { "username", "password" };
string[] useso = { HttpContext.Current.Session["username"].ToString(), HttpContext.Current.Session["userpwd"].ToString() };
res2 = st.table_update("Login", seList, soList, usese, useso);
#region 提示
if (res == 1 && res2 == 1)
{
Response.Write("<script>alert('借调成功') </script>");
}
else if (res == 0 || res2 == 0)
{
Response.Write("<script>alert('数组长度不一致，请联系管理员')</script>");
}
else if (res == 2 || res2 == 2)
{
Response.Write("<script>alert('程序异常，请联系管理员')</script>");
}
#endregion
}
}
else
{
Response.Write("<script>alert('借调状态错误，请联系管理员')</script>");
}
if (res == 1 && res2 == 1)
{
Response.Write("<script>parent.document.location.href = '../workbra.aspx' </script>");
}
}
// 修改事件
protected void modifybtn_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，不可修改')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); //添加索引
string New_add_management = add_management.Text.Trim(); //部门内部日常管理
string New_add_affair = add_affair.Text.Trim(); //工会事务
string New_add_affair2 = add_affair2.Text.Trim(); //党组事务
string New_add_affair3 = add_affair3.Text.Trim(); //团组事务
string New_add_examine = add_examine.Text.Trim(); //体系内审/外审
string New_add_check = add_check.Text.Trim(); //考勤
string New_add_others = add_others.Text.Trim(); //其他报销
string New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Daily_Manage";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//当月总工日汇总
float monthSum = 0;//修改汇总
if (add_management.Text != "")
{
monthSum += float.Parse(New_add_management);
}
if (add_affair.Text != "")
{
monthSum += float.Parse(New_add_affair);
}
if (add_affair2.Text != "")
{
monthSum += float.Parse(New_add_affair2);
}
if (add_affair3.Text != "")
{
monthSum += float.Parse(New_add_affair3);
}
if (add_examine.Text != "")
{
monthSum += float.Parse(New_add_examine);
}
if (add_check.Text != "")
{
monthSum += float.Parse(New_add_check);
}
if (add_others.Text != "")
{
monthSum += float.Parse(New_add_others);
}
//更新列名以及数据源
string[] list = { "management", "affair_gonghui", "affair_dangzu", "affair_tuanzu", "examine", "kaoqin", "other", "month_day", "remark" };
string[] source = { New_add_management, New_add_affair, New_add_affair2, New_add_affair3, New_add_examine, New_add_check, New_add_others, monthSum.ToString(), New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("Daily_Manage", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
//修改事件
protected void modifybtn_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，无法删除')</script>");
return;
}
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，不可修改')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
String New_add_engineName = add_engineName.Text.Trim(); //项目名称
String New_add_enginePlace = add_enginePlace.Text.Trim(); //项目地点
String New_add_manageDays = add_manageDays.Text.Trim(); //本月工程管理天数
String New_add_debugDays = add_debugDays.Text.Trim(); //本月调试天数
String New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Debug";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//更新列名以及数据源
string[] list = { "projectname", "site", "manageday", "debugday", "remark" };
string[] source = { New_add_engineName, New_add_enginePlace, New_add_manageDays, New_add_debugDays, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
int res = st.table_update("Debug", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
//修改事件
protected void modifybtn_Click(object sender, EventArgs e)
{
sqlTable st = new sqlTable();
//获取年月日以及用户名，小组
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month.ToString();
string username = HttpContext.Current.Session["username"].ToString();
//借调判断
if (HttpContext.Current.Session["transfer"].ToString() == "1")
{
string tableNames = "Jiediao";
string[] result = new string[1];
string[] col = { "transfer" };
string[] translist = { "year", "month", "username" };
string[] transsource = { year, month, username };
st.select_delete(tableNames, result, translist, transsource, col);
Response.Write("<script>alert('您已被" + result[0] + "，不可修改')</script>");
return;
}
//网页输入
string New_add_index = add_index.Text.Trim(); // 索引
String New_add_engine = add_engine.Text.Trim(); //工程号
String New_add_engineName = add_engineName.Text.Trim(); //工程名称
String New_add_paperPage = add_paperPage.Text.Trim(); //图纸张数
String New_add_al = add_al.Text.Trim(); //折合Al
String New_add_allDays = add_allDays.Text.Trim(); //折合总工日数
String New_add_finishedDays = add_finishedDays.Text.Trim(); //本月完成工日数
String New_add_usedDays = add_usedDays.Text.Trim(); //技术方案工作量所用工日数
String New_add_usedDays2 = add_usedDays2.Text.Trim(); //基本设计工作量所用工日数
String New_add_leaderDays = add_leaderDays.Text.Trim(); //工日
String New_add_remarks = add_remarks.Text.Trim(); //备注
//查找索引是否存在
string[] listNumber = { "year", "month", "username", "number" };
string[] sourceNumber = { year, month, username, New_add_index };
string[] selectNumber = { "number" };
string tableNameNumber = "Design";
string[] resNumber = new string[1];
st.select_delete(tableNameNumber, resNumber, listNumber, sourceNumber, selectNumber);
if (New_add_index != resNumber[0])
{
Response.Write("<script>alert('填写序号有误')</script>");
return;
}
//更新列名以及数据源
string[] list = { "project_number", "project_name", "drawing_number", "A1_number", "zhehe_working_day", "month_day", "program_day", "basic_design_day", "leader", "remark" };
string[] source = { New_add_engine, New_add_engineName, New_add_paperPage, New_add_al, New_add_allDays, New_add_finishedDays, New_add_usedDays, New_add_usedDays2, New_add_leaderDays, New_add_remarks };
//查找列名以及数据源
string[] selectList = { "year", "month", "username", "number" };
string[] selectSource = { year, month, username, New_add_index };
//插入
int res = st.table_update("Design", list, source, selectList, selectSource);
if (res == 1)
{
Response.Write("<script>alert('成功')</script>");
}
else if (res == 0)
{
Response.Write("<script>alert('输入有误，请重新输入')</script>");
}
else if (res == 2)
{
Response.Write("<script>alert('语法错误')</script>");
}
}
