customersmanage.cs

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

			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,"联系方式不能多于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)
		{
		
		}
	}
}