?? serviceprovidermanage.cs
字號:
DataGridColumnStyle gs4 = new DataGridTextBoxColumn();
gs4.MappingName = "stelephone";
gs4.HeaderText = "聯系電話";
gs4.NullText = "";
gs4.Width=100;
gs4.ReadOnly=true;
gs4.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs4);
DataGridColumnStyle gs5 = new DataGridTextBoxColumn();
gs5.MappingName = "sfax";
gs5.HeaderText = "傳真";
gs5.NullText = "";
gs5.Width=100;
gs5.ReadOnly=true;
gs5.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs5);
DataGridColumnStyle gs6 = new DataGridTextBoxColumn();
gs6.MappingName = "semail";
gs6.HeaderText = "郵件地址";
gs6.NullText = "";
gs6.Width=100;
gs6.ReadOnly=true;
gs6.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs6);
DataGridColumnStyle gs7 = new DataGridTextBoxColumn();
gs7.MappingName = "sweb";
gs7.HeaderText = "服務商網址";
gs7.NullText = "";
gs7.Width=100;
gs7.ReadOnly=true;
gs7.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs7);
DataGridColumnStyle gs8 = new DataGridTextBoxColumn();
gs8.MappingName = "ckeywords";
gs8.HeaderText = "服務內容";
gs8.NullText = "";
gs8.Width=300;
gs8.ReadOnly=true;
gs8.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs8);
DataGridColumnStyle gs9 = new DataGridTextBoxColumn();
gs9.MappingName = "saddress";
gs9.HeaderText = "公辦地址";
gs9.NullText = "";
gs9.Width=200;
gs9.ReadOnly=true;
gs9.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs9);
DataGridColumnStyle gs10 = new DataGridTextBoxColumn();
gs10.MappingName = "position";
gs10.HeaderText = "地理位置";
gs10.NullText = "";
gs10.Width=0;
gs10.ReadOnly=true;
ts.GridColumnStyles.Add(gs10);
DataGridColumnStyle gs11 = new DataGridTextBoxColumn();
gs11.MappingName = "sbrief";
gs11.HeaderText = "服務商簡介";
gs11.NullText = "";
gs11.Width=0;
gs11.ReadOnly=true;
ts.GridColumnStyles.Add(gs11);
DataGridColumnStyle gs12 = new DataGridTextBoxColumn();
gs12.MappingName = "sgood";
gs12.HeaderText = "好評數";
gs12.NullText = "";
gs12.Width=40;
gs12.ReadOnly=true;
gs12.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs12);
DataGridColumnStyle gs13 = new DataGridTextBoxColumn();
gs13.MappingName = "sbad";
gs13.HeaderText = "差評數";
gs13.NullText = "";
gs13.Width=40;
gs13.ReadOnly=true;
gs13.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs13);
this.dgPriver.TableStyles.Add(ts);
//如果指定了DataGridTableStyle，則gridDataFilter1會加載它的標題
this.gridDataFilter1.DataGridTableStyle = this.dgPriver.TableStyles[0];
if (this.dgPriver.DataSource != null)
{
this.gridDataFilter1.Enabled = true;
}
else
{
this.gridDataFilter1.Enabled = false;
}
this.gridDataFilter1.DataSource=this.dgPriver.DataSource;
this.gridDataFilter1.Begin();
}
private void ClearData()
{
this.txtname.Text = "";
this.txtTel.Text="";
this.txtFax.Text="";
this.txtAddr.Text="";
this.txtMemo.Text="";
this.cbSType.SelectedItem=0;
this.txtRPerson.Text="";
this.txtEmail.Text="";
this.txtGood.Text="";
this.dateTimePicker1.Text=DateTime.Today.ToString();
this.txtWeb.Text="";
this.txtNeiRong.Text="";
this.txtBad.Text="";
this.txtPosition.Text = "";
getEnabled(false);
}
private void getEnabled(bool enabled)
{
if(enabled==true)
{
this.btSave.Enabled=true;
this.btDelete.Enabled=true;
this.btReset.Enabled=true;
this.btService.Enabled=true;
}
else
{
this.btSave.Enabled=false;
this.btDelete.Enabled=false;
this.btReset.Enabled=false;
this.btService.Enabled=false;
}
}
private void btSave_Click(object sender, System.EventArgs e)
{
try
{
modifyData();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void modifyData()
{
if(!this.checkValidate())
{
return ;
}
ServiceProviderInfo sinfo=new ServiceProviderInfo();
sinfo=setData("修改");
ServiceProviderBLL sbll=new ServiceProviderBLL();
if(sbll.updateServiceProvider(sinfo)<=0)
{
MessageBox.Show("修改失敗！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("修改成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
getDataBind();
ClearData();
}
// cbll.updateCustomer(cinfo);
}
private void btDelete_Click(object sender, System.EventArgs e)
{
try
{
if(MessageBox.Show("確定要刪除此條記錄嗎？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.Yes)
{
string strSel = "check = true";
System.Data.DataRow[] rowArray =dsservice.Tables["service"].Select(strSel,"",System.Data.DataViewRowState.ModifiedCurrent);
string strCheck = "";
for(int i =0;i<rowArray.Length;i++)
{
strCheck = strCheck+"," + rowArray[i]["id"];
}
strCheck=strCheck.Substring(1,strCheck.Length - 1);
ServiceProviderBLL sbll=new ServiceProviderBLL();
if(sbll.delServiceProvider(strCheck)<=0)
{
MessageBox.Show("刪除失?。?quot;,"警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("刪除成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
getDataBind();
ClearData();
}
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void dgPriver_CurrentCellChanged(object sender, System.EventArgs e)
{
try
{
if(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1].ToString()=="")
{
throw new Exception("請選擇有效行");
}
if(this.dgPriver.CurrentCell.ColumnNumber==0)
{
if((bool)this.dgPriver[this.dgPriver.CurrentCell.RowNumber,0]==false)
{
this.dgPriver[this.dgPriver.CurrentCell.RowNumber,0]=true;
}
else
{
this.dgPriver[this.dgPriver.CurrentCell.RowNumber,0]=false;
}
}
this.dgPriver.Select(this.dgPriver.CurrentCell.RowNumber);
// this.dgPriver.ReadOnly=true;
this.txtname.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
this.cbSType.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
this.dateTimePicker1.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
this.txtRPerson.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
this.txtTel.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
this.txtFax.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
this.txtEmail.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);
this.txtWeb.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
this.txtNeiRong.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
this.txtAddr.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
this.txtPosition.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);
this.txtMemo.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,13]);
this.txtGood.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,14]);
this.txtBad.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,15]);
getEnabled(true);
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btReset_Click(object sender, System.EventArgs e)
{
ClearData();
}
private void btClose_Click(object sender, System.EventArgs e)
{
// this.Close();
}
private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
{
CurrencyManager cm = (CurrencyManager)dgPriver.BindingContext[dgPriver.DataSource,dgPriver.DataMember];
int icount=cm.List.Count;
// MessageBox.Show(icount.ToString());
if(this.checkBox1.Checked==true)
{
for(int dr=0;dr<icount;dr++)
{
dgPriver[dr,0]=true;
}
}
else
{
for(int dr=0;dr<icount;dr++)
{
dgPriver[dr,0]=false;
}
}
}
private void btService_Click(object sender, System.EventArgs e)
{
int id=Convert.ToInt32(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
ServiceRecord sr=new ServiceRecord(id);
sr.ShowDialog();
}
private bool checkValidate()
{
if("".Equals(this.txtname.Text.Trim()))
{
MessageBox.Show("服務商名稱不能為空，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtname.Focus();
return false;
}
if(this.txtname.Text.Length>30)
{
MessageBox.Show("服務商名稱不能多于50個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtname.Focus();
return false;
}
if(this.txtTel.Text.Length>30)
{
MessageBox.Show("聯系電話不能多于30個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtTel.Focus();
return false;
}
if(this.txtRPerson.Text.Length>30)
{
MessageBox.Show("聯系人不能多于30個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtRPerson.Focus();
return false;
}
if(this.txtWeb.Text.Length>30)
{
MessageBox.Show("服務商網址不能多于30個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtWeb.Focus();
return false;
}
if(this.txtFax.Text.Length>30)
{
MessageBox.Show("傳真號碼不能多于30個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtFax.Focus();
return false;
}
if(this.txtEmail.Text.Length>30)
{
MessageBox.Show("郵件地址不能多于30個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtEmail.Focus();
return false;
}
if(this.txtNeiRong.Text.Length>30)
{
MessageBox.Show("服務內容不能多于100個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtNeiRong.Focus();
return false;
}
if(ShareClass.isNubmic(this.txtPosition.Text,"地圖位置")==1)
{
return false;
}
if(ShareClass.isNubmic(this.txtGood.Text,"好評數")==1)
{
return false;
}
if(ShareClass.isNubmic(this.txtBad.Text,"差評數")==1)
{
return false;
}
if(this.txtAddr.Text.Length>60)
{
MessageBox.Show("辦公地址不能多于60個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtAddr.Focus();
return false;
}
if(this.txtMemo.Text.Length>1000)
{
MessageBox.Show("服務商簡介不能多于1000個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtMemo.Focus();
return false;
}
return true;
}
private void txtWeb_EditValueChanged(object sender, System.EventArgs e)
{
}
private void txtNeiRong_EditValueChanged(object sender, System.EventArgs e)
{
}
private void txtBad_EditValueChanged(object sender, System.EventArgs e)
{
}
private void button1_Click(object sender, System.EventArgs e)
{
this.dateTimePicker1.Properties.Mask.EditMask = "d";
this.dateTimePicker1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTime;
this.dateTimePicker1.Properties.DisplayFormat.FormatString = "d";
this.dateTimePicker1.Properties.EditMask="d";
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -