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