serviceprovidermanage.cs

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

			DataGridColumnStyle gs4 = new DataGridTextBoxColumn();
			gs4.MappingName = "stelephone";
			gs4.HeaderText = "联系电话";
			gs4.NullText = "";
			gs4.Width=100;
			gs4.ReadOnly=true;
			gs4.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs4);

			DataGridColumnStyle gs5 = new DataGridTextBoxColumn();
			gs5.MappingName = "sfax";
			gs5.HeaderText = "传真";
			gs5.NullText = "";
			gs5.Width=100;
			gs5.ReadOnly=true;
			gs5.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs5);

			DataGridColumnStyle gs6 = new DataGridTextBoxColumn();
			gs6.MappingName = "semail";
			gs6.HeaderText = "邮件地址";
			gs6.NullText = "";
			gs6.Width=100;
			gs6.ReadOnly=true;
			gs6.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs6);

			DataGridColumnStyle gs7 = new DataGridTextBoxColumn();
			gs7.MappingName = "sweb";
			gs7.HeaderText = "服务商网址";
			gs7.NullText = "";
			gs7.Width=100;
			gs7.ReadOnly=true;
			gs7.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs7);

			DataGridColumnStyle gs8 = new DataGridTextBoxColumn();
			gs8.MappingName = "ckeywords";
			gs8.HeaderText = "服务内容";
			gs8.NullText = "";
			gs8.Width=300;
			gs8.ReadOnly=true;
			gs8.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs8);

			DataGridColumnStyle gs9 = new DataGridTextBoxColumn();
			gs9.MappingName = "saddress";
			gs9.HeaderText = "公办地址";
			gs9.NullText = "";
			gs9.Width=200;
			gs9.ReadOnly=true;
			gs9.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs9);
			
			DataGridColumnStyle gs10 = new DataGridTextBoxColumn();
			gs10.MappingName = "position";
			gs10.HeaderText = "地理位置";
			gs10.NullText = "";
			gs10.Width=0;
			gs10.ReadOnly=true;
			ts.GridColumnStyles.Add(gs10);

			DataGridColumnStyle gs11 = new DataGridTextBoxColumn();
			gs11.MappingName = "sbrief";
			gs11.HeaderText = "服务商简介";
			gs11.NullText = "";
			gs11.Width=0;
			gs11.ReadOnly=true;
			ts.GridColumnStyles.Add(gs11);

			DataGridColumnStyle gs12 = new DataGridTextBoxColumn();
			gs12.MappingName = "sgood";
			gs12.HeaderText = "好评数";
			gs12.NullText = "";
			gs12.Width=40;
			gs12.ReadOnly=true;
			gs12.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs12);

			DataGridColumnStyle gs13 = new DataGridTextBoxColumn();
			gs13.MappingName = "sbad";
			gs13.HeaderText = "差评数";
			gs13.NullText = "";
			gs13.Width=40;
			gs13.ReadOnly=true;
			gs13.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs13);


			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.txtname.Text = "";
			this.txtTel.Text="";
			this.txtFax.Text="";
			this.txtAddr.Text="";
			this.txtMemo.Text="";
			this.cbSType.SelectedItem=0;
			this.txtRPerson.Text="";
			this.txtEmail.Text="";
			this.txtGood.Text="";
			this.dateTimePicker1.Text=DateTime.Today.ToString();
			this.txtWeb.Text="";
			this.txtNeiRong.Text="";
			this.txtBad.Text="";
			this.txtPosition.Text = "";
			getEnabled(false);
		}
		private void getEnabled(bool enabled)
		{
			if(enabled==true)
			{
				this.btSave.Enabled=true;
				this.btDelete.Enabled=true;
				this.btReset.Enabled=true;
				this.btService.Enabled=true;
			}
			else
			{
				this.btSave.Enabled=false;
				this.btDelete.Enabled=false;
				this.btReset.Enabled=false;
				this.btService.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 ;
			}
			ServiceProviderInfo sinfo=new ServiceProviderInfo();
			sinfo=setData("修改");
			ServiceProviderBLL sbll=new ServiceProviderBLL();
			if(sbll.updateServiceProvider(sinfo)<=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["service"].Select(strSel,"",System.Data.DataViewRowState.ModifiedCurrent);
					string strCheck = "";
					for(int i =0;i<rowArray.Length;i++)
					{				
						strCheck = strCheck+"," + rowArray[i]["id"];							
					}
					strCheck=strCheck.Substring(1,strCheck.Length - 1);


					ServiceProviderBLL sbll=new ServiceProviderBLL();
					if(sbll.delServiceProvider(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.txtname.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,2]);
				this.cbSType.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,3]);
				this.dateTimePicker1.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,4]);
				this.txtRPerson.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,5]);
				this.txtTel.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,6]);
				this.txtFax.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,7]);
				this.txtEmail.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,8]);
				this.txtWeb.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,9]);
				this.txtNeiRong.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,10]);
				this.txtAddr.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,11]);
				this.txtPosition.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,12]);
				this.txtMemo.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,13]);
				this.txtGood.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,14]);
				this.txtBad.Text=Convert.ToString(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,15]);
				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 void btService_Click(object sender, System.EventArgs e)
		{
			int id=Convert.ToInt32(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
			ServiceRecord sr=new ServiceRecord(id);
			sr.ShowDialog();
		}

		private bool checkValidate()
		{
			if("".Equals(this.txtname.Text.Trim()))
			{
				MessageBox.Show("服务商名称不能为空，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtname.Focus();
				return false;
			}
			if(this.txtname.Text.Length>30)
			{
				MessageBox.Show("服务商名称不能多于50个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtname.Focus();
				return false;
			}
			if(this.txtTel.Text.Length>30)
			{
				MessageBox.Show("联系电话不能多于30个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtTel.Focus();
				return false;
			}
			if(this.txtRPerson.Text.Length>30)
			{
				MessageBox.Show("联系人不能多于30个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtRPerson.Focus();
				return false;
			}
			if(this.txtWeb.Text.Length>30)
			{
				MessageBox.Show("服务商网址不能多于30个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtWeb.Focus();
				return false;
			}
			if(this.txtFax.Text.Length>30)
			{
				MessageBox.Show("传真号码不能多于30个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtFax.Focus();
				return false;
			}
			if(this.txtEmail.Text.Length>30)
			{
				MessageBox.Show("邮件地址不能多于30个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtEmail.Focus();
				return false;
			}
			if(this.txtNeiRong.Text.Length>30)
			{
				MessageBox.Show("服务内容不能多于100个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtNeiRong.Focus();
				return false;
			}
			if(ShareClass.isNubmic(this.txtPosition.Text,"地图位置")==1)
			{
				return false;
			}
			if(ShareClass.isNubmic(this.txtGood.Text,"好评数")==1)
			{
				return false;
			}
			if(ShareClass.isNubmic(this.txtBad.Text,"差评数")==1)
			{
				return false;
			}
			if(this.txtAddr.Text.Length>60)
			{
				MessageBox.Show("办公地址不能多于60个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtAddr.Focus();
				return false;
			}
			if(this.txtMemo.Text.Length>1000)
			{
				MessageBox.Show("服务商简介不能多于1000个字符，请重新输入！","",MessageBoxButtons.OK,MessageBoxIcon.Warning);
				this.txtMemo.Focus();
				return false;
			}
			return true;
		}

		private void txtWeb_EditValueChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txtNeiRong_EditValueChanged(object sender, System.EventArgs e)
		{
		
		}

		private void txtBad_EditValueChanged(object sender, System.EventArgs e)
		{
		
		}

		private void button1_Click(object sender, System.EventArgs e)
		{
			this.dateTimePicker1.Properties.Mask.EditMask = "d";
			this.dateTimePicker1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.DateTime;
			
			this.dateTimePicker1.Properties.DisplayFormat.FormatString = "d";
			this.dateTimePicker1.Properties.EditMask="d";
		}

	
	
	}
}