mainform.cs

财务管理系统采用C#语言和SQL Server数据库 适合于一般小公司的使用

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace 财务管理系统
{
	/// <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>
		/// 必需的设计器变量。
		/// </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()
		{
			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 = " 数据库开发经典案例解析  清华大学出版社  用户登陆功能和权限管理功能参考进销存实例";
			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 = "基础数据管理";
			// 
			// menuItem2
			// 
			this.menuItem2.Index = 0;
			this.menuItem2.Text = "会计科目设置";
			this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
			// 
			// menuItem3
			// 
			this.menuItem3.Index = 1;
			this.menuItem3.Text = "帐户设置";
			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 = "结帐及报表";
			// 
			// 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 = "期末结帐";
			this.menuItem12.Click += new System.EventHandler(this.menuItem12_Click);
			// 
			// menuItem13
			// 
			this.menuItem13.Index = 2;
			this.menuItem13.Text = "资产负债表";
			this.menuItem13.Click += new System.EventHandler(this.menuItem13_Click);
			// 
			// menuItem14
			// 
			this.menuItem14.Index = 4;
			this.menuItem14.Text = "退出系统";
			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 = "【财务管理系统】";
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.statusBarPanel2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		/// <summary>
		/// 应用程序的主入口点。
		/// </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;
		}	

		//-----------------显示科目设置窗体-----------------------
		private void menuItem2_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("SubjectSetting") == true)
			{
				return;
			}
			SubjectSetting newFrm=new SubjectSetting();
			newFrm.MdiParent = this;
			newFrm.Show();		
		}

		//------------------显示帐户设置窗体---------------
		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("AccountSetting") == true)
			{
				return;
			}
			AccountSetting newFrm=new AccountSetting();
			newFrm.MdiParent = this;
			newFrm.Show();		
		}

		//------------------显示凭证输入窗体---------------
		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("WarrentInput") == true)
			{
				return;
			}
			WarrentInput newFrm=new WarrentInput();
			newFrm.MdiParent = this;
			newFrm.Show();	
		}

		//--------------执行凭证过帐功能---------------
		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 凭证编号) 凭证数,sum(借方) "
					+"借方金额,sum(贷方) 贷方金额 from 分录表";
				SqlDataReader dr=cmd.ExecuteReader();
				dr.Read();
				string warrentCount=dr.GetValue(0).ToString();//读入凭证数
				string debit=dr.GetValue(1).ToString();//读入借方金额
				string loan=dr.GetValue(2).ToString();//读入贷方金额
				string messageStr="过帐成功!\n"+"过帐凭证总数为:"+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 分录表";//删除已经过帐的分录数据
					cmd.ExecuteNonQuery();
					cmd.CommandText="delete from 凭证表";//删除已经过帐的凭证数据
					cmd.ExecuteNonQuery();
				}
				catch(Exception express)
				{
					MessageBox.Show(express.ToString(),"凭证过帐失败",MessageBoxButtons.OK,MessageBoxIcon.Error);
					return;
				}
			}
		}

		//--------------执行总分类帐查询功能---------------
		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("LedgerQuery") == true)
			{
				return;
			}
			LedgerQuery newFrm=new LedgerQuery();
			newFrm.MdiParent = this;
			newFrm.Show();
		}

		//--------------执行明细帐查询功能---------------
		private void menuItem9_Click(object sender, System.EventArgs e)
		{
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("DetailQuery") == true)
			{
				return;
			}
			DetailQuery newFrm=new DetailQuery();
			newFrm.MdiParent = this;
			newFrm.Show();
		}

		//-------------显示使用试算平衡窗体---------------
		private void menuItem11_Click(object sender, System.EventArgs e)
		{
		
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("TrialBalance") == true)
			{
				return;
			}
			TrialBalance newFrm=new TrialBalance(false);
			newFrm.Text+="正式使用";
			newFrm.MdiParent = this;
			newFrm.Show();
		}

		//------------调用储存过程，实现期末结帐--------------
		private void menuItem12_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();				
				try
				{
					SqlCommand cmd=cn.CreateCommand();
					cmd.CommandText="exec sf_期末结帐";
					cmd.ExecuteNonQuery();
					MessageBox.Show("期末结帐成功!","结帐成功",MessageBoxButtons.OK,MessageBoxIcon.Information);
					
				}
				catch(Exception express)
				{
					MessageBox.Show(express.ToString(),"期末结帐失败",MessageBoxButtons.OK,MessageBoxIcon.Error);
					return;
				}
			}
		}

		//---------显示资产负债表-----------
		private void menuItem13_Click(object sender, System.EventArgs e)
		{
			
			//通过窗体名称查询该窗体是否已经存在，如存在则显示，否则就新创建一个
			if (this.checkChildFrmExist("FinancialReport") == true)
			{
				return;
			}
			FinancialReport newFrm=new FinancialReport();
			newFrm.MdiParent = this;
			newFrm.Show();
		}

		//---------关闭窗体------------
		private void menuItem14_Click(object sender, System.EventArgs e)
		{
			this.Close();
		}

	
	}
}