accountsetting.cs

用vs2003和SQLServer2000开发的财务管理系统

																												  this.dataGridTextBoxColumn6});
			this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle1.MappingName = "帐簿初始化表";
			// 
			// dataGridTextBoxColumn1
			// 
			this.dataGridTextBoxColumn1.Format = "";
			this.dataGridTextBoxColumn1.FormatInfo = null;
			this.dataGridTextBoxColumn1.HeaderText = "科目代码";
			this.dataGridTextBoxColumn1.MappingName = "科目代码";
			this.dataGridTextBoxColumn1.ReadOnly = true;
			this.dataGridTextBoxColumn1.Width = 75;
			// 
			// dataGridTextBoxColumn2
			// 
			this.dataGridTextBoxColumn2.Format = "";
			this.dataGridTextBoxColumn2.FormatInfo = null;
			this.dataGridTextBoxColumn2.HeaderText = "科目名称";
			this.dataGridTextBoxColumn2.MappingName = "科目名称";
			this.dataGridTextBoxColumn2.ReadOnly = true;
			this.dataGridTextBoxColumn2.Width = 75;
			// 
			// dataGridTextBoxColumn3
			// 
			this.dataGridTextBoxColumn3.Format = "";
			this.dataGridTextBoxColumn3.FormatInfo = null;
			this.dataGridTextBoxColumn3.HeaderText = "余额方向";
			this.dataGridTextBoxColumn3.MappingName = "余额方向";
			this.dataGridTextBoxColumn3.ReadOnly = true;
			this.dataGridTextBoxColumn3.Width = 75;
			// 
			// dataGridTextBoxColumn4
			// 
			this.dataGridTextBoxColumn4.Format = "";
			this.dataGridTextBoxColumn4.FormatInfo = null;
			this.dataGridTextBoxColumn4.HeaderText = "累计借方";
			this.dataGridTextBoxColumn4.MappingName = "累计借方";
			this.dataGridTextBoxColumn4.Width = 75;
			// 
			// dataGridTextBoxColumn5
			// 
			this.dataGridTextBoxColumn5.Format = "";
			this.dataGridTextBoxColumn5.FormatInfo = null;
			this.dataGridTextBoxColumn5.HeaderText = "累计借方";
			this.dataGridTextBoxColumn5.MappingName = "累计贷方";
			this.dataGridTextBoxColumn5.Width = 75;
			// 
			// dataGridTextBoxColumn6
			// 
			this.dataGridTextBoxColumn6.Format = "";
			this.dataGridTextBoxColumn6.FormatInfo = null;
			this.dataGridTextBoxColumn6.HeaderText = "期初余额";
			this.dataGridTextBoxColumn6.MappingName = "期初余额";
			this.dataGridTextBoxColumn6.Width = 75;
			// 
			// dataGrid2
			// 
			this.dataGrid2.CaptionVisible = false;
			this.dataGrid2.DataMember = "系统参数表";
			this.dataGrid2.DataSource = this.dataSet21;
			this.dataGrid2.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid2.Location = new System.Drawing.Point(424, 64);
			this.dataGrid2.Name = "dataGrid2";
			this.dataGrid2.ReadOnly = true;
			this.dataGrid2.Size = new System.Drawing.Size(264, 424);
			this.dataGrid2.TabIndex = 1;
			// 
			// btnNewAccount
			// 
			this.btnNewAccount.Image = ((System.Drawing.Image)(resources.GetObject("btnNewAccount.Image")));
			this.btnNewAccount.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnNewAccount.Location = new System.Drawing.Point(72, 24);
			this.btnNewAccount.Name = "btnNewAccount";
			this.btnNewAccount.Size = new System.Drawing.Size(112, 32);
			this.btnNewAccount.TabIndex = 2;
			this.btnNewAccount.Text = "建立新帐簿";
			this.btnNewAccount.Click += new System.EventHandler(this.btnNewAccount_Click);
			// 
			// btnUseAccount
			// 
			this.btnUseAccount.Image = ((System.Drawing.Image)(resources.GetObject("btnUseAccount.Image")));
			this.btnUseAccount.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnUseAccount.Location = new System.Drawing.Point(216, 24);
			this.btnUseAccount.Name = "btnUseAccount";
			this.btnUseAccount.Size = new System.Drawing.Size(104, 32);
			this.btnUseAccount.TabIndex = 2;
			this.btnUseAccount.Text = "启用新帐簿";
			this.btnUseAccount.Click += new System.EventHandler(this.btnUseAccount_Click);
			// 
			// btnBalance
			// 
			this.btnBalance.Image = ((System.Drawing.Image)(resources.GetObject("btnBalance.Image")));
			this.btnBalance.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.btnBalance.Location = new System.Drawing.Point(352, 24);
			this.btnBalance.Name = "btnBalance";
			this.btnBalance.Size = new System.Drawing.Size(104, 32);
			this.btnBalance.TabIndex = 2;
			this.btnBalance.Text = "试算平衡";
			this.btnBalance.Click += new System.EventHandler(this.btnBalance_Click);
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;initial catalo" +
				"g=caiwubook;persist security info=False";
			// 
			// AccountSetting
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(688, 493);
			this.Controls.Add(this.btnNewAccount);
			this.Controls.Add(this.dataGrid2);
			this.Controls.Add(this.dataGrid1);
			this.Controls.Add(this.btnUseAccount);
			this.Controls.Add(this.btnBalance);
			this.Name = "AccountSetting";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "【帐户设置】";
			this.Load += new System.EventHandler(this.AccountSetting_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		//------------建立新窗体时，读入所有数据-------------
		private void AccountSetting_Load(object sender, System.EventArgs e)
		{
			da1.Fill(dataSet21);
			da2.Fill(dataSet21);
		}

		//-----------建立新帐户----------
		private void btnNewAccount_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="exec sf_初始化帐户";
				try
				{
					cmd.ExecuteNonQuery();
					dataSet21.Clear();//刷新数据集
					da1.Fill(dataSet21);
					da2.Fill(dataSet21);
				}
				catch(Exception express)
				{
					MessageBox.Show(express.ToString(),"建立新帐户失败",MessageBoxButtons.OK,MessageBoxIcon.Error);
				}
			}
		}

		//-----------启用新帐户----------
		private void btnUseAccount_Click(object sender, System.EventArgs e)
		{
			da1.Update(dataSet21);//将用户对新帐簿中数据的修改提交到数据库
			string strConn = "workstation id=localhost;Integrated Security=SSPI;database=caiwubook";
			SqlConnection cn=new SqlConnection(strConn);
			cn.Open();
			SqlCommand cmd=cn.CreateCommand();
			cmd.CommandText="select sum(累计借方) 借方,sum(累计贷方) 贷方 from 帐簿初始化表";
			SqlDataReader dr=cmd.ExecuteReader();
			dr.Read();
			if(dr.GetValue(0).ToString().Trim()!=dr.GetValue(1).ToString().Trim())//判断初始化后帐簿是否平衡
			{
				MessageBox.Show("新帐簿初始化不平衡，请检查试算平衡表后重新输入","无法启用新帐簿",MessageBoxButtons.OK,MessageBoxIcon.Error);
				return;
			}
			else
			{
				DialogResult result=MessageBox.Show("试算结果平衡，启用新帐簿将删除所有历史记录，是否继续？","确认启用新帐簿",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
				if(result==DialogResult.OK)
				{
					dr.Close();
					cmd.CommandText="exec sf_启用帐户";
					cmd.ExecuteNonQuery();
					dataSet21.Clear();//刷新数据集
					da1.Fill(dataSet21);
					da2.Fill(dataSet21);
					MessageBox.Show("新帐户启用成功!");
				}
				return;
			}		
		}

		//----------新帐户的试算平衡--------
		private void btnBalance_Click(object sender, System.EventArgs e)
		{
			da1.Update(dataSet21);//将用户对新帐簿中数据的修改提交到数据库
			TrialBalance newFrm=new TrialBalance(true);
			newFrm.Text+="初始化帐户";
			
			newFrm.Show();
		}
	}
}