📄 frmroomtype.cs
字号:
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));
this.sqlDeleteCommand1.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));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=ACER;packet size=4096;integrated security=SSPI;data source=ACER;pe" +
"rsist security info=False;initial catalog=hotelbook";
//
// 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, 4, "类型编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型名称", System.Data.SqlDbType.VarChar, 40, "类型名称"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@价格", System.Data.SqlDbType.Money, 8, "价格"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼房价格", System.Data.SqlDbType.Money, 8, "拼房价格"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@可超预定数", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "可超预定数", 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 (类型编号 = @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); SELECT 类型编号, 类型名称, 价格, 拼房价格, 可超预定数, 是否可拼房 FROM 客房类型 WHERE (类型编号 = @类型编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型编号", System.Data.SqlDbType.VarChar, 4, "类型编号"));
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.Money, 8, "价格"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@拼房价格", System.Data.SqlDbType.Money, 8, "拼房价格"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@可超预定数", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "可超预定数", 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, 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.Money, 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.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(3)), ((System.Byte)(0)), "可超预定数", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_拼房价格", System.Data.SqlDbType.Money, 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.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, 40, 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");
//
// frmRoomType
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(506, 263);
this.Controls.Add(this.GroupBox1);
this.Name = "frmRoomType";
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.Visible = false;
txbThree.Visible = false;
}
public override void LoadData()
{
string strFilter = "";
if ( txbOne.Text.Trim().Length == 0 )
{
if ( txbTwo.Text.Trim().Length != 0 )
{
strFilter = "where 类型编号 like '";
strFilter += txbTwo.Text.Trim() + "%'";
}
}
else
{
strFilter = "where 类型名称 like '";
strFilter += txbOne.Text.Trim() + "%'";
if ( txbTwo.Text.Trim().Length != 0 )
{
strFilter += " and 类型编号 like '";
strFilter += txbTwo.Text.Trim() + "%'";
}
}
// 清空DataSet11
dataSet11.Clear();
sqlConnection1.ConnectionString = DataBase.sConn;
// string strSQL;
sqlDataAdapter1.SelectCommand.CommandText = "select * from 客房类型 " + strFilter;
//根据查询条件重新填充DataSet11
sqlDataAdapter1.Fill( dataSet11 );
dtData = dataSet11.Tables[ "客房类型" ];
bmData = this.BindingContext[ dataSet11, "客房类型" ];
if ( bmData.Count != 0 )
{
bmData.Position = 0;
}
}
public override void SetDataGrid()
{
LoadData();
// 定义一个DataGrid表样式
DataGridTableStyle ts = new DataGridTableStyle();
DataGridTextBoxColumn aCol;
int numCols = dtData.Columns.Count;
for ( int i = 0; i <= numCols; i ++ )
{
aCol = new DataGridTextBoxColumn();
aCol.MappingName = dtData.Columns[ i ].ColumnName;
aCol.HeaderText = dtData.Columns[ i ].ColumnName;
aCol.NullText = "";
aCol.ReadOnly = true;
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 = "";
txbDays.Text = "";
txbName.Text = "";
txbPinPrice.Text = "";
txbPrice.Text = "";
ckbPin.Checked = true;
}
public override void SaveForAdd()
{
DataRow dr = dataSet11.Tables[ "客房类型" ].NewRow();
try
{
dr[ "类型编号" ] = txbCode.Text.Trim();
dr[ "类型名称" ] = txbName.Text.Trim();
dr[ "可超预订数" ] = txbDays.Text.Trim();
dr[ "拼房价格" ] = txbPinPrice.Text.Trim();
dr[ "价格" ] = txbPrice.Text.Trim();
dr[ "是否可拼房" ] = ckbPin.Checked;
}
catch ( Exception ex )
{
MessageBox.Show( "数据格式不正确" + ex.ToString() );
return;
}
try
{
dataSet11.Tables[ "客房类型" ].Rows.Add( dr );
if ( dataSet11.HasChanges() )
{
sqlDataAdapter1.Update( dataSet11 );
}
}
catch ( Exception ex )
{
MessageBox.Show( "数据添加失败" + ex.ToString() );
}
LoadData();
dgdList.DataSource = dtData.DefaultView;
}
public override void DeleteData()
{
try
{
// 产出当前行的数据
dataSet11.Tables[ "客房类型" ].Rows[ bmData.Position ].Delete();
if ( dataSet11.HasChanges() )
{
// 更新dataSet11
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 + -