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 = "科目名稱(chēng)";
			this.dataGridTextBoxColumn2.MappingName = "科目名稱(chēng)";
			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 = "累計(jì)借方";
			this.dataGridTextBoxColumn4.MappingName = "累計(jì)借方";
			this.dataGridTextBoxColumn4.Width = 75;
			// 
			// dataGridTextBoxColumn5
			// 
			this.dataGridTextBoxColumn5.Format = "";
			this.dataGridTextBoxColumn5.FormatInfo = null;
			this.dataGridTextBoxColumn5.HeaderText = "累計(jì)借方";
			this.dataGridTextBoxColumn5.MappingName = "累計(jì)貸方";
			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 = "系統(tǒng)參數(shù)表";
			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 = "【帳戶(hù)設(shè)置】";
			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

		//------------建立新窗體時(shí)，讀入所有數(shù)據(jù)-------------
		private void AccountSetting_Load(object sender, System.EventArgs e)
		{
			da1.Fill(dataSet21);
			da2.Fill(dataSet21);
		}

		//-----------建立新帳戶(hù)----------
		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_初始化帳戶(hù)";
				try
				{
					cmd.ExecuteNonQuery();
					dataSet21.Clear();//刷新數(shù)據(jù)集
					da1.Fill(dataSet21);
					da2.Fill(dataSet21);
				}
				catch(Exception express)
				{
					MessageBox.Show(express.ToString(),"建立新帳戶(hù)失敗",MessageBoxButtons.OK,MessageBoxIcon.Error);
				}
			}
		}

		//-----------啟用新帳戶(hù)----------
		private void btnUseAccount_Click(object sender, System.EventArgs e)
		{
			da1.Update(dataSet21);//將用戶(hù)對(duì)新帳簿中數(shù)據(jù)的修改提交到數(shù)據(jù)庫(kù)
			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(累計(jì)借方) 借方,sum(累計(jì)貸方) 貸方 from 帳簿初始化表";
			SqlDataReader dr=cmd.ExecuteReader();
			dr.Read();
			if(dr.GetValue(0).ToString().Trim()!=dr.GetValue(1).ToString().Trim())//判斷初始化后帳簿是否平衡
			{
				MessageBox.Show("新帳簿初始化不平衡，請(qǐng)檢查試算平衡表后重新輸入","無(wú)法啟用新帳簿",MessageBoxButtons.OK,MessageBoxIcon.Error);
				return;
			}
			else
			{
				DialogResult result=MessageBox.Show("試算結(jié)果平衡，啟用新帳簿將刪除所有歷史記錄，是否繼續(xù)？","確認(rèn)啟用新帳簿",MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);
				if(result==DialogResult.OK)
				{
					dr.Close();
					cmd.CommandText="exec sf_啟用帳戶(hù)";
					cmd.ExecuteNonQuery();
					dataSet21.Clear();//刷新數(shù)據(jù)集
					da1.Fill(dataSet21);
					da2.Fill(dataSet21);
					MessageBox.Show("新帳戶(hù)啟用成功!");
				}
				return;
			}		
		}

		//----------新帳戶(hù)的試算平衡--------
		private void btnBalance_Click(object sender, System.EventArgs e)
		{
			da1.Update(dataSet21);//將用戶(hù)對(duì)新帳簿中數(shù)據(jù)的修改提交到數(shù)據(jù)庫(kù)
			TrialBalance newFrm=new TrialBalance(true);
			newFrm.Text+="初始化帳戶(hù)";
			
			newFrm.Show();
		}
	}
}