📄 账户管理.cs
字号:
//
// 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("班级", "班级"),
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 (班级 = @Original_班级) 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_班级", 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.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "锁定", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = "INSERT INTO 帐户表(条形码, 班级, 姓名, 余额, 锁定) VALUES (@条形码, @班级, @姓名, @余额, @锁定); SELECT 条形" +
"码, 班级, 姓名, 余额, 锁定 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("@班级", System.Data.SqlDbType.VarChar, 50, "班级"));
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 条形码, 班级, 姓名, 余额, 锁定 FROM 帐户表";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = "UPDATE 帐户表 SET 条形码 = @条形码, 班级 = @班级, 姓名 = @姓名, 余额 = @余额, 锁定 = @锁定 WHERE (条形码 = @O" +
"riginal_条形码) AND (余额 = @Original_余额) AND (姓名 = @Original_姓名) AND (班级 = @Original" +
"_班级) AND (锁定 = @Original_锁定); SELECT 条形码, 班级, 姓名, 余额, 锁定 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("@班级", System.Data.SqlDbType.VarChar, 50, "班级"));
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_班级", 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.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("流水号", "流水号"),
new System.Data.Common.DataColumnMapping("条形码", "条形码"),
new System.Data.Common.DataColumnMapping("上机时间", "上机时间"),
new System.Data.Common.DataColumnMapping("下机时间", "下机时间"),
new System.Data.Common.DataColumnMapping("花费", "花费"),
new System.Data.Common.DataColumnMapping("上机状态", "上机状态"),
new System.Data.Common.DataColumnMapping("上机区域", "上机区域"),
new System.Data.Common.DataColumnMapping("值班教师", "值班教师")})});
this.sqlDataAdapter2.UpdateCommand = this.sqlUpdateCommand2;
//
// sqlDeleteCommand2
//
this.sqlDeleteCommand2.CommandText = @"DELETE FROM 流水帐表 WHERE (流水号 = @Original_流水号) AND (上机区域 = @Original_上机区域 OR @Original_上机区域 IS NULL AND 上机区域 IS NULL) AND (上机时间 = @Original_上机时间 OR @Original_上机时间 IS NULL AND 上机时间 IS NULL) AND (上机状态 = @Original_上机状态 OR @Original_上机状态 IS NULL AND 上机状态 IS NULL) AND (下机时间 = @Original_下机时间 OR @Original_下机时间 IS NULL AND 下机时间 IS NULL) AND (值班教师 = @Original_值班教师 OR @Original_值班教师 IS NULL AND 值班教师 IS NULL) AND (条形码 = @Original_条形码 OR @Original_条形码 IS NULL AND 条形码 IS NULL) AND (花费 = @Original_花费 OR @Original_花费 IS NULL AND 花费 IS NULL)";
this.sqlDeleteCommand2.Connection = this.sqlConnection1;
this.sqlDeleteCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_流水号", System.Data.SqlDbType.BigInt, 8, 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, 10, 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.DateTime, 8, 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.Int, 4, 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.DateTime, 8, 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_条形码", 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.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Original, null));
//
// sqlInsertCommand2
//
this.sqlInsertCommand2.CommandText = "INSERT INTO 流水帐表(条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师) VALUES (@条形码, @上机时间, @下机时" +
"间, @花费, @上机状态, @上机区域, @值班教师); SELECT 流水号, 条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师 " +
"FROM 流水帐表 WHERE (流水号 = @@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("@上机时间", System.Data.SqlDbType.DateTime, 8, "上机时间"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下机时间", System.Data.SqlDbType.DateTime, 8, "下机时间"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@花费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Current, null));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机状态", System.Data.SqlDbType.Int, 4, "上机状态"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机区域", System.Data.SqlDbType.VarChar, 10, "上机区域"));
this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@值班教师", System.Data.SqlDbType.VarChar, 50, "值班教师"));
//
// sqlSelectCommand2
//
this.sqlSelectCommand2.CommandText = "SELECT 流水号, 条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师 FROM 流水帐表";
this.sqlSelectCommand2.Connection = this.sqlConnection1;
//
// sqlUpdateCommand2
//
this.sqlUpdateCommand2.CommandText = @"UPDATE 流水帐表 SET 条形码 = @条形码, 上机时间 = @上机时间, 下机时间 = @下机时间, 花费 = @花费, 上机状态 = @上机状态, 上机区域 = @上机区域, 值班教师 = @值班教师 WHERE (流水号 = @Original_流水号) AND (上机区域 = @Original_上机区域 OR @Original_上机区域 IS NULL AND 上机区域 IS NULL) AND (上机时间 = @Original_上机时间 OR @Original_上机时间 IS NULL AND 上机时间 IS NULL) AND (上机状态 = @Original_上机状态 OR @Original_上机状态 IS NULL AND 上机状态 IS NULL) AND (下机时间 = @Original_下机时间 OR @Original_下机时间 IS NULL AND 下机时间 IS NULL) AND (值班教师 = @Original_值班教师 OR @Original_值班教师 IS NULL AND 值班教师 IS NULL) AND (条形码 = @Original_条形码 OR @Original_条形码 IS NULL AND 条形码 IS NULL) AND (花费 = @Original_花费 OR @Original_花费 IS NULL AND 花费 IS NULL); SELECT 流水号, 条形码, 上机时间, 下机时间, 花费, 上机状态, 上机区域, 值班教师 FROM 流水帐表 WHERE (流水号 = @流水号)";
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("@上机时间", System.Data.SqlDbType.DateTime, 8, "上机时间"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@下机时间", System.Data.SqlDbType.DateTime, 8, "下机时间"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@花费", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Current, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机状态", System.Data.SqlDbType.Int, 4, "上机状态"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@上机区域", System.Data.SqlDbType.VarChar, 10, "上机区域"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@值班教师", System.Data.SqlDbType.VarChar, 50, "值班教师"));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_流水号", System.Data.SqlDbType.BigInt, 8, 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, 10, 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.DateTime, 8, 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.Int, 4, 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.DateTime, 8, 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_条形码", 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.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "花费", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@流水号", System.Data.SqlDbType.BigInt, 8, "流水号"));
//
// sqlDataAdapter3
//
this.sqlDataAdapter3.SelectCommand = this.sqlSelectCommand3;
this.sqlDataAdapter3.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "收费流水表", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("ID", "ID"),
new System.Data.Common.DataColumnMapping("姓名", "姓名"),
new System.Data.Common.DataColumnMapping("班级", "班级"),
new System.Data.Common.DataColumnMapping("时间", "时间"),
new System.Data.Common.DataColumnMapping("条形码", "条形码"),
new System.Data.Common.DataColumnMapping("值班教师", "值班教师"),
new System.Data.Common.DataColumnMapping("收费", "收费"),
new System.Data.Common.DataColumnMapping("充值", "充值"),
new System.Data.Common.DataColumnMapping("余额", "余额")})});
//
// sqlSelectCommand3
//
this.sqlSelectCommand3.CommandText = "SELECT 收费流水表.ID, 帐户表.姓名, 帐户表.班级, 收费流水表.时间, 收费流水表.条形码, 收费流水表.值班教师, 收费流水表.收费, 收费流水表" +
".充值, 帐户表.余额 FROM 收费流水表 INNER JOIN 帐户表 ON 收费流水表.条形码 = 帐户表.条形码";
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 收费流水表.ID, 帐户表.姓名, 帐户表.班级, 收费流水表.时间, 收费流水表.条形码, 收费流水表.值班教师, 收费流水表.收费, 收费流水表.充值, 帐户表.余额 FROM 收费流水表 INNER JOIN 帐户表 ON 收费流水表.条形码 = 帐户表.条形码
/*
sds.Tables["流水帐表"].Clear();
sql="select * from 流水帐表 where 上机状态='1'";
this.sqlDataAdapter2.SelectCommand.CommandText=sql;
this.sqlDataAdapter2.Fill(sds,"流水帐表");
this.dataGrid2.SetDataBinding(sds,"流水帐表");
this.dataGrid2.Refresh();
*/
string sql="SELECT 收费流水表.ID, 帐户表.姓名, 帐户表.班级, 收费流水表.时间, 收费流水表.条形码, 收费流水表.值班教师, 收费流水表.收费, 收费流水表.充值, 帐户表.余额 FROM 收费流水表 INNER JOIN 帐户表 ON 收费流水表.条形码 = 帐户表.条形码 and 收费流水表.时间>'"+ this.dateTimePicker1.Value.Date.ToString() +"' and 收费流水表.时间<'"+ this.dateTimePicker1.Value.Date.AddDays(1).Date.ToString() +"' and 值班教师='"+ frmMain.strTeacher +"'";
this.sqlDataAdapter3.SelectCommand.CommandText=sql;
this.sqlDataAdapter3.Fill(this.sds,"收费明细表");
this.dataGrid3.SetDataBinding(this.sds,"收费明细表");
this.dataGrid3.Refresh();
if(frmMain.strTeacherPower!="超级用户")
{
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 +"'";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -