//删除事件 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>"); } }