?? booksubscribe.cs
字號:
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, 100, "訂購者"));
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.Money, 8, "訂購單價"));
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.Bit, 1, "是否驗收"));
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("@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.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.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.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.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, 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, 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.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "驗收日期", System.Data.DataRowVersion.Original, null));
//
// BookSubscribe
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(616, 493);
this.Controls.Add(this.btnSusbribe);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.toolBar1);
this.Controls.Add(this.groupBox1);
this.Name = "BookSubscribe";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【圖書征訂】";
this.Load += new System.EventHandler(this.BookSubscribe_Load);
this.groupBox1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox2.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
//------------創建窗體時讀入數據------------
private void BookSubscribe_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 txt4_TextChanged(object sender, System.EventArgs e)
{
if(txt4.ReadOnly==false||txt4.Text.Trim()=="")//無內容或者是編輯狀態時，無需查詢
{
return;
}
string connStr="workstation id=localhost;Integrated Security=SSPI;Database=libbook;";
SqlConnection cn=new SqlConnection(connStr);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
cmd.CommandText="select 書名 from 圖書信息 where 編號='"+txt4.Text.Trim()+"'";
cmb1.Text=cmd.ExecuteScalar().ToString().Trim();
}
//----------根據輸入的信息，查詢征訂圖書信息--------
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);
cmb1.Text="";
}
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(txt4.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;
txt6.ReadOnly=!blnEdit;
txt7.ReadOnly=!blnEdit;
txt8.ReadOnly=!blnEdit;
txt9.ReadOnly=!blnEdit;
txt10.ReadOnly=!blnEdit;
cmb1.Enabled=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="000000"+maxID.ToString();
break;
case 2:
txt3.Text="00000"+maxID.ToString();
break;
case 3:
txt3.Text="0000"+maxID.ToString();
break;
case 4:
txt3.Text="000"+maxID.ToString();
break;
case 5:
txt3.Text="00"+maxID.ToString();
break;
case 6:
txt3.Text="0"+maxID.ToString();
break;
}
}
//------------調出圖書選擇窗體，選擇圖書-------------
private void cmb1_DropDown(object sender, System.EventArgs e)
{
cmb1.Text="";//清空原有書名
SelectBook newfrm=new SelectBook();//調出新窗口選擇圖書
newfrm.Text="雙擊表格選擇圖書";
newfrm.ShowDialog();
txt4.Text=bookID;//讀入選擇的圖書信息
cmb1.Text=bookName;
}
//-----------調用儲存過程，提交圖書征訂----------
private void btnSusbribe_Click(object sender, System.EventArgs e)
{
string strConn = "workstation id=localhost;Integrated Security=SSPI;database=libbook";
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
cmd.CommandText="exec sf_圖書征訂";
try
{
cmd.ExecuteNonQuery();
dataSet11.圖書征訂.Clear();//刷新數據集
da1.SelectCommand.Parameters[0].Value="%";
da1.SelectCommand.Parameters[1].Value="%";
da1.Fill(dataSet11);
return;
}
catch(Exception express)
{
MessageBox.Show(express.ToString(),"無法驗收",MessageBoxButtons.OK,MessageBoxIcon.Error);
return;
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -