?? customersmanage.cs
字號:
//
this.txtCtelnumber.EditValue = "";
this.txtCtelnumber.Location = new System.Drawing.Point(96, 48);
this.txtCtelnumber.Name = "txtCtelnumber";
//
// txtCtelnumber.Properties
//
this.txtCtelnumber.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
this.txtCtelnumber.Size = new System.Drawing.Size(272, 21);
this.txtCtelnumber.TabIndex = 38;
//
// txtname
//
this.txtname.EditValue = "";
this.txtname.Location = new System.Drawing.Point(96, 24);
this.txtname.Name = "txtname";
//
// txtname.Properties
//
this.txtname.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
this.txtname.Size = new System.Drawing.Size(272, 21);
this.txtname.TabIndex = 37;
//
// label9
//
this.label9.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label9.Location = new System.Drawing.Point(32, 48);
this.label9.Name = "label9";
this.label9.Size = new System.Drawing.Size(72, 23);
this.label9.TabIndex = 30;
this.label9.Text = "客戶來電";
this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label8
//
this.label8.BackColor = System.Drawing.Color.Transparent;
this.label8.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label8.Location = new System.Drawing.Point(32, 96);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(72, 23);
this.label8.TabIndex = 36;
this.label8.Text = "客戶地址";
this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label7
//
this.label7.BackColor = System.Drawing.Color.Transparent;
this.label7.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label7.Location = new System.Drawing.Point(392, 24);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(72, 23);
this.label7.TabIndex = 34;
this.label7.Text = "客戶性別";
this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// cbCType
//
this.cbCType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
this.cbCType.Location = new System.Drawing.Point(472, 48);
this.cbCType.Name = "cbCType";
this.cbCType.Size = new System.Drawing.Size(216, 20);
this.cbCType.TabIndex = 3;
this.cbCType.SelectedIndexChanged += new System.EventHandler(this.cbCType_SelectedIndexChanged_1);
//
// label3
//
this.label3.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label3.Location = new System.Drawing.Point(392, 96);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(72, 23);
this.label3.TabIndex = 21;
this.label3.Text = "聯(lián)系方式";
this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label1
//
this.label1.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label1.Location = new System.Drawing.Point(32, 128);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(72, 23);
this.label1.TabIndex = 20;
this.label1.Text = "備注信息";
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label4
//
this.label4.BackColor = System.Drawing.Color.Transparent;
this.label4.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label4.Location = new System.Drawing.Point(392, 48);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(72, 23);
this.label4.TabIndex = 22;
this.label4.Text = "客戶類別";
this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label2
//
this.label2.BackColor = System.Drawing.Color.Transparent;
this.label2.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label2.Location = new System.Drawing.Point(32, 24);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(72, 23);
this.label2.TabIndex = 19;
this.label2.Text = "客戶姓名";
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label6
//
this.label6.BackColor = System.Drawing.Color.Transparent;
this.label6.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label6.Location = new System.Drawing.Point(32, 72);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(72, 23);
this.label6.TabIndex = 24;
this.label6.Text = "傳真號碼";
this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label5
//
this.label5.BackColor = System.Drawing.Color.Transparent;
this.label5.Font = new System.Drawing.Font("宋體", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
this.label5.Location = new System.Drawing.Point(392, 72);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(72, 23);
this.label5.TabIndex = 23;
this.label5.Text = "E-mail";
this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// CustomersManage
//
this.AutoScroll = true;
this.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(141)), ((System.Byte)(193)), ((System.Byte)(230)));
this.Controls.Add(this.panel2);
this.Controls.Add(this.panel1);
this.Name = "CustomersManage";
this.Size = new System.Drawing.Size(860, 493);
this.Load += new System.EventHandler(this.CustomersManage_Load);
((System.ComponentModel.ISupportInitialize)(this.panel2)).EndInit();
this.panel2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dgCustomer)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.panel1)).EndInit();
this.panel1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.cbSex.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtMemo.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtRelation.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtEmail.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtAddr.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtFax.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtCtelnumber.Properties)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.txtname.Properties)).EndInit();
this.ResumeLayout(false);
}
#endregion
private void btAdd_Click(object sender, System.EventArgs e)
{
try
{
insertData();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void insertData()
{
if(!this.validate())
{
return;
}
CustomerInfo cinfo=new CustomerInfo();
cinfo=setData("增加");
CustomerBLL cbll=new CustomerBLL();
if(cbll.addCustomer(cinfo).ToString()!=null)
{
MessageBox.Show(this,"添加成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
getDataBind();
ClearData();
}
else
{
MessageBox.Show(this,"添加失敗！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
}
private CustomerInfo setData(string tag)
{
CustomerInfo cinfo=new CustomerInfo();
if(tag=="修改")
{
cinfo.id=Convert.ToInt32(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,1]);
}
cinfo.cname=this.txtname.Text;
cinfo.csex=this.cbSex.Text.ToString();
cinfo.ctelnumber=this.txtCtelnumber.Text.ToString();
cinfo.ccontact=this.txtRelation.Text;
cinfo.ctype=Convert.ToInt32(this.cbCType.SelectedText);
cinfo.cfax=this.txtFax.Text;
cinfo.cemail=this.txtEmail.Text;
cinfo.caddress=this.txtAddr.Text;
cinfo.ccomment=this.txtMemo.Text;
return cinfo;
}
private void getDataBind()
{
this.dgCustomer.CaptionBackColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
this.dgCustomer.BackgroundColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
this.checkBox1.BackColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
this.checkBox1.Checked=false;
dscustomers=new DataSet();
CustomerBLL cbll=new CustomerBLL();
CustomerInfo cinfo=new CustomerInfo();
dscustomers=cbll.queryCustomer_DataSet(cinfo,"customers");
System.Type myDataType;
myDataType = System.Type.GetType("System.Boolean");
System.Data.DataColumn myColumn = new System.Data.DataColumn("check");
// Set various properties.
myColumn.AutoIncrement = false;
myColumn.ReadOnly = false;
myColumn.ColumnMapping = System.Data.MappingType.Attribute;
myColumn.Caption = "check";
myColumn.DefaultValue = "false";
myColumn.DataType = myDataType;
dscustomers.Tables["customers"].Columns.Add(myColumn);
DataView dv=new DataView();
dv=dscustomers.Tables["customers"].DefaultView;
dv.AllowNew=false;
this.dgCustomer.DataSource=dv;//dscustomers.Tables["customers"].DefaultView;
this.dgCustomer.TableStyles.Clear();
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = dscustomers.Tables["customers"].TableName;
ts.GridLineColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
ts.HeaderBackColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
DataGridColumnStyle gsc = new DataGridBoolColumn();
gsc.MappingName = "check";
gsc.HeaderText = "選擇";
gsc.Width=40;
ts.GridColumnStyles.Add(gsc);
DataGridColumnStyle gs0 = new DataGridTextBoxColumn();
gs0.MappingName = "id";
gs0.HeaderText = "編號";
gs0.Width=0;
gs0.ReadOnly=true;
ts.GridColumnStyles.Add(gs0);
DataGridColumnStyle gs1 = new DataGridTextBoxColumn();
gs1.MappingName = "cname";
gs1.HeaderText = "姓名";
gs1.NullText = "";
gs1.Width=60;
gs1.ReadOnly=true;
gs1.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs1);
DataGridColumnStyle gs2 = new DataGridTextBoxColumn();
gs2.MappingName = "csex";
gs2.HeaderText = "性別";
gs2.NullText = "";
gs2.Width=40;
gs2.ReadOnly=true;
gs2.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs2);
DataGridColumnStyle gsc2 = new DataGridTextBoxColumn();
gsc2.MappingName = "telnumber";
gsc2.HeaderText = "客戶來電";
gsc2.NullText = "";
gs2.Width=100;
gsc2.ReadOnly=true;
gsc2.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gsc2);
DataGridColumnStyle gst2 = new DataGridTextBoxColumn();
gst2.MappingName = "tname";
gst2.HeaderText = "類別";
gst2.NullText = "";
gst2.Width=100;
gst2.ReadOnly=true;
gst2.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gst2);
DataGridColumnStyle gs3 = new DataGridTextBoxColumn();
gs3.MappingName = "cemail";
gs3.HeaderText = "email";
gs3.NullText = "";
gs3.Width=200;
gs3.ReadOnly=true;
gs3.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs3);
DataGridColumnStyle gs4 = new DataGridTextBoxColumn();
gs4.MappingName = "cfax";
gs4.HeaderText = "傳真";
gs4.NullText = "";
gs4.Width=100;
gs4.ReadOnly=true;
gs4.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs4);
DataGridColumnStyle gs5 = new DataGridTextBoxColumn();
gs5.MappingName = "ccontact";
gs5.HeaderText = "聯(lián)系方式";
gs5.NullText = "";
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -