?? customersmanage.cs
字號:
gs5.Width=200;
gs5.ReadOnly=true;
gs5.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs5);
DataGridColumnStyle gs6 = new DataGridTextBoxColumn();
gs6.MappingName = "caddress";
gs6.HeaderText = "客戶地址";
gs6.NullText = "";
gs6.Width=200;
gs6.ReadOnly=true;
gs6.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs6);
DataGridColumnStyle gs7 = new DataGridTextBoxColumn();
gs7.MappingName = "ccomment";
gs7.HeaderText = "客戶備注";
gs7.NullText = "";
gs7.Width=0;
gs7.ReadOnly=true;
gs7.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs7);
this.dgCustomer.TableStyles.Add(ts);
//如果指定了DataGridTableStyle，則gridDataFilter1會加載它的標題
this.gridDataFilter1.DataGridTableStyle = this.dgCustomer.TableStyles[0];
if (this.dgCustomer.DataSource != null)
{
this.gridDataFilter1.Enabled = true;
}
else
{
this.gridDataFilter1.Enabled = false;
}
this.gridDataFilter1.DataSource=this.dgCustomer.DataSource;
this.gridDataFilter1.Begin();
}
private void ClearData()
{
this.txtname.Text="";
this.cbSex.SelectedIndex=0;
this.txtCtelnumber.Text="";
this.txtRelation.Text="";
this.cbCType.SelectedIndex=0;
this.txtFax.Text="";
this.txtEmail.Text="";
this.txtAddr.Text="";
this.txtMemo.Text="";
getEnabled(false);
}
private void getEnabled(bool enabled)
{
if(enabled==true)
{
this.btSave.Enabled=true;
this.btDelete.Enabled=true;
this.btReset.Enabled=true;
}
else
{
this.btSave.Enabled=false;
this.btDelete.Enabled=false;
this.btReset.Enabled=false;
}
}
private void CustomersManage_Load(object sender, System.EventArgs e)
{
CustomerBLL cbll=new CustomerBLL();
DataSet ds=new DataSet();
ds=cbll.getCustomerType_DataSet("custtype");
this.cbCType.DataSource=ds.Tables["custtype"].DefaultView;
this.cbCType.DisplayMember=ds.Tables["custtype"].Columns["tname"].ColumnName.ToString();
this.cbCType.ValueMember=ds.Tables["custtype"].Columns["id"].ColumnName.ToString();
// this.cbCType.Properties.DataSource=ds.Tables["custtype"].DefaultView;
// this.cbCType.Properties.DisplayMember=ds.Tables["custtype"].Columns["tname"].ColumnName.ToString();
// this.cbCType.Properties.ValueMember=ds.Tables["custtype"].Columns["id"].ColumnName.ToString();
this.gridDataFilter1.checkbox=this.checkBox1;
ClearData();
getDataBind();
this.txtname.Focus();
}
private void btSave_Click(object sender, System.EventArgs e)
{
try
{
modifyData();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void modifyData()
{
if(!this.validate())
{
return;
}
CustomerInfo cinfo=new CustomerInfo();
cinfo=setData("修改");
CustomerBLL cbll=new CustomerBLL();
if(cbll.updateCustomer(cinfo)<=0)
{
MessageBox.Show(this,"修改失敗！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else
{
MessageBox.Show(this,"修改成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
getDataBind();
ClearData();
}
// cbll.updateCustomer(cinfo);
}
private void btDelete_Click(object sender, System.EventArgs e)
{
try
{
string strSel = "check = true";
System.Data.DataRow[] rowArray =dscustomers.Tables["customers"].Select(strSel,"",System.Data.DataViewRowState.ModifiedCurrent);
string strCheck = "";
for(int i =0;i<rowArray.Length;i++)
{
strCheck = strCheck+"," + rowArray[i]["id"];
}
if("".Equals(strCheck))
{
MessageBox.Show("請選擇要刪除的客戶信息！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return ;
}
if(MessageBox.Show("確定要刪除此條記錄嗎？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.Yes)
{
strCheck=strCheck.Substring(1,strCheck.Length - 1);
CustomerBLL cbll=new CustomerBLL();
if(cbll.delCustomer(strCheck)<=0)
{
MessageBox.Show(this,"刪除失敗！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else
{
MessageBox.Show(this,"刪除成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
getDataBind();
ClearData();
}
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private bool validate()
{
if("".Equals(this.txtname.Text.Trim()))
{
MessageBox.Show(this,"請輸入客戶姓名！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtname.Focus();
return false;
}
if(this.txtname.Text.Trim().Length>30)
{
MessageBox.Show(this,"客戶姓名不能多于30個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtname.Focus();
return false;
}
if(this.txtCtelnumber.Text.Trim().Length>20)
{
MessageBox.Show(this,"客戶來電不能多于20個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtCtelnumber.Focus();
return false;
}
if(this.txtFax.Text.Trim().Length>20)
{
MessageBox.Show(this,"客戶傳真不能多于20個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtFax.Focus();
return false;
}
if(this.txtEmail.Text.Trim().Length>30)
{
MessageBox.Show(this,"客戶Email不能多于30個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtEmail.Focus();
return false;
}
if(this.txtAddr.Text.Trim().Length>100)
{
MessageBox.Show(this,"客戶地址不能多于100個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtAddr.Focus();
return false;
}
if(this.txtRelation.Text.Trim().Length>100)
{
MessageBox.Show(this,"聯(lián)系方式不能多于50個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtRelation.Focus();
return false;
}
if(this.txtMemo.Text.Trim().Length>100)
{
MessageBox.Show(this,"備注信息不能多于500個字符，請重新輸入！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtMemo.Focus();
return false;
}
return true;
}
private void btReset_Click(object sender, System.EventArgs e)
{
ClearData();
}
private void dgCustomer_CurrentCellChanged(object sender, System.EventArgs e)
{
try
{
if(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,1].ToString()=="")
{
throw new Exception("請選擇有效行");
}
if(this.dgCustomer.CurrentCell.ColumnNumber==0)
{
if((bool)this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,0]==false)
{
this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,0]=true;
}
else
{
this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,0]=false;
}
}
this.dgCustomer.Select(this.dgCustomer.CurrentCell.RowNumber);
// this.dgCustomer.ReadOnly=true;
this.txtname.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,2]);
this.cbSex.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,3]);
this.txtCtelnumber.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,4]);
this.cbCType.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,5]);
this.txtEmail.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,6]);
this.txtFax.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,7]);
this.txtRelation.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,8]);
this.txtAddr.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,9]);
this.txtMemo.Text=Convert.ToString(this.dgCustomer[this.dgCustomer.CurrentCell.RowNumber,10]);
getEnabled(true);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
{
CurrencyManager cm = (CurrencyManager)dgCustomer.BindingContext[dgCustomer.DataSource,dgCustomer.DataMember];
int icount=cm.List.Count;
// MessageBox.Show(icount.ToString());
if(this.checkBox1.Checked==true)
{
for(int dr=0;dr<icount;dr++)
{
dgCustomer[dr,0]=true;
}
}
else
{
for(int dr=0;dr<icount;dr++)
{
dgCustomer[dr,0]=false;
}
}
}
private void txtEmail_TextChanged(object sender, System.EventArgs e)
{
}
private void cbSex_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void cbCType_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void txtRelation_EditValueChanged(object sender, System.EventArgs e)
{
}
private void txtEmail_EditValueChanged(object sender, System.EventArgs e)
{
}
private void cbCType_SelectedIndexChanged_1(object sender, System.EventArgs e)
{
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -