?? mymodule.cs
字號:
/// 顯示指定用戶的權限.
/// </summary>
/// <param name="GBox">GroupBox控件的數據集</param>
/// <param name="TName">獲取用戶編號</param>
public void Show_Pope(Control.ControlCollection GBox, string TID)
{
string sID = "";
string CheckName = "";
bool t = false;
DataSet DSet = MyDataClass.getDataSet("select ID,PopeName,Pope from tb_UserPope where ID='" + TID + "'", "tb_UserPope");
for (int i = 0; i < DSet.Tables[0].Rows.Count; i++)
{
sID = Convert.ToString(DSet.Tables[0].Rows[i][1]);
if ((int)(DSet.Tables[0].Rows[i][2]) == 1)
t = true;
else
t = false;
foreach (Control C in GBox)
{
if (C.GetType().Name == "CheckBox")
{
CheckName = C.Name;
if (CheckName.IndexOf(sID) > -1)
{
((CheckBox)C).Checked = t;
}
}
}
}
}
#endregion
#region 修改指定用戶權限
/// <summary>
/// 修改指定用戶的權限.
/// </summary>
/// <param name="GBox">GroupBox控件的數據集</param>
/// <param name="TName">獲取用戶編號</param>
public void Amend_Pope(Control.ControlCollection GBox, string TID)
{
string CheckName = "";
int tt = 0;
foreach (Control C in GBox)
{
if (C.GetType().Name == "CheckBox")
{
if (((CheckBox)C).Checked)
tt = 1;
else
tt = 0;
CheckName = C.Name;
string[] Astr = CheckName.Split(Convert.ToChar('_'));
MyDataClass.getsqlcom("update tb_UserPope set Pope=" + tt + " where (ID='" + TID + "') and (PopeName='" + Astr[1].Trim() + "')");
}
}
}
#endregion
#region 設置主窗體菜單不可用
/// <summary>
/// 設置主窗體菜單不可用.
/// </summary>
/// <param name="MenuS">MenuStrip控件</param>
public void MainMenuF(MenuStrip MenuS)
{
string Men = "";
for (int i = 0; i < MenuS.Items.Count; i++)
{
Men = ((ToolStripDropDownItem)MenuS.Items[i]).Name;
if (Men.IndexOf("Menu") == -1)
((ToolStripDropDownItem)MenuS.Items[i]).Enabled = false;
ToolStripDropDownItem newmenu = (ToolStripDropDownItem)MenuS.Items[i];
if (newmenu.HasDropDownItems && newmenu.DropDownItems.Count > 0)
for (int j = 0; j < newmenu.DropDownItems.Count; j++)
{
Men = newmenu.DropDownItems[j].Name;
if (Men.IndexOf("Menu") == -1)
newmenu.DropDownItems[j].Enabled = false;
ToolStripDropDownItem newmenu2 = (ToolStripDropDownItem)newmenu.DropDownItems[j];
if (newmenu2.HasDropDownItems && newmenu2.DropDownItems.Count > 0)
for (int p = 0; p < newmenu2.DropDownItems.Count; p++)
newmenu2.DropDownItems[p].Enabled = false;
}
}
}
#endregion
#region 根據用戶權限設置主窗體菜單
/// <summary>
/// 根據用戶權限設置菜單是否可用.
/// </summary>
/// <param name="MenuS">MenuStrip控件</param>
/// <param name="UName">當前登錄用戶名</param>
public void MainPope(MenuStrip MenuS, String UName)
{
string Str = "";
string MenuName = "";
DataSet DSet = MyDataClass.getDataSet("select ID from tb_Login where Name='" + UName + "'", "tb_Login"); //獲取當前登錄用戶的信息
string UID = Convert.ToString(DSet.Tables[0].Rows[0][0]); //獲取當前用戶編號
DSet = MyDataClass.getDataSet("select ID,PopeName,Pope from tb_UserPope where ID='" + UID + "'", "tb_UserPope"); //獲取當前用戶的權限信息
bool bo = false;
for (int k = 0; k < DSet.Tables[0].Rows.Count; k++) //遍歷當前用戶的權限名稱
{
Str = Convert.ToString(DSet.Tables[0].Rows[k][1]); //獲取權限名稱
if (Convert.ToInt32(DSet.Tables[0].Rows[k][2]) == 1) //判斷權限是否可用
bo = true;
else
bo = false;
for (int i = 0; i < MenuS.Items.Count; i++) //遍歷菜單欄中的一級菜單項
{
ToolStripDropDownItem newmenu = (ToolStripDropDownItem)MenuS.Items[i]; //記錄當前菜單項下的所有信息
if (newmenu.HasDropDownItems && newmenu.DropDownItems.Count > 0) //如果當前菜單項有子級菜單項
for (int j = 0; j < newmenu.DropDownItems.Count; j++) //遍歷二級菜單項
{
MenuName = newmenu.DropDownItems[j].Name; //獲取當前菜單項的名稱
if (MenuName.IndexOf(Str) > -1) //如果包含權限名稱
newmenu.DropDownItems[j].Enabled = bo; //根據權限設置可用狀態
ToolStripDropDownItem newmenu2 = (ToolStripDropDownItem)newmenu.DropDownItems[j]; //記錄當前菜單項的所有信息
if (newmenu2.HasDropDownItems && newmenu2.DropDownItems.Count > 0) //如果當前菜單項有子級菜單項
for (int p = 0; p < newmenu2.DropDownItems.Count; p++) //遍歷三級菜單項
{
MenuName = newmenu2.DropDownItems[p].Name; //獲取當前菜單項的名稱
if (MenuName.IndexOf(Str) > -1) //如果包含權限名稱
newmenu2.DropDownItems[p].Enabled = bo; //根據權限設置可用狀態
}
}
}
}
}
#endregion
#region 用TreeView控件調用StatusStrip控件下各菜單的單擊事件
/// <summary>
/// 用TreeView控件調用StatusStrip控件下各菜單的單擊事件.
/// </summary>
/// <param name="MenuS">MenuStrip控件</param>
/// <param name="e">TreeView控件的TreeNodeMouseClickEventArgs類</param>
public void TreeMenuF(MenuStrip MenuS, TreeNodeMouseClickEventArgs e)
{
string Men = "";
for (int i = 0; i < MenuS.Items.Count; i++) //遍歷MenuStrip控件中主菜單項
{
Men = ((ToolStripDropDownItem)MenuS.Items[i]).Name; //獲取主菜單項的名稱
if (Men.IndexOf("Menu") == -1) //如果MenuStrip控件的菜單項沒有子菜單
{
if (((ToolStripDropDownItem)MenuS.Items[i]).Text == e.Node.Text) //當節點名稱與菜單項名稱相等時
if (((ToolStripDropDownItem)MenuS.Items[i]).Enabled == false) //判斷當前菜單項是否可用
{
MessageBox.Show("當前用戶無權限調用" + "\"" + e.Node.Text + "\"" + "窗體");
break;
}
else
Show_Form(((ToolStripDropDownItem)MenuS.Items[i]).Text.Trim(), 1); //調用相應的窗體
}
ToolStripDropDownItem newmenu = (ToolStripDropDownItem)MenuS.Items[i];
if (newmenu.HasDropDownItems && newmenu.DropDownItems.Count > 0) //遍歷二級菜單項
for (int j = 0; j < newmenu.DropDownItems.Count; j++)
{
Men = newmenu.DropDownItems[j].Name; //獲取二級菜單項的名稱
if (Men.IndexOf("Menu") == -1)
{
if ((newmenu.DropDownItems[j]).Text == e.Node.Text)
if ((newmenu.DropDownItems[j]).Enabled == false)
{
MessageBox.Show("當前用戶無權限調用" + "\"" + e.Node.Text + "\"" + "窗體");
break;
}
else
Show_Form((newmenu.DropDownItems[j]).Text.Trim(), 1);
}
ToolStripDropDownItem newmenu2 = (ToolStripDropDownItem)newmenu.DropDownItems[j];
if (newmenu2.HasDropDownItems && newmenu2.DropDownItems.Count > 0) //遍歷三級菜單項
for (int p = 0; p < newmenu2.DropDownItems.Count; p++)
{
if ((newmenu2.DropDownItems[p]).Text == e.Node.Text)
if ((newmenu2.DropDownItems[p]).Enabled == false)
{
MessageBox.Show("當前用戶無權限調用" + "\"" + e.Node.Text + "\"" + "窗體");
break;
}
else
if ((newmenu2.DropDownItems[p]).Text.Trim() == "員工生日提示" || (newmenu2.DropDownItems[p]).Text.Trim() == "員工合同提示")
Show_Form((newmenu2.DropDownItems[p]).Text.Trim(), 1);
else
Show_Form((newmenu2.DropDownItems[p]).Text.Trim(), 2);
}
}
}
}
#endregion
#region 查詢指定范圍內生日與合同到期的職工
/// <summary>
/// 查詢指定范圍內生日與合同到期的職工.
/// </summary>
/// <param name="i">標識，判斷查詢的是生日，還是合同</param>
public void PactDay(int i)
{
DataSet DSet = MyDataClass.getDataSet("select * from tb_Clew where kind=" + i + " and unlock=1", "tb_clew");
if (DSet.Tables[0].Rows.Count > 0)
{
string Vfield = "";
string dSQL = "";
int sday = Convert.ToInt32(DSet.Tables[0].Rows[0][1]);
if (i == 1)
{
Vfield = "Birthday";
dSQL = "select * from tb_Stuffbusic where (datediff(day,getdate(),convert(Nvarchar(12),cast (cast (year(getdate()) as char(4))+'-'+ cast(month(" + Vfield + ") as char(2))+'-'+ cast (day(" + Vfield + ") as char(2)) as datetime),110))<=" + sday + ") and (datediff(day,getdate(),convert(Nvarchar(12),cast (cast (year(getdate()) as char(4))+'-'+ cast(month(" + Vfield + ") as char(2))+'-'+cast (day(" + Vfield + ") as char(2)) as datetime),110))>=0)";
}
else
{
Vfield = "Pact_E";
dSQL = "select * from tb_Stuffbusic where ((getdate()-convert(Nvarchar(12)," + Vfield + ",110))>=-" + sday + " and (getdate()-convert(Nvarchar(12)," + Vfield + ",110))<=0)";
}
DSet = MyDataClass.getDataSet(dSQL, "tb_Stuffbusic");
if (DSet.Tables[0].Rows.Count > 0)
{
if (i == 1)
Vfield = "是否查看" + sday.ToString() + "天內過生日的職工信息？";
else
Vfield = "是否查看" + sday.ToString() + "天內合同到期的職工信息？";
if (MessageBox.Show(Vfield, "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
DataClass.MyMeans.AllSql = dSQL;
Show_Form("人事檔案瀏覽", 1);
}
}
}
}
#endregion
#region 將圖片存儲到數據庫中
/// <summary>
/// 以二進制的形式將圖片存儲到數據庫中.
/// </summary>
/// <param name="MID">職工編號</param>
/// <param name="p">圖片的二進制形式</param>
public void SaveImage(string MID, byte[] p)
{
MyDataClass.con_open();
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_Stuffbusic Set Photo=@Photo where ID="+MID);
SqlCommand cmd = new SqlCommand(strSql.ToString(), DataClass.MyMeans.My_con);
cmd.Parameters.Add("@Photo", SqlDbType.Binary).Value = p;
cmd.ExecuteNonQuery();
DataClass.MyMeans.My_con.Close();
}
#endregion
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -