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