//经营工作量 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 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 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 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>"); } } }