?? clientdatamanage.cs
字號:
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
namespace 進(jìn)銷存管理系統(tǒng)
{
/// <summary>
/// ClientDataManage 的摘要說明。
/// </summary>
public class ClientDataManage : System.Windows.Forms.Form
{
private DataSet ds = new DataSet();
private LinkDataBase link = new LinkDataBase();
private string sendTableName = "客戶清單";
private string sendStrSQL = "SELECT 客戶編號, 拼音編碼, 名稱, 聯(lián)系人, 地址, 郵編, 區(qū)號, 地區(qū), 電話, 傳真, 電報, 簡稱, 開戶行, 開戶行郵編, 銀行帳號, 稅號, 性質(zhì), 業(yè)務(wù)員, 業(yè)務(wù)部門, 授信額度 FROM 客戶清單";
private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox txt_WareWord;
private System.Windows.Forms.Button btn_Search;
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.ToolBar toolBar1;
private System.Windows.Forms.ToolBarButton tbarBtnSave;
private System.Windows.Forms.ToolBarButton tbarBtnDelete;
private System.Windows.Forms.ImageList imageList1;
private System.Windows.Forms.DataGrid dgrd_ClientData;
private System.ComponentModel.IContainer components;
public ClientDataManage()
{
//
// Windows 窗體設(shè)計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
}
//------------重載構(gòu)造函數(shù)，判斷窗體調(diào)用原因-------------
public ClientDataManage(bool blToolBarShow)
{
//
// Windows 窗體設(shè)計器支持所必需的
//
InitializeComponent();
//
// TODO: 在 InitializeComponent 調(diào)用后添加任何構(gòu)造函數(shù)代碼
//
this.ds = this.link.SelectDataBase(sendStrSQL,sendTableName);
//如果blToolBarShow為false,則表示該窗體使由銷售單和進(jìn)貨單雙擊時生成
this.DataGridStateControl(blToolBarShow);
this.dgrd_ClientData.DataSource = ds.Tables[0];
this.toolBar1.Enabled = blToolBarShow;
}
/// <summary>
/// 清理所有正在使用的資源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if(components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}
#region Windows 窗體設(shè)計器生成的代碼
/// <summary>
/// 設(shè)計器支持所需的方法 - 不要使用代碼編輯器修改
/// 此方法的內(nèi)容。
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(ClientDataManage));
this.dgrd_ClientData = new System.Windows.Forms.DataGrid();
this.label1 = new System.Windows.Forms.Label();
this.txt_WareWord = new System.Windows.Forms.TextBox();
this.btn_Search = new System.Windows.Forms.Button();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.toolBar1 = new System.Windows.Forms.ToolBar();
this.tbarBtnSave = new System.Windows.Forms.ToolBarButton();
this.tbarBtnDelete = new System.Windows.Forms.ToolBarButton();
this.imageList1 = new System.Windows.Forms.ImageList(this.components);
((System.ComponentModel.ISupportInitialize)(this.dgrd_ClientData)).BeginInit();
this.groupBox1.SuspendLayout();
this.SuspendLayout();
//
// dgrd_ClientData
//
this.dgrd_ClientData.AllowSorting = false;
this.dgrd_ClientData.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.dgrd_ClientData.CaptionVisible = false;
this.dgrd_ClientData.DataMember = "";
this.dgrd_ClientData.HeaderForeColor = System.Drawing.SystemColors.ControlText;
this.dgrd_ClientData.Location = new System.Drawing.Point(0, 74);
this.dgrd_ClientData.Name = "dgrd_ClientData";
this.dgrd_ClientData.Size = new System.Drawing.Size(720, 350);
this.dgrd_ClientData.TabIndex = 3;
this.dgrd_ClientData.DoubleClick += new System.EventHandler(this.dgrd_ClientData_DoubleClick);
//
// label1
//
this.label1.Location = new System.Drawing.Point(172, 19);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 16);
this.label1.TabIndex = 14;
this.label1.Text = "客戶拼音:";
//
// txt_WareWord
//
this.txt_WareWord.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.txt_WareWord.Location = new System.Drawing.Point(259, 13);
this.txt_WareWord.Name = "txt_WareWord";
this.txt_WareWord.Size = new System.Drawing.Size(224, 21);
this.txt_WareWord.TabIndex = 1;
this.txt_WareWord.Text = "";
//
// btn_Search
//
this.btn_Search.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.btn_Search.Location = new System.Drawing.Point(499, 13);
this.btn_Search.Name = "btn_Search";
this.btn_Search.Size = new System.Drawing.Size(48, 24);
this.btn_Search.TabIndex = 2;
this.btn_Search.Text = "查詢";
this.btn_Search.Click += new System.EventHandler(this.btn_Search_Click);
//
// groupBox1
//
this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.txt_WareWord);
this.groupBox1.Controls.Add(this.btn_Search);
this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.groupBox1.Location = new System.Drawing.Point(1, 23);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(718, 50);
this.groupBox1.TabIndex = 15;
this.groupBox1.TabStop = false;
//
// toolBar1
//
this.toolBar1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.toolBar1.Buttons.AddRange(new System.Windows.Forms.ToolBarButton[] {
this.tbarBtnSave,
this.tbarBtnDelete});
this.toolBar1.DropDownArrows = true;
this.toolBar1.ImageList = this.imageList1;
this.toolBar1.Location = new System.Drawing.Point(0, 0);
this.toolBar1.Name = "toolBar1";
this.toolBar1.ShowToolTips = true;
this.toolBar1.Size = new System.Drawing.Size(720, 29);
this.toolBar1.TabIndex = 4;
this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
//
// tbarBtnSave
//
this.tbarBtnSave.ImageIndex = 0;
this.tbarBtnSave.ToolTipText = "保存修改";
//
// tbarBtnDelete
//
this.tbarBtnDelete.ImageIndex = 1;
this.tbarBtnDelete.ToolTipText = "刪除數(shù)據(jù)";
//
// imageList1
//
this.imageList1.ImageSize = new System.Drawing.Size(16, 16);
this.imageList1.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList1.ImageStream")));
this.imageList1.TransparentColor = System.Drawing.Color.Transparent;
//
// ClientDataManage
//
this.AcceptButton = this.btn_Search;
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(720, 421);
this.Controls.Add(this.toolBar1);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.dgrd_ClientData);
this.Name = "ClientDataManage";
this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
this.Text = "【客戶信息維護(hù)】";
((System.ComponentModel.ISupportInitialize)(this.dgrd_ClientData)).EndInit();
this.groupBox1.ResumeLayout(false);
this.ResumeLayout(false);
}
#endregion
//------------根據(jù)用戶的輸入客戶拼音編碼來搜索客戶信息----------
private void btn_Search_Click(object sender, System.EventArgs e)
{
string strSpellWord = this.txt_WareWord.Text.Trim();
string tempStrSQL = "select * from 客戶清單 where 拼音編碼 like '" + strSpellWord + "%'";
this.link.SelectDataBase(tempStrSQL,sendTableName);
}
//--------------處理保存，刪除，退出等事務(wù)---------------
private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
if (e.Button.ToolTipText == "保存修改")
{
try
{
int row = this.dgrd_ClientData.CurrentCell.RowNumber;
//將當(dāng)前所在行往下移動一行,為便于實現(xiàn)同步保存
//(否則會出現(xiàn)修改的最后一行無法保存,因為它還處于編輯狀態(tài))
this.dgrd_ClientData.CurrentCell = new DataGridCell(row+1,0);
if (this.ds.HasChanges())
{
this.link.UpdateDataBase(this.ds.GetChanges(),sendTableName);
MessageBox.Show("數(shù)據(jù)修改成功!","信息");
}
else
{
MessageBox.Show("沒有修改的數(shù)據(jù)!");
return;
}
}
catch
{
MessageBox.Show("數(shù)據(jù)保存失敗,請確認(rèn)所有信息輸入完整且正確!","提示");
return;
}
}
if (e.Button.ToolTipText == "刪除數(shù)據(jù)")
{
if (MessageBox.Show("確實要刪除這條記錄嗎?","詢問",MessageBoxButtons.YesNo) == DialogResult.Yes)
{
int intRowNumber = this.dgrd_ClientData.CurrentCell.RowNumber;
try
{
this.ds.Tables[0].Rows[intRowNumber].Delete();
this.link.UpdateDataBase(this.ds.GetChanges(),sendTableName);
MessageBox.Show("數(shù)據(jù)刪除成功!","信息");
}
catch
{
MessageBox.Show("該數(shù)據(jù)不能刪除!","提示");
string tempStrSQL = "select * from " + sendTableName;
this.link.SelectDataBase(tempStrSQL,sendTableName);
return;
}
}
}
}
//------------設(shè)置表格格式--------------
private void DataGridStateControl(bool blReadonly)
{
DataGridTableStyle ts = new DataGridTableStyle();
ts.AlternatingBackColor = Color.LightGray;
ts.MappingName = this.ds.Tables[0].TableName;
ts.AllowSorting = false;
int numCols = this.ds.Tables[0].Columns.Count;
for (int i = 0;i< numCols;i++)
{
if (blReadonly == true)
{
//生成下拉列表框的列
if ( i == 3)
{
DataTable tempTable = new DataTable();
tempTable = this.link.SelectDataBase("select 姓名 from 業(yè)務(wù)員清單");
DataGridComboBoxColumn aComboBoxColumn = new DataGridComboBoxColumn(tempTable,0,0);
aComboBoxColumn.MappingName = this.ds.Tables[0].Columns[i].ColumnName;
aComboBoxColumn.HeaderText = this.ds.Tables[0].Columns[i].ColumnName;
aComboBoxColumn.NullText = "";
ts.GridColumnStyles.Add(aComboBoxColumn);
}
else
{
DataGridTextBoxColumn aColumnTextColumn = new DataGridTextBoxColumn();
aColumnTextColumn.MappingName = this.ds.Tables[0].Columns[i].ColumnName;
aColumnTextColumn.HeaderText = this.ds.Tables[0].Columns[i].ColumnName;
aColumnTextColumn.NullText = "";
aColumnTextColumn.Format = "F";
ts.GridColumnStyles.Add(aColumnTextColumn);
}
}
else
{
DataGridNoActiveCellColumn aColumnTextColumn = new DataGridNoActiveCellColumn();
aColumnTextColumn.MappingName = this.ds.Tables[0].Columns[i].ColumnName;
aColumnTextColumn.HeaderText = this.ds.Tables[0].Columns[i].ColumnName;
aColumnTextColumn.NullText = "";
aColumnTextColumn.Format = "F";
ts.GridColumnStyles.Add(aColumnTextColumn);
}
}
this.dgrd_ClientData.TableStyles.Add(ts);
}
//---------------其他窗體調(diào)用客戶信息窗體，雙擊選擇數(shù)據(jù)并回送--------------
private void dgrd_ClientData_DoubleClick(object sender, System.EventArgs e)
{
if (this.dgrd_ClientData.ReadOnly == true) //判斷如果是在銷售單中生成的窗體則不響應(yīng)DataGrid的雙擊事件
{
int intCurrentRowNumber = this.dgrd_ClientData.CurrentCell.RowNumber;
string sendClientID,sendClientName;
sendClientID = this.dgrd_ClientData[intCurrentRowNumber,0].ToString().Trim();
sendClientName = this.dgrd_ClientData[intCurrentRowNumber,2].ToString().Trim();
string [] sendArray = new string [] {sendClientID,sendClientName};
SellTable.inputTextDataArray[0] = sendArray[0];
SellTable.inputTextDataArray[1] = sendArray[1];
this.Close();
}
}
public void setDataGridReadOnly()
{
this.dgrd_ClientData.ReadOnly = true;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -