?? carkumanage.cs
字號:
this.dgPriver.TableStyles.Clear();
DataGridTableStyle ts = new DataGridTableStyle();
ts.MappingName = dsservice.Tables["carku"].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 = "ccbh";
gs0.HeaderText = "出廠編號";
gs0.Width=80;
gs0.ReadOnly=true;
gs0.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs0);
DataGridColumnStyle gs00 = new DataGridTextBoxColumn();
gs00.MappingName = "state";
gs00.HeaderText = "銷售狀態";
gs00.NullText = "";
gs00.Width=80;
gs00.ReadOnly=true;
gs00.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs00);
DataGridColumnStyle gs1 = new DataGridTextBoxColumn();
gs1.MappingName = "ys";
gs1.HeaderText = "車輛顏色";
gs1.NullText = "";
gs1.Width=200;
gs1.ReadOnly=true;
gs1.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs1);
DataGridColumnStyle gs2 = new DataGridTextBoxColumn();
gs2.MappingName = "pp";
gs2.HeaderText = "車輛品牌";
gs2.NullText = "";
gs2.Width=100;
gs2.ReadOnly=true;
gs2.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs2);
DataGridColumnStyle gst2 = new DataGridTextBoxColumn();
gst2.MappingName = "clxz";
gst2.HeaderText = "車輛性質";
gst2.NullText = "";
gst2.Width=80;
gst2.ReadOnly=true;
gst2.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gst2);
DataGridColumnStyle gs3 = new DataGridTextBoxColumn();
gs3.MappingName = "ggxh";
gs3.HeaderText = "公告型號";
gs3.NullText = "";
gs3.Width=80;
gs3.ReadOnly=true;
gs3.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs3);
DataGridColumnStyle gs4 = new DataGridTextBoxColumn();
gs4.MappingName = "fdjxh";
gs4.HeaderText = "發動機型號";
gs4.NullText = "";
gs4.Width=100;
gs4.ReadOnly=true;
gs4.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs4);
DataGridColumnStyle gs5 = new DataGridTextBoxColumn();
gs5.MappingName = "fdjhm";
gs5.HeaderText = "發動機號碼";
gs5.NullText = "";
gs5.Width=100;
gs5.ReadOnly=true;
gs5.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs5);
DataGridColumnStyle gs6 = new DataGridTextBoxColumn();
gs6.MappingName = "xxrq";
gs6.HeaderText = "下線日期";
gs6.NullText = "";
gs6.Width=100;
gs6.ReadOnly=true;
gs6.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs6);
DataGridColumnStyle gs7 = new DataGridTextBoxColumn();
gs7.MappingName = "scdw";
gs7.HeaderText = "生產單位";
gs7.NullText = "";
gs7.Width=100;
gs7.ReadOnly=true;
gs7.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs7);
DataGridColumnStyle gs8 = new DataGridTextBoxColumn();
gs8.MappingName = "rkrq";
gs8.HeaderText = "入庫日期";
gs8.NullText = "";
gs8.Width=300;
gs8.ReadOnly=true;
gs8.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs8);
DataGridColumnStyle gs9 = new DataGridTextBoxColumn();
gs9.MappingName = "bz";
gs9.HeaderText = "備注";
gs9.NullText = "";
gs9.Width=200;
gs9.ReadOnly=true;
gs9.Alignment = HorizontalAlignment.Left;
ts.GridColumnStyles.Add(gs9);
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.txtccbh.Text = "";
this.cbstate.SelectedIndex=0;
this.cbys.SelectedIndex=0;
this.cbpp.SelectedIndex=0;
this.cbclxz.SelectedIndex=0;
this.txtggxh.Text="";
this.txtfdjxh.Text="";
this.txtfdjhm.Text="";
this.dtxxrq.Text=DateTime.Today.ToString();
this.dtrkrq.Text=DateTime.Today.ToString();
this.cbscdw.SelectedIndex=0;
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 ;
}
CarkuInfo cinfo=new CarkuInfo();
cinfo=setData("修改");
if(cinfo==null)
{
MessageBox.Show("不允許修改出廠編號！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
return;
}
CarkuBLL cbll=new CarkuBLL();
if(cbll.updateCarku(cinfo)<=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["carku"].Select(strSel,"",System.Data.DataViewRowState.ModifiedCurrent);
string strCheck = "";
for(int i =0;i<rowArray.Length;i++)
{
strCheck = strCheck+"," + rowArray[i]["ccbh"];
}
strCheck=strCheck.Substring(1,strCheck.Length - 1);
CarkuBLL cbll=new CarkuBLL();
if(cbll.delCarku(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.txtccbh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
this.cbstate.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
this.cbys.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
this.cbpp.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
this.cbclxz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
this.txtggxh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
this.txtfdjxh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
this.txtfdjhm.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);
this.dtxxrq.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
this.cbscdw.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
this.dtrkrq.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
this.txtbz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);
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.txtccbh.Text.Trim()))
{
MessageBox.Show("出廠編號不能為空，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtccbh.Focus();
return false;
}
if(this.txtccbh.Text.Length>30)
{
MessageBox.Show("出廠編號不能多于50個字符，請重新輸入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
this.txtccbh.Focus();
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;
}
private void gridDataFilter1_Enter(object sender, System.EventArgs e)
{
CurrencyManager cm = (CurrencyManager)dgPriver.BindingContext[dgPriver.DataSource,dgPriver.DataMember];
int icount=cm.List.Count;
this.label14.Text=icount.ToString();
}
private void dgPriver_MouseLeave(object sender, System.EventArgs e)
{
CurrencyManager cm = (CurrencyManager)dgPriver.BindingContext[dgPriver.DataSource,dgPriver.DataMember];
int icount=cm.List.Count;
this.label14.Text=icount.ToString();
}
private void gridDataFilter1_MouseMove(object sender, System.Windows.Forms.MouseEventArgs e)
{
CurrencyManager cm = (CurrencyManager)dgPriver.BindingContext[dgPriver.DataSource,dgPriver.DataMember];
int icount=cm.List.Count;
this.label14.Text=icount.ToString();
}
private void simpleButton2_Click(object sender, System.EventArgs e)
{
CarkuBLL cbll=new CarkuBLL();
MessageBox.Show("已售車："+cbll.getCount("已售").ToString()+"輛，未售車："+cbll.getCount("未售").ToString()+"輛，合計："+Convert.ToString(cbll.getCount("已售")+cbll.getCount("未售"))+"輛","統計",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -