?? bookclassify.cs
字號:
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.TabIndex = 2;
this.txt4.Text = "";
//
// label4
//
this.label4.Location = new System.Drawing.Point(392, 200);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 16);
this.label4.TabIndex = 1;
this.label4.Text = "可借天數";
//
// txt5
//
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "圖書類型.類型名稱"));
this.txt5.Location = new System.Drawing.Point(392, 280);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.Size = new System.Drawing.Size(168, 21);
this.txt5.TabIndex = 2;
this.txt5.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(392, 264);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(64, 16);
this.label5.TabIndex = 1;
this.label5.Text = "類型名稱";
//
// da1
//
this.da1.DeleteCommand = this.sqlDeleteCommand1;
this.da1.InsertCommand = this.sqlInsertCommand1;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.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("可借天數", "可借天數")})});
this.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 圖書類型 WHERE (類型編號 = @Original_類型編號) AND (可借天數 = @Original_可借天數 OR @Ori" +
"ginal_可借天數 IS NULL AND 可借天數 IS NULL) AND (類型名稱 = @Original_類型名稱 OR @Original_類型名" +
"稱 IS NULL AND 類型名稱 IS NULL)";
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.Int, 4, 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, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "類型名稱", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=libbook;";
//
// 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, 100, "類型名稱"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@可借天數", System.Data.SqlDbType.Int, 4, "可借天數"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT 類型編號, 類型名稱, 可借天數 FROM 圖書類型 WHERE (類型編號 LIKE @Param3) AND (類型名稱 LIKE @Param" +
"4)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "類型編號"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 100, "類型名稱"));
//
// 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); 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, 100, "類型名稱"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@可借天數", System.Data.SqlDbType.Int, 4, "可借天數"));
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.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));
//
// BookClassify
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(584, 485);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.toolBar1);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.txt3);
this.Controls.Add(this.label3);
this.Controls.Add(this.txt4);
this.Controls.Add(this.label4);
this.Controls.Add(this.txt5);
this.Controls.Add(this.label5);
this.Name = "BookClassify";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【圖書類型設置】";
this.Load += new System.EventHandler(this.BookClassify_Load);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
}
#endregion
//---------顯示窗口，讀入全部數據-----------
private void BookClassify_Load(object sender, System.EventArgs e)
{
da1.SelectCommand.Parameters[0].Value="%%";
da1.SelectCommand.Parameters[1].Value="%%";
da1.Fill(dataSet11);
//設置數據導航
cmOrders=(CurrencyManager) BindingContext[dataSet11,"圖書類型"];
}
//----------根據輸入的信息，查詢圖書類型信息--------
private void btnSearch_Click(object sender, System.EventArgs e)
{
da1.SelectCommand.Parameters[0].Value="%%";
da1.SelectCommand.Parameters[1].Value="%%";
if(txt1.Text!="")
{
da1.SelectCommand.Parameters[0].Value="%"+txt1.Text+"%";
}
if(txt2.Text!="")
{
da1.SelectCommand.Parameters[1].Value="%"+txt2.Text+"%";
}
dataSet11.圖書類型.Clear();
da1.Fill(dataSet11);
}
//-------------處理工具欄事務------------
private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
if (e.Button.ToolTipText == "首記錄")
{
this.dataGrid1.UnSelect(cmOrders.Position); //取消原選中的行
cmOrders.Position = 0;
this.dataGrid1.Select(cmOrders.Position); //選中當前行
this.dataGrid1.CurrentRowIndex = cmOrders.Position; //移動表頭指示圖標
return;
}
if (e.Button.ToolTipText == "上一記錄")
{
if (cmOrders.Position >= 0)
{
this.dataGrid1.UnSelect(cmOrders.Position);
cmOrders.Position--;
this.dataGrid1.Select(cmOrders.Position);
this.dataGrid1.CurrentRowIndex = cmOrders.Position;
}
return;
}
if (e.Button.ToolTipText == "下一記錄")
{
if (cmOrders.Position <= cmOrders.Count-1)
{
this.dataGrid1.UnSelect(cmOrders.Position);
cmOrders.Position++;
this.dataGrid1.Select(cmOrders.Position);
this.dataGrid1.CurrentRowIndex = cmOrders.Position;
}
return;
}
if (e.Button.ToolTipText == "尾記錄")
{
this.dataGrid1.UnSelect(cmOrders.Position);
cmOrders.Position = cmOrders.Count-1;
this.dataGrid1.Select(cmOrders.Position);
this.dataGrid1.CurrentRowIndex = cmOrders.Position;
return;
}
if(e.Button.ToolTipText=="新增")
{
cmOrders.AddNew();
//設置默認值
SetDefaultValue();
//設置編輯屬性
SetModifyMode(true);
}
if(e.Button.ToolTipText=="修改")
{
SetModifyMode(true);
}
if(e.Button.ToolTipText=="刪除")
{
DialogResult result=MessageBox.Show("確認刪除？","刪除數據",MessageBoxButtons.OKCancel);
if(result==DialogResult.OK)
if(cmOrders.Count>0)//立即從數據集中刪除
{
cmOrders.RemoveAt(cmOrders.Position);
da1.Update(dataSet11);
}
else
MessageBox.Show("表中為空，已無可刪除數據","提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
if(e.Button.ToolTipText=="提交")
{
if(txt3.Text.Trim()=="")//檢查字段
{
MessageBox.Show("請輸入類型編號","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
if(txt5.Text.Trim()=="")
{
MessageBox.Show("請輸入類型名稱","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
cmOrders.EndCurrentEdit();
if(dataSet11.GetChanges()!=null)
{
try
{
da1.Update(dataSet11);
SetModifyMode(false);
}
catch(Exception express)
{
MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
dataSet11.RejectChanges();
}
}
return;
}
if (e.Button.ToolTipText == "取消")
{
try
{
cmOrders.CancelCurrentEdit(); //取消編輯
SetModifyMode(false);
}
catch(Exception express)
{
MessageBox.Show(express.ToString(),"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
return;
}
if(e.Button.ToolTipText=="退出")
{
this.Close();
}
}
//--------------對控件的屬性做設置---------------
private void SetModifyMode(bool blnEdit)
{
//設置文本框和下拉列表框屬性
txt4.ReadOnly=!blnEdit;
txt5.ReadOnly=!blnEdit;
txt3.ReadOnly=!blnEdit;
//設置搜索按鈕屬性
btnSearch.Enabled=!blnEdit;
}
//------------在新增數據時，設置默認值--------------
private void SetDefaultValue()
{
string strConn = "workstation id=localhost;Integrated Security=SSPI;database=libbook";
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
cmd.CommandText="select max(類型編號) 最大編號 from 圖書類型";
int maxID=1;//計算新編號
object result=cmd.ExecuteScalar();
if(result!=System.DBNull.Value)
{
maxID=Convert.ToInt32(result)+1;
}
int length=maxID.ToString().Length;
switch(length)
{
case 1:
txt3.Text="00"+maxID.ToString();
break;
case 2:
txt3.Text="0"+maxID.ToString();
break;
case 3:
txt3.Text=maxID.ToString();
break;
}
txt4.Text="1";//設置默認可借天數
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -