protected void btn_Save_Click(object sender, EventArgs e) { ExtAspNet.CheckBoxField Authority = (ExtAspNet.CheckBoxField)Grid1.FindColumn("cbx_Authority"); if (DropDownList3.SelectedItem.Value != "") { string sql = "update sys_func_authority set p001='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 1); sql += "',p002='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 2); sql += "',p003='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 3); sql += "',p004='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 4); sql += "',p005='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 5); sql += "',p006='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 6); sql += "',b001='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 1); sql += "',b002='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 2); sql += "',b003='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 3); sql += "',b004='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 4); sql += "',d001='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("d")) + 1); sql += "',s001='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 1); sql += "',s002='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 2); sql += "',s003='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 3); sql += "',s004='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 4); sql += "',s005='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 5); sql += "',s006='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 6); sql += "',s007='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 7); sql += "',m001='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 1); sql += "',m002='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 2); sql += "',m003='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 3); sql += "',m004='"; sql += Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 4); sql += "' where og_id = '"; if (DropDownList1.SelectedItem.Text == "按用户") { sql += DropDownList3.SelectedItem.Value; sql += "' and og_type=3001"; } else if (DropDownList1.SelectedItem.Text == "按部门") { sql += DropDownList2.SelectedItem.Value; sql += "' and og_type=3002"; } else if (DropDownList1.SelectedItem.Text == "按角色") { sql += DropDownList2.SelectedItem.Value; sql += "' and og_type=3004"; } int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst < 0) { Alert.ShowInTop("save error!"); return; } else { Alert.Show("修改成功!"); } } }
protected void Search(string strsql) { ExtAspNet.CheckBoxField Authority = (ExtAspNet.CheckBoxField)Grid1.FindColumn("cbx_Authority"); // string sql = "select * from sys_func_authority "; // sql += " where og_id = " + DropDownList3.SelectedItem.Value + ""; string sql = strsql; SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (!reader.HasRows) { for (int i = 0; i <= Convert.ToInt32(GetAuthorityTreeDepth("A")); i++) { Authority.SetCheckedState(i, false); } if (DropDownList1.SelectedItem.Text == "按用户") { sql = " insert into sys_func_authority (og_id,og_type)values ('"; sql += DropDownList3.SelectedItem.Value; sql += "',3001)"; } else if (DropDownList1.SelectedItem.Text == "按部门") { sql = " insert into sys_func_authority (og_id,og_type)values ('"; sql += DropDownList2.SelectedItem.Value; sql += "',3002)"; } else if (DropDownList1.SelectedItem.Text == "按角色") { sql = " insert into sys_func_authority (og_id,og_type)values ('"; sql += DropDownList2.SelectedItem.Value; sql += "',3004)"; } //Alert.ShowInTop(sql); int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst < 0) { Alert.ShowInTop("save error!"); return; } else { Alert.Show("权限表中不存在该用户记录 系统已自动新增该用户!"); } } while (reader.Read()) { //p bool p001 = Convert.ToBoolean(reader["p001"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 1, p001); bool p002 = Convert.ToBoolean(reader["p002"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 2, p002); bool p003 = Convert.ToBoolean(reader["p003"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 3, p003); bool p004 = Convert.ToBoolean(reader["p004"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 4, p004); bool p005 = Convert.ToBoolean(reader["p005"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 5, p005); bool p006 = Convert.ToBoolean(reader["p006"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")) + 6, p006); if (p001 && p002 && p003 && p004 && p005 && p006) { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")), true); } else { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p")), false); } //b bool b001 = Convert.ToBoolean(reader["b001"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 1, b001); bool b002 = Convert.ToBoolean(reader["b002"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 2, b002); bool b003 = Convert.ToBoolean(reader["b003"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 3, b003); bool b004 = Convert.ToBoolean(reader["b004"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")) + 4, b004); if (b001 && b002 && b003 && b004) { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")), true); } else { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b")), false); } //d bool d001 = Convert.ToBoolean(reader["d001"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("d")) + 1, d001); if (d001) { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("d")), true); } else { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("d")), false); } //s bool s001 = Convert.ToBoolean(reader["s001"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 1, s001); bool s002 = Convert.ToBoolean(reader["s002"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 2, s002); bool s003 = Convert.ToBoolean(reader["s003"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 3, s003); bool s004 = Convert.ToBoolean(reader["s004"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 4, s004); bool s005 = Convert.ToBoolean(reader["s005"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 5, s005); bool s006 = Convert.ToBoolean(reader["s006"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 6, s006); bool s007 = Convert.ToBoolean(reader["s007"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")) + 7, s007); if (s001 && s002 && s003 && s004 && s005 && s006 && s007) { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")), true); } else { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s")), false); } //m bool m001 = Convert.ToBoolean(reader["m001"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 1, m001); bool m002 = Convert.ToBoolean(reader["m002"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 2, m002); bool m003 = Convert.ToBoolean(reader["m003"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 3, m003); bool m004 = Convert.ToBoolean(reader["m004"]); Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")) + 4, m004); if (m001 && m002 && m003 && m004) { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")), true); } else { Authority.SetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")), false); } if (Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("p"))) && Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b"))) && Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("b"))) && Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("d"))) && Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("s"))) && Authority.GetCheckedState(Convert.ToInt32(GetAuthorityTreeLoc("m")))) { Authority.SetCheckedState(0, true); } else { Authority.SetCheckedState(0, false); } } }
//CheckType 0失败弹框 且全部检测 其他值不弹框 且只检测上传项打勾的 protected int CheckData(int CheckType) { try { ExtAspNet.CheckBoxField cbxUpload = (ExtAspNet.CheckBoxField)Grid1.FindColumn("cbxUpload"); string errormessage = ""; string erroershow = ""; highlightRows.Text = ""; // DataTable dt = new DataTable(); inilist(); // dt = (DataTable)Page.Session["ExcelDateTabel"]; for (int i = 0; i < Grid1.Rows.Count; i++) { if (!cbxUpload.GetCheckedState(i) && CheckType != 0) { continue; } errormessage = ""; if (Utils.GetStrNameToCode(mylist_code, Grid1.Rows[i].Values[4].ToString()) == "") { errormessage += "问题分类,"; } if (Utils.GetStrNameToCode(mylist_code, Grid1.Rows[i].Values[5].ToString()) == "") { errormessage += "过程分类,"; } if (!IsDate(Grid1.Rows[i].Values[11].ToString())) { errormessage += "发生日期,"; } if (Utils.GetStrNameToCode(mylist_user, Grid1.Rows[i].Values[6].ToString()) == "") { errormessage += "转发对象,"; } if (Utils.GetStrNameToCode(mylist_pjm_project_info, Grid1.Rows[i].Values[8].ToString()) == "") { errormessage += "所属项目,"; } if (Utils.GetStrNameToCode(mylist_code, Grid1.Rows[i].Values[9].ToString()) == "") { errormessage += "优先级,"; } if (!IsDate(Grid1.Rows[i].Values[12].ToString())) { errormessage += "处理日期,"; } if (Utils.GetStrNameToCode(mylist_user, Grid1.Rows[i].Values[2].ToString()) == "") { errormessage += "提出人,"; } if (Utils.GetStrNameToCode(mylist_user, Grid1.Rows[i].Values[7].ToString()) == "") { errormessage += "处理人,"; } if (Utils.GetStrNameToCode(mylist_pjm_product_info, Grid1.Rows[i].Values[3].ToString()) == "") { errormessage += "所属产品,"; } if (Grid1.Rows[i].Values[10].ToString().Trim() != "是" && Grid1.Rows[i].Values[10].ToString().Trim() != "否") { errormessage += "是否已处理,"; } if (errormessage != "") { highlightRows.Text += Convert.ToString(i) + ","; // Grid1.Rows[i].s = System.Drawing.Color.Red; cbxUpload.SetCheckedState(i, false); string[] aa = Grid1.Rows[0].Values; erroershow += "第" + Convert.ToString(i + 1) + "行数据 以下字段发生错误:" + errormessage; } } if (erroershow == "") { if (CheckType == 0) { Alert.Show("Success!"); } return(0); } else { Alert.Show(erroershow); return(-1); } }catch { return(-1); } }
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == "Show") { // ExtAspNet.LinkButtonField Authority = (ExtAspNet.LinkButtonField)Grid1.FindColumn("btn_cbxAuthority"); // Authority._icon = Icon.BulletCross; // Authority.Grid.Rows[e.RowIndex]. ExtAspNet.CheckBoxField Authority = (ExtAspNet.CheckBoxField)Grid1.FindColumn("cbx_Authority"); int i = e.RowIndex; bool EnableSelect = false; string menuId = Convert.ToString(Grid1.DataKeys[i][0]); string mname = Convert.ToString(Grid1.DataKeys[i][1]); // int Depth = Convert.ToInt32(Grid1.DataKeys[i][2]); string FirstWord = menuId.Substring(0, 1); int Depth = Convert.ToInt32(GetAuthorityTreeDepth(FirstWord)); int FirstWordLoc = Convert.ToInt32(GetAuthorityTreeLoc(FirstWord)); EnableSelect = Authority.GetCheckedState(e.RowIndex); int EndDepth = Convert.ToInt32(GetAuthorityTreeDepth("A")); bool AllSelect = true; if (menuId == "s" || menuId == "m" || menuId == "b" || menuId == "p" || menuId == "d" || menuId == "ALL") { for (int k = 1; k < Depth + 1; k++) { if (EnableSelect) { Authority.SetCheckedState(e.RowIndex + k, true); } else { Authority.SetCheckedState(e.RowIndex + k, false); } Authority.SetCheckedState(0, false); } if (EnableSelect) { for (int k1 = 1; k1 < EndDepth + 1; k1++) { if (!Authority.GetCheckedState(k1)) { AllSelect = false; break; } } if (AllSelect) { Authority.SetCheckedState(0, true); } } } else { if (EnableSelect) { for (int k = FirstWordLoc + 1; k < Depth + 1 + 1; k++) { if (!Authority.GetCheckedState(k)) { AllSelect = false; break; } } if (AllSelect) { Authority.SetCheckedState(FirstWordLoc, true); } for (int k = 1; k < EndDepth + 1; k++) { if (!Authority.GetCheckedState(k)) { AllSelect = false; break; } } if (AllSelect) { Authority.SetCheckedState(0, true); } } else { Authority.SetCheckedState(0, false); Authority.SetCheckedState(FirstWordLoc, false); } } } }
protected void btn_SaveTable_Click(object sender, EventArgs e) { try { ExtAspNet.CheckBoxField cbxUpload = (ExtAspNet.CheckBoxField)Grid1.FindColumn("cbxUpload");//是否上传 if (CheckData(1) != 0) { return; } // inilist(); string sql; // DataTable dt = new DataTable(); // dt = (DataTable) Page.Session["ExcelDateTabel"]; if (Grid1.Rows.Count == 0) { Alert.Show("表格无数据"); return; } for (int i = 0; i < Grid1.Rows.Count; i++) { if (!cbxUpload.GetCheckedState(i)) { continue; } // string aaa = Grid1.Rows[i].States[1].ToString(); // Alert.Show(aaa); sql = "INSERT INTO bug_main_info (bug_title,bug_type,sub_bug_count) "; sql += "VALUES ('" + Grid1.Rows[i].Values[1].ToString() + "', '" + Utils.GetStrNameToCode(mylist_code, Grid1.Rows[i].Values[4].ToString()) + "', 1 ) "; //Alert.ShowInTop(sql); int rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error!"); continue; } string sIsResolved = "0"; if (Grid1.Rows[i].Values[10].ToString() == "是") { sIsResolved = "1"; } sql = "select IDENT_CURRENT('bug_main_info') "; SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); string newId = "0"; while (reader.Read()) { newId = reader.GetValue(0).ToString(); } string resolveUser = "******"; if (Grid1.Rows[i].Values[7].ToString() != null) { resolveUser = Grid1.Rows[i].Values[7].ToString(); } sql = "INSERT INTO bug_detail_info (bug_id,process_type,is_resolved,phenomenon,create_time,occur_time,create_user_id,bug_state, "; sql += "pj_id,PRI,rsolve_time,resolve_user_id,solution,cur_user_id,next_user_id,pd_id) "; sql += "VALUES (" + newId + "," + Utils.GetStrNameToCode(mylist_code, Grid1.Rows[i].Values[5].ToString()) + "," + sIsResolved + ",'" + Grid1.Rows[i].Values[13].ToString() + "',GETDATE(),cast('" + Grid1.Rows[i].Values[11].ToString() + "' as datetime),"; sql += Utils.GetStrNameToCode(mylist_user, Grid1.Rows[i].Values[2].ToString()) + ",6001," + Utils.GetStrNameToCode(mylist_pjm_project_info, Grid1.Rows[i].Values[8].ToString()) + "," + Utils.GetStrNameToCode(mylist_code, Grid1.Rows[i].Values[9].ToString()) + ", "; sql += "cast('" + Grid1.Rows[i].Values[12].ToString() + "' as datetime)," + Utils.GetStrNameToCode(mylist_user, resolveUser) + ",'" + Grid1.Rows[i].Values[14].ToString() + "'," + Utils.GetStrNameToCode(mylist_user, Grid1.Rows[i].Values[2].ToString()) + "," + Utils.GetStrNameToCode(mylist_user, Grid1.Rows[i].Values[6].ToString()); sql += ", " + Utils.GetStrNameToCode(mylist_pjm_product_info, Grid1.Rows[i].Values[3].ToString()) + ");"; rst = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sql); if (rst != 1) { Alert.ShowInTop("save error !"); continue; } } Alert.Show("OK"); } catch (Exception ex) { Alert.ShowInTop(ex.Message); } }