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