?? mainfrm.cs
字號(hào):
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace 進(jìn)銷(xiāo)存管理系統(tǒng)
{
/// <summary>
/// Form1 的摘要說(shuō)明。
/// </summary>
public class MainFrm : System.Windows.Forms.Form
{
private DataSet ds = new DataSet();
private LinkDataBase link = new LinkDataBase();
private string sendTableName = "權(quán)限清單";
private string sendStrSQL;
private System.Windows.Forms.MainMenu mainMenu1;
private System.Windows.Forms.MenuItem menuItem1;
private System.Windows.Forms.MenuItem menuItem2;
private System.Windows.Forms.MenuItem menuItem3;
private System.Windows.Forms.MenuItem menuItem4;
private System.Windows.Forms.MenuItem menuItem5;
private System.Windows.Forms.MenuItem mnu_WareDataManage;
private System.Windows.Forms.MenuItem mnu_StokerDataManage;
private System.Windows.Forms.MenuItem mnu_ClientDataManage;
private System.Windows.Forms.MenuItem mnu_StockTable;
private System.Windows.Forms.MenuItem mnu_StorageSearch;
private System.Windows.Forms.MenuItem mnu_PopedomManage;
private System.Windows.Forms.MenuItem mnu_SellTable;
private System.Windows.Forms.StatusBar statusBar1;
private System.Windows.Forms.StatusBarPanel statusBarPanel1;
private System.Windows.Forms.StatusBarPanel statusBarPanel2;
private System.Windows.Forms.MenuItem menuItemQuit;
/// <summary>
/// 必需的設(shè)計(jì)器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public MainFrm()
{
//
// Windows 窗體設(shè)計(jì)器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設(shè)計(jì)器生成的代碼
/// <summary>
/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.mainMenu1 = new System.Windows.Forms.MainMenu();
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.mnu_WareDataManage = new System.Windows.Forms.MenuItem();
this.mnu_StokerDataManage = new System.Windows.Forms.MenuItem();
this.mnu_ClientDataManage = new System.Windows.Forms.MenuItem();
this.menuItem2 = new System.Windows.Forms.MenuItem();
this.mnu_StockTable = new System.Windows.Forms.MenuItem();
this.menuItem3 = new System.Windows.Forms.MenuItem();
this.mnu_SellTable = new System.Windows.Forms.MenuItem();
this.menuItem4 = new System.Windows.Forms.MenuItem();
this.mnu_StorageSearch = new System.Windows.Forms.MenuItem();
this.menuItem5 = new System.Windows.Forms.MenuItem();
this.mnu_PopedomManage = new System.Windows.Forms.MenuItem();
this.menuItemQuit = new System.Windows.Forms.MenuItem();
this.statusBar1 = new System.Windows.Forms.StatusBar();
this.statusBarPanel1 = new System.Windows.Forms.StatusBarPanel();
this.statusBarPanel2 = new System.Windows.Forms.StatusBarPanel();
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).BeginInit();
this.SuspendLayout();
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1,
this.menuItem2,
this.menuItem3,
this.menuItem4,
this.menuItem5,
this.menuItemQuit});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnu_WareDataManage,
this.mnu_StokerDataManage,
this.mnu_ClientDataManage});
this.menuItem1.Text = "資料管理";
//
// mnu_WareDataManage
//
this.mnu_WareDataManage.Enabled = false;
this.mnu_WareDataManage.Index = 0;
this.mnu_WareDataManage.Text = "商品信息維護(hù)";
this.mnu_WareDataManage.Click += new System.EventHandler(this.mnu_WareDataManage_Click);
//
// mnu_StokerDataManage
//
this.mnu_StokerDataManage.Enabled = false;
this.mnu_StokerDataManage.Index = 1;
this.mnu_StokerDataManage.Text = "供貨商信息維護(hù)";
this.mnu_StokerDataManage.Click += new System.EventHandler(this.mnu_StokerDataManage_Click);
//
// mnu_ClientDataManage
//
this.mnu_ClientDataManage.Enabled = false;
this.mnu_ClientDataManage.Index = 2;
this.mnu_ClientDataManage.Text = "客戶(hù)信息維護(hù)";
this.mnu_ClientDataManage.Click += new System.EventHandler(this.mnu_ClientDataManage_Click);
//
// menuItem2
//
this.menuItem2.Index = 1;
this.menuItem2.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnu_StockTable});
this.menuItem2.Text = "進(jìn)貨管理";
//
// mnu_StockTable
//
this.mnu_StockTable.Enabled = false;
this.mnu_StockTable.Index = 0;
this.mnu_StockTable.Text = "進(jìn)貨單";
this.mnu_StockTable.Click += new System.EventHandler(this.mnu_StockTable_Click);
//
// menuItem3
//
this.menuItem3.Index = 2;
this.menuItem3.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnu_SellTable});
this.menuItem3.Text = "銷(xiāo)售管理";
//
// mnu_SellTable
//
this.mnu_SellTable.Enabled = false;
this.mnu_SellTable.Index = 0;
this.mnu_SellTable.Text = "銷(xiāo)售單";
this.mnu_SellTable.Click += new System.EventHandler(this.mnu_SellTable_Click);
//
// menuItem4
//
this.menuItem4.Index = 3;
this.menuItem4.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnu_StorageSearch});
this.menuItem4.Text = "庫(kù)存管理";
//
// mnu_StorageSearch
//
this.mnu_StorageSearch.Enabled = false;
this.mnu_StorageSearch.Index = 0;
this.mnu_StorageSearch.Text = "庫(kù)存查詢(xún)";
this.mnu_StorageSearch.Click += new System.EventHandler(this.mnu_StorageSearch_Click);
//
// menuItem5
//
this.menuItem5.Index = 4;
this.menuItem5.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.mnu_PopedomManage});
this.menuItem5.Text = "系統(tǒng)管理";
//
// mnu_PopedomManage
//
this.mnu_PopedomManage.Enabled = false;
this.mnu_PopedomManage.Index = 0;
this.mnu_PopedomManage.Text = "權(quán)限管理";
this.mnu_PopedomManage.Click += new System.EventHandler(this.mnu_PopedomManage_Click);
//
// menuItemQuit
//
this.menuItemQuit.Index = 5;
this.menuItemQuit.Text = "退出系統(tǒng)";
this.menuItemQuit.Click += new System.EventHandler(this.menuItemQuit_Click);
//
// statusBar1
//
this.statusBar1.Location = new System.Drawing.Point(0, 551);
this.statusBar1.Name = "statusBar1";
this.statusBar1.Panels.AddRange(new System.Windows.Forms.StatusBarPanel[] {
this.statusBarPanel1,
this.statusBarPanel2});
this.statusBar1.ShowPanels = true;
this.statusBar1.Size = new System.Drawing.Size(792, 22);
this.statusBar1.TabIndex = 1;
//
// statusBarPanel1
//
this.statusBarPanel1.Alignment = System.Windows.Forms.HorizontalAlignment.Center;
this.statusBarPanel1.MinWidth = 200;
this.statusBarPanel1.Text = "《數(shù)據(jù)庫(kù)開(kāi)發(fā)經(jīng)典案例解析》 清華大學(xué)出版社";
this.statusBarPanel1.Width = 300;
//
// statusBarPanel2
//
this.statusBarPanel2.MinWidth = 200;
this.statusBarPanel2.Width = 300;
//
// MainFrm
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(792, 573);
this.Controls.Add(this.statusBar1);
this.IsMdiContainer = true;
this.Menu = this.mainMenu1;
this.Name = "MainFrm";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【進(jìn)銷(xiāo)存管理系統(tǒng)】";
this.Load += new System.EventHandler(this.MainFrm_Load);
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 應(yīng)用程序的主入口點(diǎn)。
/// </summary>
[STAThread]
static void Main()
{
//整個(gè)程序啟動(dòng)時(shí)先顯示登錄框，登錄成功再顯示主界面
LoginFrm login = new LoginFrm();
login.ShowDialog();
if (LoginFrm.blCanLogin==true)
{
Application.Run(new MainFrm());
}
}
//------------創(chuàng)建窗體時(shí)，通過(guò)登錄用戶(hù)的名稱(chēng)和權(quán)限，設(shè)置可以訪(fǎng)問(wèn)的功能--------------
private void MainFrm_Load(object sender, System.EventArgs e)
{
this.statusBarPanel2.Text = " 當(dāng)前用戶(hù): " + LoginFrm.strUser +" 所屬部門(mén): " + LoginFrm.strDepartment;
//通過(guò)用戶(hù)編號(hào)查詢(xún)權(quán)限清單控制主窗體菜單使能狀態(tài)
this.sendStrSQL = "SELECT 權(quán)限名稱(chēng) from 權(quán)限清單 where 用戶(hù)編號(hào) = '" + LoginFrm.strUser +"'";
this.ds = this.link.SelectDataBase(sendStrSQL,sendTableName);
//系統(tǒng)管理用戶(hù)為特殊權(quán)限用戶(hù),他始終擁有所有權(quán)利
if ( LoginFrm.strDepartment == "系統(tǒng)管理")
{
this.mnu_WareDataManage.Enabled = true;
this.mnu_StokerDataManage.Enabled = true;
this.mnu_ClientDataManage.Enabled = true;
this.mnu_StockTable.Enabled = true;
this.mnu_SellTable.Enabled = true;
this.mnu_StorageSearch.Enabled = true;
this.mnu_PopedomManage.Enabled = true;
}
else
{
//根據(jù)從數(shù)據(jù)庫(kù)中檢索到的用戶(hù)的權(quán)限來(lái)設(shè)置其有權(quán)使用的菜單
for (int intCounter=0;intCounter<this.ds.Tables[0].Rows.Count;intCounter++)
{
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "商品資料維護(hù)")
{
this.mnu_WareDataManage.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "供貨商資料維護(hù)")
{
this.mnu_StokerDataManage.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "客戶(hù)資料維護(hù)")
{
this.mnu_ClientDataManage.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "進(jìn)貨單")
{
this.mnu_StockTable.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "銷(xiāo)售單")
{
this.mnu_SellTable.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "庫(kù)存查詢(xún)")
{
this.mnu_StorageSearch.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "權(quán)限管理")
{
this.mnu_PopedomManage.Enabled = true; continue;
}
}
}
}
//-----------------查詢(xún)一個(gè)子窗體是否存在----------------
private bool checkChildFrmExist(string childFrmName)
{
foreach(Form childFrm in this.MdiChildren)
{
//用子窗體的Name進(jìn)行判斷，如果已經(jīng)存在則將他激活
if(childFrm.Name == childFrmName)
{
if(childFrm.WindowState == FormWindowState.Minimized)
childFrm.WindowState = FormWindowState.Normal;
childFrm.Activate();
return true;
}
}
return false;
}
//-----------顯示商品信息維護(hù)窗口----------
private void mnu_WareDataManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("WareDataManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)商品信息維護(hù)窗體
WareDataManage newFrm = new WareDataManage(true);
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示供貨商信息維護(hù)窗口----------
private void mnu_StokerDataManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("StokerDataManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)供貨商信息維護(hù)維護(hù)窗體
StokerDataManage newFrm = new StokerDataManage(true);
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示客戶(hù)信息維護(hù)窗口----------
private void mnu_ClientDataManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("ClientDataManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)客戶(hù)信息維護(hù)窗體
ClientDataManage newFrm = new ClientDataManage(true);
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示進(jìn)貨單窗口----------
private void mnu_StockTable_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("StockTable") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)進(jìn)貨單窗體
StockTable newFrm = new StockTable();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示銷(xiāo)售單窗口----------
private void mnu_SellTable_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("SellTable") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)銷(xiāo)售單窗體
SellTable newFrm = new SellTable();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示庫(kù)存查詢(xún)窗口----------
private void mnu_StorageSearch_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("StorageSearch") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)庫(kù)存查詢(xún)窗體
StorageSearch newFrm = new StorageSearch();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示權(quán)限管理窗口----------
private void mnu_PopedomManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("PopedomManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個(gè)權(quán)限管理窗體
PopedomManage newFrm = new PopedomManage();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------退出窗體，先詢(xún)問(wèn)用戶(hù)是否退出-------------
private void menuItemQuit_Click(object sender, System.EventArgs e)
{
if (MessageBox.Show("確實(shí)要退出系統(tǒng)嗎?","詢(xún)問(wèn)",MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -