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 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); } }