?? 賬戶管理.cs
字號(hào):
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "帳戶表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("條形碼", "條形碼"),
new System.Data.Common.DataColumnMapping("班級(jí)", "班級(jí)"),
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("余額", "余額"),
new System.Data.Common.DataColumnMapping("鎖定", "鎖定")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 帳戶表 WHERE (條形碼 = @Original_條形碼) AND (余額 = @Original_余額) AND (姓名 = @Or" +
"iginal_姓名) AND (班級(jí) = @Original_班級(jí)) AND (鎖定 = @Original_鎖定)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "條形碼", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_余額", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "余額", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_班級(jí)", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "班級(jí)", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_鎖定", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "鎖定", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 帳戶表(條形碼, 班級(jí), 姓名, 余額, 鎖定) VALUES (@條形碼, @班級(jí), @姓名, @余額, @鎖定); SELECT 條形" +
"碼, 班級(jí), 姓名, 余額, 鎖定 FROM 帳戶表 WHERE (條形碼 = @條形碼)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 50, "條形碼"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@班級(jí)", System.Data.SqlDbType.VarChar, 50, "班級(jí)"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 50, "姓名"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@余額", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "余額", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@鎖定", System.Data.SqlDbType.Bit, 1, "鎖定"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 條形碼, 班級(jí), 姓名, 余額, 鎖定 FROM 帳戶表";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 帳戶表 SET 條形碼 = @條形碼, 班級(jí) = @班級(jí), 姓名 = @姓名, 余額 = @余額, 鎖定 = @鎖定 WHERE (條形碼 = @O" +
"riginal_條形碼) AND (余額 = @Original_余額) AND (姓名 = @Original_姓名) AND (班級(jí) = @Original" +
"_班級(jí)) AND (鎖定 = @Original_鎖定); SELECT 條形碼, 班級(jí), 姓名, 余額, 鎖定 FROM 帳戶表 WHERE (條形碼 = @" +
"條形碼)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 50, "條形碼"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@班級(jí)", System.Data.SqlDbType.VarChar, 50, "班級(jí)"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 50, "姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@余額", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "余額", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@鎖定", System.Data.SqlDbType.Bit, 1, "鎖定"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "條形碼", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_余額", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(5)), ((System.Byte)(2)), "余額", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_姓名", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "姓名", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_班級(jí)", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "班級(jí)", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_鎖定", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "鎖定", System.Data.DataRowVersion.Original, null));
//
// sqlDataAdapter2
//
this.sqlDataAdapter2.DeleteCommand = this.sqlDeleteCommand2;
this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;
this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;
this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "流水帳表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("流水號(hào)", "流水號(hào)"),
new System.Data.Common.DataColumnMapping("條形碼", "條形碼"),
new System.Data.Common.DataColumnMapping("上機(jī)時(shí)間", "上機(jī)時(shí)間"),
new System.Data.Common.DataColumnMapping("下機(jī)時(shí)間", "下機(jī)時(shí)間"),
new System.Data.Common.DataColumnMapping("花費(fèi)", "花費(fèi)"),
new System.Data.Common.DataColumnMapping("上機(jī)狀態(tài)", "上機(jī)狀態(tài)"),
new System.Data.Common.DataColumnMapping("上機(jī)區(qū)域", "上機(jī)區(qū)域"),
new System.Data.Common.DataColumnMapping("值班教師", "值班教師")})});
this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = @"DELETE FROM 流水帳表 WHERE (流水號(hào) = @Original_流水號(hào)) AND (上機(jī)區(qū)域 = @Original_上機(jī)區(qū)域 OR @Original_上機(jī)區(qū)域 IS NULL AND 上機(jī)區(qū)域 IS NULL) AND (上機(jī)時(shí)間 = @Original_上機(jī)時(shí)間 OR @Original_上機(jī)時(shí)間 IS NULL AND 上機(jī)時(shí)間 IS NULL) AND (上機(jī)狀態(tài) = @Original_上機(jī)狀態(tài) OR @Original_上機(jī)狀態(tài) IS NULL AND 上機(jī)狀態(tài) IS NULL) AND (下機(jī)時(shí)間 = @Original_下機(jī)時(shí)間 OR @Original_下機(jī)時(shí)間 IS NULL AND 下機(jī)時(shí)間 IS NULL) AND (值班教師 = @Original_值班教師 OR @Original_值班教師 IS NULL AND 值班教師 IS NULL) AND (條形碼 = @Original_條形碼 OR @Original_條形碼 IS NULL AND 條形碼 IS NULL) AND (花費(fèi) = @Original_花費(fèi) OR @Original_花費(fèi) IS NULL AND 花費(fèi) IS NULL)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_流水號(hào)", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "流水號(hào)", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上機(jī)區(qū)域", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上機(jī)區(qū)域", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上機(jī)時(shí)間", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上機(jī)狀態(tài)", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上機(jī)狀態(tài)", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_下機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "下機(jī)時(shí)間", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_值班教師", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "值班教師", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "條形碼", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_花費(fèi)", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花費(fèi)", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 流水帳表(條形碼, 上機(jī)時(shí)間, 下機(jī)時(shí)間, 花費(fèi), 上機(jī)狀態(tài), 上機(jī)區(qū)域, 值班教師) VALUES (@條形碼, @上機(jī)時(shí)間, @下機(jī)時(shí)" +
"間, @花費(fèi), @上機(jī)狀態(tài), @上機(jī)區(qū)域, @值班教師); SELECT 流水號(hào), 條形碼, 上機(jī)時(shí)間, 下機(jī)時(shí)間, 花費(fèi), 上機(jī)狀態(tài), 上機(jī)區(qū)域, 值班教師 " +
"FROM 流水帳表 WHERE (流水號(hào) = @@IDENTITY)";
this.sqlInsertCommand2.Connection = this.sqlConnection1;
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 50, "條形碼"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, "上機(jī)時(shí)間"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, "下機(jī)時(shí)間"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@花費(fèi)", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花費(fèi)", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上機(jī)狀態(tài)", System.Data.SqlDbType.Int, 4, "上機(jī)狀態(tài)"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上機(jī)區(qū)域", System.Data.SqlDbType.VarChar, 10, "上機(jī)區(qū)域"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@值班教師", System.Data.SqlDbType.VarChar, 50, "值班教師"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 流水號(hào), 條形碼, 上機(jī)時(shí)間, 下機(jī)時(shí)間, 花費(fèi), 上機(jī)狀態(tài), 上機(jī)區(qū)域, 值班教師 FROM 流水帳表";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = @"UPDATE 流水帳表 SET 條形碼 = @條形碼, 上機(jī)時(shí)間 = @上機(jī)時(shí)間, 下機(jī)時(shí)間 = @下機(jī)時(shí)間, 花費(fèi) = @花費(fèi), 上機(jī)狀態(tài) = @上機(jī)狀態(tài), 上機(jī)區(qū)域 = @上機(jī)區(qū)域, 值班教師 = @值班教師 WHERE (流水號(hào) = @Original_流水號(hào)) AND (上機(jī)區(qū)域 = @Original_上機(jī)區(qū)域 OR @Original_上機(jī)區(qū)域 IS NULL AND 上機(jī)區(qū)域 IS NULL) AND (上機(jī)時(shí)間 = @Original_上機(jī)時(shí)間 OR @Original_上機(jī)時(shí)間 IS NULL AND 上機(jī)時(shí)間 IS NULL) AND (上機(jī)狀態(tài) = @Original_上機(jī)狀態(tài) OR @Original_上機(jī)狀態(tài) IS NULL AND 上機(jī)狀態(tài) IS NULL) AND (下機(jī)時(shí)間 = @Original_下機(jī)時(shí)間 OR @Original_下機(jī)時(shí)間 IS NULL AND 下機(jī)時(shí)間 IS NULL) AND (值班教師 = @Original_值班教師 OR @Original_值班教師 IS NULL AND 值班教師 IS NULL) AND (條形碼 = @Original_條形碼 OR @Original_條形碼 IS NULL AND 條形碼 IS NULL) AND (花費(fèi) = @Original_花費(fèi) OR @Original_花費(fèi) IS NULL AND 花費(fèi) IS NULL); SELECT 流水號(hào), 條形碼, 上機(jī)時(shí)間, 下機(jī)時(shí)間, 花費(fèi), 上機(jī)狀態(tài), 上機(jī)區(qū)域, 值班教師 FROM 流水帳表 WHERE (流水號(hào) = @流水號(hào))";
this.sqlUpdateCommand2.Connection = this.sqlConnection1;
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@條形碼", System.Data.SqlDbType.VarChar, 50, "條形碼"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, "上機(jī)時(shí)間"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, "下機(jī)時(shí)間"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@花費(fèi)", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花費(fèi)", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上機(jī)狀態(tài)", System.Data.SqlDbType.Int, 4, "上機(jī)狀態(tài)"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上機(jī)區(qū)域", System.Data.SqlDbType.VarChar, 10, "上機(jī)區(qū)域"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@值班教師", System.Data.SqlDbType.VarChar, 50, "值班教師"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_流水號(hào)", System.Data.SqlDbType.BigInt, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "流水號(hào)", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上機(jī)區(qū)域", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上機(jī)區(qū)域", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上機(jī)時(shí)間", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_上機(jī)狀態(tài)", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "上機(jī)狀態(tài)", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_下機(jī)時(shí)間", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "下機(jī)時(shí)間", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_值班教師", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "值班教師", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_條形碼", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "條形碼", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_花費(fèi)", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花費(fèi)", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@流水號(hào)", System.Data.SqlDbType.BigInt, 8, "流水號(hào)"));
//
// sqlDataAdapter3
//
this.sqlDataAdapter3.SelectCommand = this.sqlSelectCommand3;
this.sqlDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "收費(fèi)流水表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("班級(jí)", "班級(jí)"),
new System.Data.Common.DataColumnMapping("時(shí)間", "時(shí)間"),
new System.Data.Common.DataColumnMapping("條形碼", "條形碼"),
new System.Data.Common.DataColumnMapping("值班教師", "值班教師"),
new System.Data.Common.DataColumnMapping("收費(fèi)", "收費(fèi)"),
new System.Data.Common.DataColumnMapping("充值", "充值"),
new System.Data.Common.DataColumnMapping("余額", "余額")})});
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT 收費(fèi)流水表.ID, 帳戶表.姓名, 帳戶表.班級(jí), 收費(fèi)流水表.時(shí)間, 收費(fèi)流水表.條形碼, 收費(fèi)流水表.值班教師, 收費(fèi)流水表.收費(fèi), 收費(fèi)流水表" +
".充值, 帳戶表.余額 FROM 收費(fèi)流水表 INNER JOIN 帳戶表 ON 收費(fèi)流水表.條形碼 = 帳戶表.條形碼";
this.sqlSelectCommand3.Connection = this.sqlConnection2;
//
// sqlConnection2
//
this.sqlConnection2.ConnectionString = "workstation id=XU;packet size=4096;integrated security=SSPI;data source=XU;persis" +
"t security info=False;initial catalog=jifei";
//
// 賬戶管理
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(692, 416);
this.Controls.Add(this.tabControl1);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;
this.MaximizeBox = false;
this.Name = "賬戶管理";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "賬戶管理";
this.Load += new System.EventHandler(this.賬戶管理_Load);
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox1.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid2)).EndInit();
this.tabPage3.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid3)).EndInit();
this.tabPage4.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
private void button1_Click(object sender, System.EventArgs e)
{
}
private void 賬戶管理_Load(object sender, System.EventArgs e)
{
this.sqlDataAdapter1.Fill(sds,"帳戶表");
this.dataGrid1.SetDataBinding(sds,"帳戶表");
this.dataGrid1.Refresh();
this.sqlDataAdapter2.Fill(this.sds,"流水帳表");
this.dataGrid2.SetDataBinding(this.sds,"流水帳表");
this.dataGrid2.Refresh();
//SELECT 收費(fèi)流水表.ID, 帳戶表.姓名, 帳戶表.班級(jí), 收費(fèi)流水表.時(shí)間, 收費(fèi)流水表.條形碼, 收費(fèi)流水表.值班教師, 收費(fèi)流水表.收費(fèi), 收費(fèi)流水表.充值, 帳戶表.余額 FROM 收費(fèi)流水表 INNER JOIN 帳戶表 ON 收費(fèi)流水表.條形碼 = 帳戶表.條形碼
/*
sds.Tables["流水帳表"].Clear();
sql="select * from 流水帳表 where 上機(jī)狀態(tài)='1'";
this.sqlDataAdapter2.SelectCommand.CommandText=sql;
this.sqlDataAdapter2.Fill(sds,"流水帳表");
this.dataGrid2.SetDataBinding(sds,"流水帳表");
this.dataGrid2.Refresh();
*/
string sql="SELECT 收費(fèi)流水表.ID, 帳戶表.姓名, 帳戶表.班級(jí), 收費(fèi)流水表.時(shí)間, 收費(fèi)流水表.條形碼, 收費(fèi)流水表.值班教師, 收費(fèi)流水表.收費(fèi), 收費(fèi)流水表.充值, 帳戶表.余額 FROM 收費(fèi)流水表 INNER JOIN 帳戶表 ON 收費(fèi)流水表.條形碼 = 帳戶表.條形碼 and 收費(fèi)流水表.時(shí)間>'"+ this.dateTimePicker1.Value.Date.ToString() +"' and 收費(fèi)流水表.時(shí)間<'"+ this.dateTimePicker1.Value.Date.AddDays(1).Date.ToString() +"' and 值班教師='"+ frmMain.strTeacher +"'";
this.sqlDataAdapter3.SelectCommand.CommandText=sql;
this.sqlDataAdapter3.Fill(this.sds,"收費(fèi)明細(xì)表");
this.dataGrid3.SetDataBinding(this.sds,"收費(fèi)明細(xì)表");
this.dataGrid3.Refresh();
if(frmMain.strTeacherPower!="超級(jí)用戶")
{
this.button2.Enabled=false;
}
}
private void radioButton1_CheckedChanged(object sender, System.EventArgs e)
{
if(this.radioButton1.Checked==true)
{
this.textBox1.Enabled=true;
this.textBox1.Focus();
this.textBox1.SelectAll();
}
else
this.textBox1.Enabled=false;
}
private void radioButton2_CheckedChanged(object sender, System.EventArgs e)
{
if(this.radioButton2.Checked==true)
this.textBox2.Enabled=true;
else
this.textBox2.Enabled=false;
}
private void button1_Click_1(object sender, System.EventArgs e)
{
if(this.radioButton1.Checked==true)
{
sql="select * from 帳戶表 where 條形碼='"+ this.textBox1.Text +"'";
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -