frmgrxxselect.cs

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

			ts.GridColumnStyles.Add(gs12);

			DataGridColumnStyle gs13 = new DataGridTextBoxColumn();
			gs13.MappingName = "dzyx";
			gs13.HeaderText = "电子邮箱";
			gs13.NullText = "";
			gs13.Width=100;
			gs13.ReadOnly=true;
			gs13.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs13);

			DataGridColumnStyle gs14 = new DataGridTextBoxColumn();
			gs14.MappingName = "yyah";
			gs14.HeaderText = "业余爱好";
			gs14.NullText = "";
			gs14.Width=100;
			gs14.ReadOnly=true;
			gs14.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs14);

			DataGridColumnStyle gs15 = new DataGridTextBoxColumn();
			gs15.MappingName = "zy";
			gs15.HeaderText = "职业";
			gs15.NullText = "";
			gs15.Width=100;
			gs15.ReadOnly=true;
			gs15.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs15);

			DataGridColumnStyle gs16 = new DataGridTextBoxColumn();
			gs16.MappingName = "zw";
			gs16.HeaderText = "职务";
			gs16.NullText = "";
			gs16.Width=100;
			gs16.ReadOnly=true;
			gs16.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs16);

			DataGridColumnStyle gs17 = new DataGridTextBoxColumn();
			gs17.MappingName = "ysr";
			gs17.HeaderText = "月收入";
			gs17.NullText = "";
			gs17.Width=300;
			gs17.ReadOnly=true;
			gs17.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs17);

			DataGridColumnStyle gs18 = new DataGridTextBoxColumn();
			gs18.MappingName = "tsjnrq";
			gs18.HeaderText = "特殊纪念日";
			gs18.NullText = "";
			gs18.Width=100;
			gs18.ReadOnly=true;
			gs18.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs18);

			DataGridColumnStyle gs19 = new DataGridTextBoxColumn();
			gs19.MappingName = "tsjnnr";
			gs19.HeaderText = "特殊纪念内容";
			gs19.NullText = "";
			gs19.Width=200;
			gs19.ReadOnly=true;
			gs19.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs19);


			DataGridColumnStyle gs20 = new DataGridTextBoxColumn();
			gs20.MappingName = "bz";
			gs20.HeaderText = "备注";
			gs20.NullText = "";
			gs20.Width=200;
			gs20.ReadOnly=true;
			gs20.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs20);

			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.txtkhxm.Text="";
			this.txtsfzh.Text="";
			this.txtkhly.Text="";
			this.cbxb.SelectedIndex=0;
			this.txtnl.Text="";
			this.txtkhsd.Text="";
			this.txtwhcd.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.txtyyah.Text="";
			this.txtzy.Text="";
			this.txtzw.Text="";
			this.txtysr.Text="";
			this.dttsjnrq.Text=DateTime.Today.ToString();
			this.txttsjnnr.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 ;
			}
			GrxxInfo cinfo=new GrxxInfo();
			cinfo=setData("修改");
			GrxxBLL cbll=new GrxxBLL();
			int i=cbll.updateGrxx(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["grxx"].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);


					GrxxBLL cbll=new GrxxBLL();
					if(cbll.delGrxx(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.txtkhxm.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
				this.txtsfzh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
				this.txtkhly.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
				this.cbxb.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
				this.txtnl.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
				this.txtkhsd.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
				this.txtwhcd.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
				this.txtsf.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);

				this.txtcs.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
				this.txtyzbm.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
				this.txtxxdz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
				this.txtqh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);

				this.txtdh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,13]);
				this.txtyddh.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,14]);
				this.txtcz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,15]);
				this.txtdzyx.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,16]);

				this.txtyyah.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,17]);
				this.txtzy.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,18]);
				this.txtzw.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,19]);
				this.txtysr.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,20]);

				this.dttsjnrq.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,21]);
				this.txttsjnnr.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,22]);
				this.txtbz.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,23]);
		
				
				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.txtkhxm.Text.Trim()))
			{
				MessageBox.Show("客户名称不能为空，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtkhxm.Focus();
				return false;
			}
			if("".Equals(this.txtsfzh.Text.Trim()))
			{
				MessageBox.Show("身份证号不能为空，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtsfzh.Focus();
				return false;
			}
			if(this.txtkhxm.Text.Length>50)
			{
				MessageBox.Show("客户名称不能多于50个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtkhxm.Focus();
				return false;
			}
			if(ShareClass.isNubmic(this.txtnl.Text,"年龄")==1)
			{
				return false;
			}
			//			if(ShareClass.isNubmic(this.txtysr.Text,"月收入")==1)
			//			{
			//				return false;
			//			}
			
			return true;
		}

		private void simpleButton1_Click(object sender, System.EventArgs e)
		{
			grxx=new GrxxInfo();
			grxx.id=Convert.ToInt32(this.dsservice.Tables["grxx"].Rows[this.dgPriver.CurrentCell.RowNumber]["id"]);
			grxx.khxm=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
			grxx.sfzh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
			grxx.khly=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
			grxx.xb=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
			grxx.nl=Convert.ToInt32(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
			grxx.khsd=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
			grxx.whcd=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
			grxx.sf=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);

			grxx.cs=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
			grxx.yzbm=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
			grxx.xxdz=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
			grxx.qh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);

			grxx.dh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,13]);
			grxx.yddh=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,14]);
			grxx.cz=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,15]);
			grxx.dzyx=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,16]);

			grxx.yyah=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,17]);
			grxx.zy=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,18]);
			grxx.zw=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,19]);
			grxx.ysr=Convert.ToDecimal(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,20]);

			grxx.tsjnrq=Convert.ToDateTime(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,21]);
			grxx.tsjnnr=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,22]);
			grxx.bz=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,23]);
			this.Close();
		}		
		public GrxxInfo getGrxx()
		{
			return grxx;
		}

		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;
		}
	
	}
}