?? dwxxmanage.cs
字號:
DataGridColumnStyle gs11 = new DataGridTextBoxColumn();
gs11.MappingName = "dwrs";
gs11.HeaderText = "單位人數(shù)";
gs11.NullText = "";
gs11.Width=100;
gs11.ReadOnly=true;
gs11.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs11);
DataGridColumnStyle gs12 = new DataGridTextBoxColumn();
gs12.MappingName = "dwnsr";
gs12.HeaderText = "單位年收入（萬）";
gs12.NullText = "";
gs12.Width=100;
gs12.ReadOnly=true;
gs12.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs12);
DataGridColumnStyle gs13 = new DataGridTextBoxColumn();
gs13.MappingName = "dwzc";
gs13.HeaderText = "單位資產(chǎn)（萬）";
gs13.NullText = "";
gs13.Width=100;
gs13.ReadOnly=true;
gs13.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs13);
DataGridColumnStyle gs14 = new DataGridTextBoxColumn();
gs14.MappingName = "dwlxr";
gs14.HeaderText = "單位聯(lián)系人";
gs14.NullText = "";
gs14.Width=100;
gs14.ReadOnly=true;
gs14.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs14);
DataGridColumnStyle gs15 = new DataGridTextBoxColumn();
gs15.MappingName = "xb";
gs15.HeaderText = "性別";
gs15.NullText = "";
gs15.Width=100;
gs15.ReadOnly=true;
gs15.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs15);
DataGridColumnStyle gs16 = new DataGridTextBoxColumn();
gs16.MappingName = "nl";
gs16.HeaderText = "年齡";
gs16.NullText = "";
gs16.Width=100;
gs16.ReadOnly=true;
gs16.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs16);
DataGridColumnStyle gs17 = new DataGridTextBoxColumn();
gs17.MappingName = "zy";
gs17.HeaderText = "職業(yè)";
gs17.NullText = "";
gs17.Width=100;
gs17.ReadOnly=true;
gs17.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs17);
DataGridColumnStyle gs18 = new DataGridTextBoxColumn();
gs18.MappingName = "zw";
gs18.HeaderText = "職務(wù)";
gs18.NullText = "";
gs18.Width=100;
gs18.ReadOnly=true;
gs18.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs18);
DataGridColumnStyle gs19 = new DataGridTextBoxColumn();
gs19.MappingName = "whcd";
gs19.HeaderText = "文化程度";
gs19.NullText = "";
gs19.Width=200;
gs19.ReadOnly=true;
gs19.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs19);
DataGridColumnStyle gs20 = new DataGridTextBoxColumn();
gs20.MappingName = "yyah";
gs20.HeaderText = "業(yè)余愛好";
gs20.NullText = "";
gs20.Width=100;
gs20.ReadOnly=true;
gs20.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs20);
DataGridColumnStyle gs21 = new DataGridTextBoxColumn();
gs21.MappingName = "bz";
gs21.HeaderText = "備注";
gs21.NullText = "";
gs21.Width=200;
gs21.ReadOnly=true;
gs21.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs21);
this.dgPriver.TableStyles.Add(ts);
//如果指定了DataGridTableStyle，則gridDataFilter1會加載它的標(biāo)題
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.txtdwmc.Text="";
this.txtdwbm.Text="";
this.txtdwxz.Text="";
this.txtkhly.Text="";
this.txtsf.Text="";
this.txtcs.Text="";
this.txtyzbm.Text="";
this.txtxxdz.Text="";
this.txtqh.Text="";
this.txtdh.Text="";
this.txtyddh.Text="";
this.txtcz.Text="";
this.txtdzyx.Text="";
this.txtdwrs.Text="";
this.txtdwnsr.Text="";
this.txtdwzc.Text="";
this.txtdwlxr.Text="";
this.cbxb.SelectedIndex=0;
this.txtnl.Text="";
this.txtzy.Text="";
this.txtzw.Text="";
this.txtwhcd.Text="";
this.txtyyah.Text="";
this.txtbz.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 btSave_Click(object sender, System.EventArgs e)
{
try
{
modifyData();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void modifyData()
{
if(!this.checkValidate())
{
return ;
}
DwxxInfo cinfo=new DwxxInfo();
cinfo=setData("修改");
DwxxBLL cbll=new DwxxBLL();
int i=cbll.updateDwxx(cinfo);
if(i==0)
{
MessageBox.Show("修改失敗！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
else if(i==-1)
{
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["dwxx"].Select(strSel,"",System.Data.DataViewRowState.ModifiedCurrent);
string strCheck = "";
for(int i =0;i<rowArray.Length;i++)
{
strCheck = strCheck+"," + rowArray[i]["id"];
}
if(strCheck==""||strCheck==null)
{
MessageBox.Show("請選擇要刪除的記錄！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
strCheck=strCheck.Substring(1,strCheck.Length - 1);
DwxxBLL cbll=new DwxxBLL();
if(cbll.delDwxx(strCheck)<=0)
{
MessageBox.Show("刪除失敗！","警告",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.txtdwmc.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
this.txtdwbm.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
this.txtdwxz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
this.txtkhly.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
this.txtsf.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
this.txtcs.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
this.txtyzbm.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
this.txtxxdz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);
this.txtqh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
this.txtdh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
this.txtyddh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
this.txtcz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);
this.txtdzyx.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,13]);
this.txtdwrs.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,14]);
this.txtdwnsr.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,15]);
this.txtdwzc.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,16]);
this.txtdwlxr.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,17]);
this.cbxb.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,18]);
this.txtnl.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,19]);
this.txtzy.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,20]);
this.txtzw.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,21]);
this.txtwhcd.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,22]);
this.txtyyah.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,23]);
this.txtbz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,24]);
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 bool checkValidate()
{
if("".Equals(this.txtdwmc.Text.Trim()))
{
MessageBox.Show("單位名稱不能為空，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtdwmc.Focus();
return false;
}
if("".Equals(this.txtdwbm.Text.Trim()))
{
MessageBox.Show("單位編碼不能為空，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtdwbm.Focus();
return false;
}
if(this.txtdwmc.Text.Length>50)
{
MessageBox.Show("客戶名稱不能多于50個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtdwmc.Focus();
return false;
}
if(ShareClass.isNubmic(this.txtnl.Text,"年齡")==1)
{
return false;
}
if(ShareClass.isNubmic(this.txtdwrs.Text,"單位人數(shù)")==1)
{
return false;
}
// if(ShareClass.isNubmic(this.txtysr.Text,"月收入")==1)
// {
// return false;
// }
return true;
}
private void simpleButton1_Click(object sender, System.EventArgs e)
{
Cursor currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
printLink.DataGrid = this.dgPriver;
printLink.CreateDocument(ps);
ps.PreviewForm.Text = this.dgPriver.CaptionText;
// ps.PreviewForm.Owner = this;
ps.PreviewForm.Show();
Cursor.Current = currentCursor;
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -