using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using SQLHelper;
|
using DBUtility;
|
|
namespace BLL
|
{
|
public partial class Xt_Authorization : Form
|
{
|
public Xt_Authorization()
|
{
|
InitializeComponent();
|
}
|
ClsCN oCn = new ClsCN();
|
TreeNode CurNode = new TreeNode();
|
|
public string czybm; //Óû§±àÂë
|
public long HGroupID; //×éid
|
public string sDisplay; //ÅжÏÊÇÓû§È¨ÏÞ »¹ÊÇ ×é
|
|
public string Group_Authorization=""; //ȨÏÞ×Ö·û´®
|
public string Group_ID;
|
public string gnbm;
|
//string[] AuthCode = new string[50];
|
//string[] AuthTF = new string[50];
|
string[] AuthCode;
|
string[] AuthTF;
|
private void Authorization()
|
{
|
DataSet Ds;
|
if (sDisplay == "Óû§")
|
{
|
Ds = oCn.RunProcReturn("select * from Gy_Czygl where czybm='" + czybm + "'", "Gy_Czygl");
|
Group_Authorization =ClsPub.isStrNull( Ds.Tables[0].Rows[0]["AuthorityID"]);
|
Group_ID = czybm;
|
}
|
else
|
{
|
Ds = oCn.RunProcReturn("select * from System_UserGroup where GroupID=" + HGroupID, "System_UserGroup");
|
Group_Authorization =ClsPub.isStrNull( Ds.Tables[0].Rows[0]["AuthorityID"]);
|
Group_ID =ClsPub.isStrNull( HGroupID);
|
}
|
Ds = null;
|
}
|
|
//´°Ìå¼ÓÔØ
|
private void Xt_Authorization_Load(object sender, EventArgs e)
|
{
|
Authorization();
|
this.Text = "ȨÏÞ¹ÜÀí" + " -- " + sDisplay;
|
LoadTree();
|
initGrid();
|
if (sDisplay == "Óû§")
|
{
|
Display1("");
|
}
|
else
|
{
|
Display2("");
|
}
|
//
|
sq.Enabled = false;
|
}
|
|
//¼ÓÔØÊ÷ÐÎ
|
private void LoadTree()
|
{
|
try
|
{
|
tv.Nodes.Clear();
|
tv.ImageList = imageList1;
|
TreeNode sNode = tv.Nodes.Add("T ", this.Text, 0, 1);
|
//sNode.Expand();
|
LoadAllNodes(sNode);
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("¼ÓÔØÊ÷ÐÍʧ°Ü£¡" + e.Message, "Ìáʾ");
|
}
|
}
|
//¼ÓÔØ×Ó½áµã
|
private void LoadAllNodes(TreeNode sNode)
|
{
|
if (sNode != null)
|
{
|
try
|
{
|
string sName = sNode.Name.Substring(1, sNode.Name.Length - 1);
|
sNode.Nodes.Clear();
|
DataSet Ds = oCn.RunProcReturn("select * from Xt_Xtgnb where useflag=1 and rightflag=1 and (gnbm NOT LIKE '99%') and sjgnbm='" + sName + "' and mjbz=0 order by gnbm ", "Xt_Xtgnb");
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["gnbm"].ToString().Trim(), Ds.Tables[0].Rows[i]["gnmc"].ToString().Trim(), 0, 1);
|
|
}
|
sNode.Expand();
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show("¼ÓÔØ×ÓÏîĿʧ°Ü£¡" + e.Message, "Ìáʾ");
|
}
|
}
|
}
|
//Ê÷ÐÍ µ¥»÷
|
private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
|
{
|
CurNode = e.Node;
|
if (CurNode != null)
|
{
|
if (sq.Enabled == true)
|
{
|
if (MessageBox.Show("ÄãÊÇ·ñÒª±£´æȨÏÞ? ", "Ìáʾ", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
|
{
|
SQ();
|
}
|
else
|
{
|
sq.Enabled = false;
|
}
|
}
|
if (CurNode.Nodes.Count == 0)
|
LoadAllNodes(CurNode);
|
//ÕÒµ½Ñ¡Öнáµã
|
if (CurNode.Name != "T ")
|
{
|
string sName = CurNode.Name.Substring(1, CurNode.Name.Length - 1);
|
gnbm = sName;
|
if (sDisplay == "Óû§")
|
{
|
Display1(sName);
|
}
|
else
|
{
|
Display2(sName);
|
}
|
}
|
else
|
{
|
if (sDisplay == "Óû§")
|
{
|
Display1("");
|
}
|
else
|
{
|
Display2("");
|
}
|
}
|
}
|
}
|
//Íø¸ñ³õʼ»¯
|
private void initGrid()
|
{
|
//Íø¸ñ--Óû§
|
grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect; //Ñ¡ÖÐģʽ--ÐÐÑ¡ÖÐ
|
grdMain.ColumnHeadersVisible = true; //±êÌâÁÐÏÔʾ--ÊÇ
|
grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //±êÌâÁгߴçģʽ--£¨×Ô¶¯µ÷Õû£¬¿Éµ÷Õû£©
|
grdMain.RowTemplate.Height = 18;
|
grdMain.RowTemplate.MinimumHeight = 18;
|
grdMain.ColumnHeadersHeight = 35; //±êÌâÐиß
|
grdMain.RowHeadersVisible = false; //±êÌâÐпɼû--·ñ
|
grdMain.AllowUserToAddRows = false; //ÊÇ·ñÔÊÐí×ÔÔö--·ñ
|
grdMain.AllowUserToDeleteRows = false; //ÊÇ·ñÔÊÐíɾ³ý--·ñ
|
grdMain.ColumnCount = 3; //×ÜÁÐÊý--5
|
grdMain.RowCount = 0;
|
grdMain.AllowUserToResizeColumns = true; //ÔÊÐíµ÷ÕûÁпí--ÊÇ
|
grdMain.AllowUserToResizeRows = false; //ÔÊÐíµ÷ÕûÐиß--·ñ
|
grdMain.ReadOnly = false; //Ö»¶Á--ÊÇ
|
grdMain.BackgroundColor = Color.White;
|
grdMain.GridColor = Color.LightGray;
|
grdMain.DefaultCellStyle.SelectionBackColor = Color.Black;
|
grdMain.EnableHeadersVisualStyles = false; //Íø¸ñ±êÌâ Ñùʽ
|
|
//grdMain.Columns[0].HeaderText = "hid";
|
//grdMain.Columns[2].HeaderText = "¹¦ÄÜ˵Ã÷";
|
//grdMain.Columns[1].HeaderText = "ÊÇ·ñȨÏÞ";
|
|
//DataGridViewCheckBoxColumn newColumn = new DataGridViewCheckBoxColumn();
|
//newColumn.HeaderText = "ÊÇ·ñȨÏÞ";
|
//grdMain.Columns.Insert(1, newColumn);
|
//grdMain.Columns[1].HeaderText = "ÊÇ·ñȨÏÞ";
|
}
|
//²éÕÒÊý¾Ý----Óû§Ä£¿é
|
private void Display1(string sGnbm)
|
{
|
try
|
{
|
ClsCN oCn = new ClsCN();
|
DataSet oDs = new DataSet(); //
|
oDs = oCn.RunProcReturn("SELECT id hid,case when id<=" + Group_Authorization.Length + " then case when SUBSTRING('" + Group_Authorization + "',id,1)=1 then 1 else 0 end else 0 end ÊÇ·ñȨÏÞ,gnms ¹¦ÄÜ˵Ã÷,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sGnbm + "' and rightflag=1 order by gnbm", "xt_xtgnb");
|
if (oDs == null)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü£¡ÔÒò£º" + ClsPub.sExeReturnInfo);
|
return;
|
}
|
//
|
if (oDs.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
//
|
grdMain.RowCount = 0;
|
AuthCode = new string[oDs.Tables[0].Rows.Count];
|
AuthTF = new string[oDs.Tables[0].Rows.Count];
|
for (int i = 0; i < oDs.Tables[0].Rows.Count; i++)
|
{
|
grdMain.RowCount = grdMain.RowCount + 1;
|
grdMain.Rows[i].Cells[0].Value = ClsPub.isInt(oDs.Tables[0].Rows[i]["hid"]);
|
grdMain.Rows[i].Cells[1].Value = ClsPub.isBool(oDs.Tables[0].Rows[i]["ÊÇ·ñȨÏÞ"]);
|
grdMain.Rows[i].Cells[2].Value = ClsPub.isStrNull(oDs.Tables[0].Rows[i]["¹¦ÄÜ˵Ã÷"]);
|
AuthCode[i] = ClsPub.isStrNull(oDs.Tables[0].Rows[i]["hgnbm"]);
|
}
|
//
|
//grdMain.DataSource = oDs.Tables[0].DefaultView;
|
//¼ÓÔØÁпí
|
for (int i = 0; i < grdMain.ColumnCount; i++)
|
{
|
grdMain.Columns[i].Width = 100;
|
grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
|
if (grdMain.Columns[i].HeaderText.Substring(0, 1).ToLower() == "h")
|
{
|
grdMain.Columns[i].Visible = false;
|
}
|
else
|
{
|
grdMain.Columns[i].Visible = true;
|
}
|
}
|
ClsPub.GetGridView(this.grdMain, this.Name,Pub_Class.ClsPub.AppPath);
|
grdMain.Columns[Fun_GetCol("¹¦ÄÜ˵Ã÷")].ReadOnly = true;
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show(e.Message, "Ìáʾ");
|
return;
|
}
|
}
|
//²éÕÒÊý¾Ý----Óû§×éÄ£¿é
|
private void Display2(string sGnbm)
|
{
|
try
|
{
|
ClsCN oCn = new ClsCN();
|
DataSet oDs = new DataSet(); //
|
oDs = oCn.RunProcReturn("SELECT id hid,case when id<=" + Group_Authorization.Length + " then case when SUBSTRING('" + Group_Authorization + "',id,1)=1 then 1 else 0 end else 0 end ÊÇ·ñȨÏÞ,gnms ¹¦ÄÜ˵Ã÷,gnbm hgnbm FROM xt_xtgnb where useflag=1 and sjgnbm='" + sGnbm + "' and rightflag=1 order by gnbm", "xt_xtgnb");
|
if (oDs == null)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü£¡ÔÒò£º" + ClsPub.sExeReturnInfo);
|
return;
|
}
|
//
|
if (oDs.Tables[0].Rows.Count == 0)
|
{
|
return;
|
}
|
//
|
grdMain.RowCount = 0;
|
AuthCode = new string[oDs.Tables[0].Rows.Count];
|
AuthTF = new string[oDs.Tables[0].Rows.Count];
|
for (int i = 0; i < oDs.Tables[0].Rows.Count; i++)
|
{
|
grdMain.RowCount = grdMain.RowCount + 1;
|
grdMain.Rows[i].Cells[0].Value = ClsPub.isInt(oDs.Tables[0].Rows[i]["hid"]);
|
grdMain.Rows[i].Cells[1].Value = ClsPub.isBool(oDs.Tables[0].Rows[i]["ÊÇ·ñȨÏÞ"]);
|
grdMain.Rows[i].Cells[2].Value = ClsPub.isStrNull(oDs.Tables[0].Rows[i]["¹¦ÄÜ˵Ã÷"]);
|
AuthCode[i] = ClsPub.isStrNull(oDs.Tables[0].Rows[i]["hgnbm"]);
|
}
|
//
|
//grdMain.DataSource = oDs.Tables[0].DefaultView;
|
//¼ÓÔØÁпí
|
for (int i = 0; i < grdMain.ColumnCount; i++)
|
{
|
grdMain.Columns[i].Width = 100;
|
grdMain.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
|
if (grdMain.Columns[i].HeaderText.Substring(0, 1).ToLower() == "h")
|
{
|
grdMain.Columns[i].Visible = false;
|
}
|
else
|
{
|
grdMain.Columns[i].Visible = true;
|
}
|
}
|
ClsPub.GetGridView(this.grdMain, this.Name, Pub_Class.ClsPub.AppPath);
|
grdMain.Columns[Fun_GetCol("¹¦ÄÜ˵Ã÷")].ReadOnly = true;
|
}
|
catch (Exception e)
|
{
|
MessageBox.Show(e.Message, "Ìáʾ");
|
return;
|
}
|
}
|
//µÃµ½¶ÔÓ¦ÁÐ
|
private Int32 Fun_GetCol(string sCol)//Lock
|
{
|
for (int c = 0; c < grdMain.ColumnCount; c++)
|
{
|
if (ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
|
{
|
return c;
|
}
|
}
|
return 0;
|
}
|
//Í˳ö
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//±£´æÁпí
|
ClsPub.SaveGridView(grdMain, this.Name,Pub_Class.ClsPub.AppPath);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
ClsPub.DefaultGridView(grdMain);
|
//²ÎÊý½âÊÍ ¿ªÊ¼ÁÐ £¬½áÊøÁУ¬ÊÇ·ñÒÔ×î´óÁпíΪ׼£¬×îСÁпí
|
ClsPub.SaveGridView(grdMain, this.Name, Pub_Class.ClsPub.AppPath);
|
}
|
//ÊÚȨ
|
private void sq_Click(object sender, EventArgs e)
|
{
|
SQ();
|
}
|
private void SQ()
|
{
|
//string qq = "0000100000";
|
//int qqa = 5;
|
//int qqb = qq.Length - qqa;
|
//string qqc = qq.Substring(0, qqa - 1) + "2" + qq.Substring(qqa, qq.Length - qqa);
|
//MessageBox.Show(qq.Substring(0,qqa-1)+"2"+qq.Substring(qqa, qq.Length - qqa ));
|
//MessageBox.Show(qq.Substring(0, qqa - 1));
|
//MessageBox.Show(qq.Substring(qqa, qq.Length - qqa));
|
//MessageBox.Show(qqc.Substring(qqa-1, 1));
|
|
ClsCN oCn = new ClsCN();
|
DataSet oDs = new DataSet();
|
int c = Fun_GetCol("ÊÇ·ñȨÏÞ");
|
int Hid = Fun_GetCol("Hid");
|
tv.Focus();
|
string MKID = "";
|
int lENSTR = 0; //Ä£¿éID
|
string Auth_str = Group_Authorization;
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
MKID = ClsPub.isStrNull(grdMain.Rows[i].Cells[Hid].Value);
|
lENSTR = ClsPub.isInt(MKID.Substring(0, MKID.Length ));
|
if (ClsPub.isBool( grdMain.Rows[i].Cells[c].Value) == true)
|
{
|
for (int h = Auth_str.Trim().Length; h <= lENSTR - 1; h++)
|
{
|
Auth_str = Auth_str.Trim() + "0";
|
}
|
|
Auth_str = Auth_str.Substring(0, lENSTR - 1) + "1" + Auth_str.Substring(lENSTR , Auth_str.Length-lENSTR);
|
}
|
else
|
{
|
if (Auth_str.Length >= lENSTR)
|
{
|
Auth_str = Auth_str.Substring(0, lENSTR - 1) + "0" + Auth_str.Substring(lENSTR , Auth_str.Length-lENSTR);
|
}
|
}
|
oDs = oCn.RunProcReturn("select * from xt_xtgnb where useflag=1 and gnbm like '" + AuthCode[i] + "%'", "xt_xtgnb");
|
if (oDs.Tables[0].Rows.Count != 0)
|
{
|
for (int k = 0; k < oDs.Tables[0].Rows.Count; k++)
|
{
|
int ID = ClsPub.isInt(oDs.Tables[0].Rows[k]["id"]);
|
if (ClsPub.isBool(grdMain.Rows[i].Cells[c].Value) == true)
|
{
|
if (AuthTF[i] == "1")
|
{
|
for (int h = Auth_str.Trim().Length; h <=ID - 1; h++)
|
{
|
Auth_str = Auth_str.Trim() + "0";
|
}
|
Auth_str = Auth_str.Substring(0, ID - 1) + "1" + Auth_str.Substring(ID, Auth_str.Length - ID);
|
}
|
}
|
else
|
{
|
if (Auth_str.Length >= ID)
|
{
|
Auth_str = Auth_str.Substring(0, ID - 1) + "0" + Auth_str.Substring(ID, Auth_str.Length - ID);
|
}
|
}
|
}
|
}
|
oDs = null;
|
}
|
|
if (sDisplay == "Óû§")
|
{
|
oCn.RunProc("UPDATE Gy_Czygl SET AuthorityID='" + Auth_str + "' WHERE czybm='" + Group_ID.Trim() + "'");
|
}
|
else
|
{
|
oCn.RunProc("UPDATE System_UserGroup SET AuthorityID='" + Auth_str + "' WHERE GroupID=" + Group_ID);
|
}
|
sq.Enabled = false;
|
|
Authorization();
|
}
|
//ɾ³ýÈ«²¿È¨ÏÞ
|
private void sc_Click(object sender, EventArgs e)
|
{
|
int c = Fun_GetCol("ÊÇ·ñȨÏÞ");
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
grdMain.Rows[i].Cells[c].Value = false ;
|
}
|
|
sq.Enabled = true;
|
}
|
//Ñ¡ÖÐÐи³ÖµÈ¨ÏÞ
|
private void qx_Click(object sender, EventArgs e)
|
{
|
tv.Focus();
|
int c = Fun_GetCol("ÊÇ·ñȨÏÞ");
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (ClsPub.isBool(ClsPub.isBool( grdMain.Rows[i].Cells[c].Value ))== false)
|
{
|
AuthTF[i] = "1";
|
grdMain.Rows[i].Cells[c].Value = true;
|
}
|
}
|
sq.Enabled = true;
|
}
|
|
private void grdMain_CellValueChanged(object sender, DataGridViewCellEventArgs e)
|
{
|
//if (e.ColumnIndex == 1)
|
//{
|
// sq.Enabled = true;
|
// AuthTF[e.RowIndex] = "1";
|
//}
|
}
|
|
private void grdMain_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
|
{
|
if (e.ColumnIndex == 1)
|
{
|
sq.Enabled = true;
|
AuthTF[e.RowIndex] = "1";
|
}
|
|
|
//DataGridViewCheckBoxCell checkBoxCell = this.grdMain[e.ColumnIndex, e.RowIndex] as DataGridViewCheckBoxCell;
|
|
//if (checkBoxCell != null)
|
//{
|
// if (object.Equals(checkBoxCell.EditingCellFormattedValue, true))
|
// {
|
// if (ClsPub.isBool(grdMain.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) == false)
|
// {
|
// sq.Enabled = true;
|
// AuthTF[e.RowIndex] = "1";
|
// }
|
// }
|
// else
|
// {
|
// if (ClsPub.isBool(grdMain.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) == true)
|
// {
|
// sq.Enabled = true;
|
// AuthTF[e.RowIndex] = "1";
|
// }
|
// }
|
// //Console.WriteLine(checkBoxCell.EditingCellFormattedValue);
|
// //Console.WriteLine(checkBoxCell.Value);
|
//}
|
}
|
private void grdMain_CellClick(object sender, DataGridViewCellEventArgs e)
|
{
|
|
}
|
|
private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
|
}
|
|
private void grdMain_CellLeave(object sender, DataGridViewCellEventArgs e)
|
{
|
|
}
|
|
}
|
}
|
