📄 frmreaderdoc.cs
字号:
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.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) 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_类型) AND (联系方式 = @Original_联系方式 OR @Original_联系方式 IS NULL AND 联系方式 IS NULL) AND (证件号码 = @Original_证件号码 OR @Original_证件号码 IS NULL AND 证件号码 IS NULL); SELECT 条形码, 编号, 姓名, 性别, 类型, 出生日期, 有效证件, 证件号码, 联系方式, 登记日期, 有限期至, 操作员, 备注, 图书借阅次数, 期刊借阅次数, 是否挂失 FROM 读者信息 WHERE (编号 = @编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@条形码", System.Data.SqlDbType.VarChar, 40, "条形码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 20, "编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@姓名", System.Data.SqlDbType.VarChar, 20, "姓名"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@性别", System.Data.SqlDbType.VarChar, 8, "性别"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型", System.Data.SqlDbType.VarChar, 20, "类型"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出生日期", System.Data.SqlDbType.DateTime, 4, "出生日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@有效证件", System.Data.SqlDbType.VarChar, 60, "有效证件"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@证件号码", System.Data.SqlDbType.VarChar, 60, "证件号码"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系方式", System.Data.SqlDbType.VarChar, 100, "联系方式"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@登记日期", System.Data.SqlDbType.DateTime, 4, "登记日期"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@有限期至", System.Data.SqlDbType.DateTime, 4, "有限期至"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 20, "操作员"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@备注", System.Data.SqlDbType.VarChar, 100, "备注"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@图书借阅次数", System.Data.SqlDbType.Int, 4, "图书借阅次数"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@期刊借阅次数", System.Data.SqlDbType.Int, 4, "期刊借阅次数"));
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, 20, 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.DateTime, 4, 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.Int, 4, 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, 100, 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, 20, 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, 8, 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, 20, 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));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_有效证件", System.Data.SqlDbType.VarChar, 60, 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.DateTime, 4, 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.Int, 4, 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, 40, 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.DateTime, 4, 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, 20, 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, 100, 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, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "证件号码", System.Data.DataRowVersion.Original, null));
//
// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// frmReaderDoc
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(456, 269);
this.Controls.Add(this.GroupBox1);
this.Name = "frmReaderDoc";
this.Controls.SetChildIndex(this.dgdList, 0);
this.Controls.SetChildIndex(this.GroupBox1, 0);
((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();
this.GroupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
} #endregion public override void Prepare()
{
this.Text = "读者档案管理";
Label1.Text = "条形码";
Label2.Text = "编号";
Label3.Text = "姓名";
DataBase db = new DataBase();
DataView dv = db.RunSelectSQL( "select 类型 from 读者类型" );
foreach ( DataRow dr in dv.Table.Rows )
{
cbbType.Items.Add( dr[ 0 ].ToString().Trim() );
}
}
public override void LoadData()
{
string strFilter = "";
if ( txbOne.Text.Trim().Length == 0 )
{
if ( txbTwo.Text.Trim().Length == 0 )
{
if ( txbThree.Text.Trim().Length == 0 )
strFilter = "";
else
{
strFilter = "where 姓名 like '";
strFilter += txbThree.Text.Trim() + "%'";
}
}
else
{
strFilter = "where 编号 like '";
strFilter += txbTwo.Text.Trim() + "%'";
if ( txbThree.Text.Trim().Length != 0 )
strFilter += " and 姓名 like '" + txbThree.Text.Trim() + "%'";
}
}
else
{
strFilter = "where 条形码 like '" + txbOne.Text.Trim() + "%'";
if ( txbTwo.Text.Trim().Length != 0 )
{
strFilter += " and 编号 like '" + txbTwo.Text.Trim() + "%'";
if ( txbThree.Text.Trim().Length != 0 )
strFilter += " and 姓名 like '" + txbThree.Text.Trim() + "%'";
}
else
{
if ( txbThree.Text.Trim().Length != 0 )
strFilter += " and 姓名 like '" + txbThree.Text.Trim() + "%'";
}
}
dataSet11.Clear();
sqlConnection1.ConnectionString = DataBase.sConn;
// string strSQL;
sqlDataAdapter1.SelectCommand.CommandText = "select * from 读者信息 " + strFilter;
sqlDataAdapter1.Fill( dataSet11 );
dtData = dataSet11.Tables[ "读者信息" ];
bmData = this.BindingContext[ dataSet11, "读者信息" ];
if ( bmData.Count != 0 )
{
bmData.Position = 0;
}
}
public override void SetDataGrid()
{
LoadData();
DataGridTableStyle ts = new DataGridTableStyle();
DataGridTextBoxColumn aCol;
int numCols = dtData.Columns.Count;
for ( int i = 0; i < 14; i ++ )
{
aCol = new DataGridTextBoxColumn();
aCol.MappingName = dtData.Columns[ i ].ColumnName;
aCol.HeaderText = dtData.Columns[ i ].ColumnName;
aCol.NullText = "";
aCol.Width = 60;
ts.GridColumnStyles.Add( aCol );
}
ts.AlternatingBackColor = Color.LightGray;
ts.AllowSorting = false;
ts.MappingName = dtData.TableName;
dgdList.TableStyles.Clear();
dgdList.TableStyles.Add( ts );
DataView dv = dtData.DefaultView;
dv.AllowNew = false;
dv.AllowDelete = false;
// dv.AllowEdit = false;
dgdList.DataSource = dv;
bmData = this.BindingContext[ dataSet11, "读者信息" ];
lblCount .Text = "记录数:" + dtData.Rows.Count.ToString();
}
public override void SetTextBoxState(bool bState)
{
GroupBox1.Enabled = !bState;
}
public override void Clear()
{
txbCode.Text = "";
txbContact.Text = "";
txbName.Text = "";
txbNumber.Text = "";
txbPaperID.Text = "";
txbRemark.Text = "";
txbTimes.Text = "";
txbWorker.Text = "";
cbbPaper.Text = "";
cbbSex.Text = "";
cbbType.Text = "";
tmBirth.Value = DateTime.Now;
tmEnd.Value = DateTime.Now;
tmRegister.Value = DateTime.Now;
}
public override void SaveForAdd()
{
DataRow dr = dataSet11.Tables[ "读者信息" ].NewRow();
try
{
dr[ "条形码" ] = txbCode.Text.Trim();
dr[ "编号" ] = txbContact.Text.Trim();
dr[ "姓名" ] = txbName.Text.Trim();
dr[ "性别" ] = cbbSex.Text.Trim();
dr[ "类型" ] = cbbType.Text.ToString();
dr[ "联系方式" ] = txbContact.Text.Trim();
dr[ "有效证件" ] = cbbPaper.Text.Trim();
dr[ "证件号码" ] = txbPaperID.Text.Trim();
dr[ "出生日期" ] = tmBirth.Text.Trim();
dr[ "登记日期" ] = tmRegister.Text.Trim();
dr[ "有限期至" ] = tmEnd.Text.Trim();
dr[ "图书借阅次数" ] = txbTimes.Text.Trim();
dr[ "操作员" ] = txbWorker.Text.Trim();
dr[ "备注" ] = txbRemark.Text.Trim();
dr[ "是否挂失" ] = cbbGuaShi.Checked.ToString();
}
catch ( Exception ex )
{
MessageBox.Show("数据格式不正确！" + ex.ToString() );
return;
}
LoadData();
dgdList.DataSource = dtData.DefaultView;
}
public override void DeleteData()
{
try
{
dataSet11.Tables[ "读者信息" ].Rows[ bmData.Position ].Delete();
if ( dataSet11.HasChanges() )
sqlDataAdapter1.Update( dataSet11 );
}
catch ( Exception ex )
{
MessageBox.Show( ex.ToString() );
}
}
public override void SaveForUpdate()
{
try
{
int row = dgdList.CurrentCell.RowNumber;
dgdList.CurrentCell = new DataGridCell( ( row + 1 ) % bmData.Count, 0 );
if ( dataSet11.HasChanges() )
sqlDataAdapter1.Update( dataSet11 );
}
catch ( Exception ex )
{
MessageBox.Show( ex.ToString() );
}
}
}}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -