?? mainform.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
namespace 財務(wù)管理系統(tǒng)
{
/// <summary>
/// Form1 的摘要說明。
/// </summary>
public class mainFrm : System.Windows.Forms.Form
{
private System.Windows.Forms.StatusBar statusBar1;
private System.Windows.Forms.StatusBarPanel statusBarPanel1;
private System.Windows.Forms.StatusBarPanel statusBarPanel2;
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 menuItem6;
private System.Windows.Forms.MenuItem menuItem7;
private System.Windows.Forms.MenuItem menuItem8;
private System.Windows.Forms.MenuItem menuItem9;
private System.Windows.Forms.MenuItem menuItem10;
private System.Windows.Forms.MenuItem menuItem11;
private System.Windows.Forms.MenuItem menuItem12;
private System.Windows.Forms.MenuItem menuItem13;
private System.Windows.Forms.MenuItem menuItem14;
/// <summary>
/// 必需的設(shè)計器變量。
/// </summary>
private System.ComponentModel.Container components = null;
public mainFrm()
{
//
// Windows 窗體設(shè)計器支持所必需的
//
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è)計器生成的代碼
/// <summary>
/// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(mainFrm));
this.statusBar1 = new System.Windows.Forms.StatusBar();
this.statusBarPanel1 = new System.Windows.Forms.StatusBarPanel();
this.statusBarPanel2 = new System.Windows.Forms.StatusBarPanel();
this.mainMenu1 = new System.Windows.Forms.MainMenu();
this.menuItem1 = new System.Windows.Forms.MenuItem();
this.menuItem2 = new System.Windows.Forms.MenuItem();
this.menuItem3 = new System.Windows.Forms.MenuItem();
this.menuItem4 = new System.Windows.Forms.MenuItem();
this.menuItem5 = new System.Windows.Forms.MenuItem();
this.menuItem6 = new System.Windows.Forms.MenuItem();
this.menuItem7 = new System.Windows.Forms.MenuItem();
this.menuItem8 = new System.Windows.Forms.MenuItem();
this.menuItem9 = new System.Windows.Forms.MenuItem();
this.menuItem10 = new System.Windows.Forms.MenuItem();
this.menuItem11 = new System.Windows.Forms.MenuItem();
this.menuItem12 = new System.Windows.Forms.MenuItem();
this.menuItem13 = new System.Windows.Forms.MenuItem();
this.menuItem14 = new System.Windows.Forms.MenuItem();
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).BeginInit();
this.SuspendLayout();
//
// statusBar1
//
this.statusBar1.Location = new System.Drawing.Point(0, 531);
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 = 3;
//
// statusBarPanel1
//
this.statusBarPanel1.MinWidth = 200;
this.statusBarPanel1.Text = " 數(shù)據(jù)庫開發(fā)經(jīng)典案例解析 清華大學出版社 用戶登陸功能和權(quán)限管理功能參考進銷存實例";
this.statusBarPanel1.Width = 500;
//
// statusBarPanel2
//
this.statusBarPanel2.Width = 200;
//
// mainMenu1
//
this.mainMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem1,
this.menuItem4,
this.menuItem7,
this.menuItem10,
this.menuItem14});
//
// menuItem1
//
this.menuItem1.Index = 0;
this.menuItem1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem2,
this.menuItem3});
this.menuItem1.Text = "基礎(chǔ)數(shù)據(jù)管理";
//
// menuItem2
//
this.menuItem2.Index = 0;
this.menuItem2.Text = "會計科目設(shè)置";
this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
//
// menuItem3
//
this.menuItem3.Index = 1;
this.menuItem3.Text = "帳戶設(shè)置";
this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
//
// menuItem4
//
this.menuItem4.Index = 1;
this.menuItem4.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem5,
this.menuItem6});
this.menuItem4.Text = "憑證管理";
//
// menuItem5
//
this.menuItem5.Index = 0;
this.menuItem5.Text = "憑證輸入";
this.menuItem5.Click += new System.EventHandler(this.menuItem5_Click);
//
// menuItem6
//
this.menuItem6.Index = 1;
this.menuItem6.Text = "憑證過帳";
this.menuItem6.Click += new System.EventHandler(this.menuItem6_Click);
//
// menuItem7
//
this.menuItem7.Index = 2;
this.menuItem7.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem8,
this.menuItem9});
this.menuItem7.Text = "帳簿管理";
//
// menuItem8
//
this.menuItem8.Index = 0;
this.menuItem8.Text = "總分類帳";
this.menuItem8.Click += new System.EventHandler(this.menuItem8_Click);
//
// menuItem9
//
this.menuItem9.Index = 1;
this.menuItem9.Text = "明細帳";
this.menuItem9.Click += new System.EventHandler(this.menuItem9_Click);
//
// menuItem10
//
this.menuItem10.Index = 3;
this.menuItem10.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
this.menuItem11,
this.menuItem12,
this.menuItem13});
this.menuItem10.Text = "結(jié)帳及報表";
//
// menuItem11
//
this.menuItem11.Index = 0;
this.menuItem11.Text = "試算平衡表";
this.menuItem11.Click += new System.EventHandler(this.menuItem11_Click);
//
// menuItem12
//
this.menuItem12.Index = 1;
this.menuItem12.Text = "期末結(jié)帳";
this.menuItem12.Click += new System.EventHandler(this.menuItem12_Click);
//
// menuItem13
//
this.menuItem13.Index = 2;
this.menuItem13.Text = "資產(chǎn)負債表";
this.menuItem13.Click += new System.EventHandler(this.menuItem13_Click);
//
// menuItem14
//
this.menuItem14.Index = 4;
this.menuItem14.Text = "退出系統(tǒng)";
this.menuItem14.Click += new System.EventHandler(this.menuItem14_Click);
//
// mainFrm
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(792, 553);
this.Controls.Add(this.statusBar1);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.IsMdiContainer = true;
this.Menu = this.mainMenu1;
this.Name = "mainFrm";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【財務(wù)管理系統(tǒng)】";
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
this.ResumeLayout(false);
}
#endregion
/// <summary>
/// 應(yīng)用程序的主入口點。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new mainFrm());
}
//----------------------查詢MDI子窗體是否存在-----------------------------
private bool checkChildFrmExist(string childFrmName)
{
foreach(Form childFrm in this.MdiChildren)
{
if(childFrm.Name == childFrmName) //用子窗體的Name進行判斷，如果存在則將他激活
{
if(childFrm.WindowState == FormWindowState.Minimized)
childFrm.WindowState = FormWindowState.Normal;
childFrm.Activate();
return true;
}
}
return false;
}
//-----------------顯示科目設(shè)置窗體-----------------------
private void menuItem2_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("SubjectSetting") == true)
{
return;
}
SubjectSetting newFrm=new SubjectSetting();
newFrm.MdiParent = this;
newFrm.Show();
}
//------------------顯示帳戶設(shè)置窗體---------------
private void menuItem3_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("AccountSetting") == true)
{
return;
}
AccountSetting newFrm=new AccountSetting();
newFrm.MdiParent = this;
newFrm.Show();
}
//------------------顯示憑證輸入窗體---------------
private void menuItem5_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("WarrentInput") == true)
{
return;
}
WarrentInput newFrm=new WarrentInput();
newFrm.MdiParent = this;
newFrm.Show();
}
//--------------執(zhí)行憑證過帳功能---------------
private void menuItem6_Click(object sender, System.EventArgs e)
{
DialogResult result=MessageBox.Show("憑證過帳后即不可再修改，是否過帳","確認過帳",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
if(result==DialogResult.OK)
{
string strConn = "workstation id=localhost;Integrated Security=SSPI;database=caiwubook";
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
cmd.CommandText="select count(distinct 憑證編號) 憑證數(shù),sum(借方) "
+"借方金額,sum(貸方) 貸方金額 from 分錄表";
SqlDataReader dr=cmd.ExecuteReader();
dr.Read();
string warrentCount=dr.GetValue(0).ToString();//讀入憑證數(shù)
string debit=dr.GetValue(1).ToString();//讀入借方金額
string loan=dr.GetValue(2).ToString();//讀入貸方金額
string messageStr="過帳成功!\n"+"過帳憑證總數(shù)為:"+warrentCount.Trim()+"\n"
+"借方金額合計:"+debit.Trim()+"\n"+"貸方金額合計:"+loan.Trim()+"\n";
dr.Close();//準備顯示的過帳信息
try
{
cmd.CommandText="exec sf_憑證過帳";
cmd.ExecuteNonQuery();
MessageBox.Show(messageStr,"憑證過帳成功!",MessageBoxButtons.OK,MessageBoxIcon.Information);
cmd.CommandText="delete from 分錄表";//刪除已經(jīng)過帳的分錄數(shù)據(jù)
cmd.ExecuteNonQuery();
cmd.CommandText="delete from 憑證表";//刪除已經(jīng)過帳的憑證數(shù)據(jù)
cmd.ExecuteNonQuery();
}
catch(Exception express)
{
MessageBox.Show(express.ToString(),"憑證過帳失敗",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
}
}
//--------------執(zhí)行總分類帳查詢功能---------------
private void menuItem8_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("LedgerQuery") == true)
{
return;
}
LedgerQuery newFrm=new LedgerQuery();
newFrm.MdiParent = this;
newFrm.Show();
}
//--------------執(zhí)行明細帳查詢功能---------------
private void menuItem9_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("DetailQuery") == true)
{
return;
}
DetailQuery newFrm=new DetailQuery();
newFrm.MdiParent = this;
newFrm.Show();
}
//-------------顯示使用試算平衡窗體---------------
private void menuItem11_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("TrialBalance") == true)
{
return;
}
TrialBalance newFrm=new TrialBalance(false);
newFrm.Text+="正式使用";
newFrm.MdiParent = this;
newFrm.Show();
}
//------------調(diào)用儲存過程，實現(xiàn)期末結(jié)帳--------------
private void menuItem12_Click(object sender, System.EventArgs e)
{
DialogResult result=MessageBox.Show("結(jié)帳后將進入下一會計期間，是否結(jié)帳","確認結(jié)帳",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
if(result==DialogResult.OK)
{
string strConn = "workstation id=localhost;Integrated Security=SSPI;database=caiwubook";
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
try
{
SqlCommand cmd=cn.CreateCommand();
cmd.CommandText="exec sf_期末結(jié)帳";
cmd.ExecuteNonQuery();
MessageBox.Show("期末結(jié)帳成功!","結(jié)帳成功",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
catch(Exception express)
{
MessageBox.Show(express.ToString(),"期末結(jié)帳失敗",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
}
}
//---------顯示資產(chǎn)負債表-----------
private void menuItem13_Click(object sender, System.EventArgs e)
{
//通過窗體名稱查詢該窗體是否已經(jīng)存在，如存在則顯示，否則就新創(chuàng)建一個
if (this.checkChildFrmExist("FinancialReport") == true)
{
return;
}
FinancialReport newFrm=new FinancialReport();
newFrm.MdiParent = this;
newFrm.Show();
}
//---------關(guān)閉窗體------------
private void menuItem14_Click(object sender, System.EventArgs e)
{
this.Close();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -