示例#1
0
        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);
                    }
                }
            }
        }
示例#2
0
        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);
                }
            }
        }
示例#3
0
        //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);
            }
        }