frmcarkuselect.cs

c#编写的汽车销售公司erp进销存系统

			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"];							
					}
					if(strCheck==""||strCheck==null)
					{
						MessageBox.Show("请选择要删除的记录！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
						return;
					}
					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)
		{
			carku=new CarkuInfo();
			carku.ccbh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
			carku.state=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
			if(carku.state=="已售" && state=="")
			{
				MessageBox.Show("此车已售，请重新选择！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				return;
				
			}
			carku.ys=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
			carku.pp=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
			carku.clxz=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
			carku.ggxh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
			carku.fdjxh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
			carku.fdjhm=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);

			carku.xxrq=Convert.ToDateTime(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
			carku.scdw=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
			carku.rkrq=Convert.ToDateTime(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
			carku.bz=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);
			this.Close();
		}	
		public CarkuInfo getCarkuInfo()
		{
			return carku;
		}

		private void simpleButton2_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;
		}
	
	}
}