?? mainfrm.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace 進銷存管理系統
{
/// <summary>
/// Form1 的摘要說明。
/// </summary>
public class MainFrm : System.Windows.Forms.Form
{
private DataSet ds = new DataSet();
private LinkDataBase link = new LinkDataBase();
private string sendTableName = "權限清單";
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>
/// 必需的設計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public MainFrm()
{
//
// Windows 窗體設計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調用后添加任何構造函數代碼
//
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設計器生成的代碼
/// <summary>
/// 設計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內容。
/// </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 = "商品信息維護";
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 = "供貨商信息維護";
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 = "客戶信息維護";
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 = "進貨管理";
//
// mnu_StockTable
//
this.mnu_StockTable.Enabled = false;
this.mnu_StockTable.Index = 0;
this.mnu_StockTable.Text = "進貨單";
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 = "銷售管理";
//
// mnu_SellTable
//
this.mnu_SellTable.Enabled = false;
this.mnu_SellTable.Index = 0;
this.mnu_SellTable.Text = "銷售單";
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 = "庫存管理";
//
// mnu_StorageSearch
//
this.mnu_StorageSearch.Enabled = false;
this.mnu_StorageSearch.Index = 0;
this.mnu_StorageSearch.Text = "庫存查詢";
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 = "系統管理";
//
// mnu_PopedomManage
//
this.mnu_PopedomManage.Enabled = false;
this.mnu_PopedomManage.Index = 0;
this.mnu_PopedomManage.Text = "權限管理";
this.mnu_PopedomManage.Click += new System.EventHandler(this.mnu_PopedomManage_Click);
//
// menuItemQuit
//
this.menuItemQuit.Index = 5;
this.menuItemQuit.Text = "退出系統";
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 = "《數據庫開發經典案例解析》 清華大學出版社";
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 = "【進銷存管理系統】";
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>
/// 應用程序的主入口點。
/// </summary>
[STAThread]
static void Main()
{
//整個程序啟動時先顯示登錄框，登錄成功再顯示主界面
LoginFrm login = new LoginFrm();
login.ShowDialog();
if (LoginFrm.blCanLogin==true)
{
Application.Run(new MainFrm());
}
}
//------------創建窗體時，通過登錄用戶的名稱和權限，設置可以訪問的功能--------------
private void MainFrm_Load(object sender, System.EventArgs e)
{
this.statusBarPanel2.Text = " 當前用戶: " + LoginFrm.strUser +" 所屬部門: " + LoginFrm.strDepartment;
//通過用戶編號查詢權限清單控制主窗體菜單使能狀態
this.sendStrSQL = "SELECT 權限名稱 from 權限清單 where 用戶編號 = '" + LoginFrm.strUser +"'";
this.ds = this.link.SelectDataBase(sendStrSQL,sendTableName);
//系統管理用戶為特殊權限用戶,他始終擁有所有權利
if ( LoginFrm.strDepartment == "系統管理")
{
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
{
//根據從數據庫中檢索到的用戶的權限來設置其有權使用的菜單
for (int intCounter=0;intCounter<this.ds.Tables[0].Rows.Count;intCounter++)
{
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "商品資料維護")
{
this.mnu_WareDataManage.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "供貨商資料維護")
{
this.mnu_StokerDataManage.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "客戶資料維護")
{
this.mnu_ClientDataManage.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "進貨單")
{
this.mnu_StockTable.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "銷售單")
{
this.mnu_SellTable.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "庫存查詢")
{
this.mnu_StorageSearch.Enabled = true; continue;
}
if (this.ds.Tables[0].Rows[intCounter][0].ToString().Trim() == "權限管理")
{
this.mnu_PopedomManage.Enabled = true; continue;
}
}
}
}
//-----------------查詢一個子窗體是否存在----------------
private bool checkChildFrmExist(string childFrmName)
{
foreach(Form childFrm in this.MdiChildren)
{
//用子窗體的Name進行判斷，如果已經存在則將他激活
if(childFrm.Name == childFrmName)
{
if(childFrm.WindowState == FormWindowState.Minimized)
childFrm.WindowState = FormWindowState.Normal;
childFrm.Activate();
return true;
}
}
return false;
}
//-----------顯示商品信息維護窗口----------
private void mnu_WareDataManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("WareDataManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個商品信息維護窗體
WareDataManage newFrm = new WareDataManage(true);
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示供貨商信息維護窗口----------
private void mnu_StokerDataManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("StokerDataManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個供貨商信息維護維護窗體
StokerDataManage newFrm = new StokerDataManage(true);
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示客戶信息維護窗口----------
private void mnu_ClientDataManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("ClientDataManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個客戶信息維護窗體
ClientDataManage newFrm = new ClientDataManage(true);
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示進貨單窗口----------
private void mnu_StockTable_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("StockTable") == true)
{
return;
}
// 如果該窗體不存在則新生成一個進貨單窗體
StockTable newFrm = new StockTable();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示銷售單窗口----------
private void mnu_SellTable_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("SellTable") == true)
{
return;
}
// 如果該窗體不存在則新生成一個銷售單窗體
SellTable newFrm = new SellTable();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示庫存查詢窗口----------
private void mnu_StorageSearch_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("StorageSearch") == true)
{
return;
}
// 如果該窗體不存在則新生成一個庫存查詢窗體
StorageSearch newFrm = new StorageSearch();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------顯示權限管理窗口----------
private void mnu_PopedomManage_Click(object sender, System.EventArgs e)
{
if (this.checkChildFrmExist("PopedomManage") == true)
{
return;
}
// 如果該窗體不存在則新生成一個權限管理窗體
PopedomManage newFrm = new PopedomManage();
newFrm.MdiParent = this;
newFrm.Show();
}
//-----------退出窗體，先詢問用戶是否退出-------------
private void menuItemQuit_Click(object sender, System.EventArgs e)
{
if (MessageBox.Show("確實要退出系統嗎?","詢問",MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.Close();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -