serviceprovidermanage.cs

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

			// txtAddr.Properties
			// 
			this.txtAddr.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtAddr.Size = new System.Drawing.Size(624, 21);
			this.txtAddr.TabIndex = 52;
			// 
			// txtPosition
			// 
			this.txtPosition.EditValue = "";
			this.txtPosition.Location = new System.Drawing.Point(96, 96);
			this.txtPosition.Name = "txtPosition";
			// 
			// txtPosition.Properties
			// 
			this.txtPosition.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtPosition.Size = new System.Drawing.Size(160, 21);
			this.txtPosition.TabIndex = 51;
			// 
			// txtFax
			// 
			this.txtFax.EditValue = "";
			this.txtFax.Location = new System.Drawing.Point(96, 72);
			this.txtFax.Name = "txtFax";
			// 
			// txtFax.Properties
			// 
			this.txtFax.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtFax.Size = new System.Drawing.Size(160, 21);
			this.txtFax.TabIndex = 50;
			// 
			// txtTel
			// 
			this.txtTel.EditValue = "";
			this.txtTel.Location = new System.Drawing.Point(96, 48);
			this.txtTel.Name = "txtTel";
			// 
			// txtTel.Properties
			// 
			this.txtTel.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtTel.Size = new System.Drawing.Size(160, 21);
			this.txtTel.TabIndex = 49;
			// 
			// txtname
			// 
			this.txtname.EditValue = "";
			this.txtname.Location = new System.Drawing.Point(96, 24);
			this.txtname.Name = "txtname";
			// 
			// txtname.Properties
			// 
			this.txtname.Properties.BorderStyle = DevExpress.XtraEditors.Controls.BorderStyles.Default;
			this.txtname.Size = new System.Drawing.Size(160, 21);
			this.txtname.TabIndex = 48;
			// 
			// label7
			// 
			this.label7.Font = new System.Drawing.Font("宋体", 9F);
			this.label7.Location = new System.Drawing.Point(267, 24);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(72, 23);
			this.label7.TabIndex = 40;
			this.label7.Text = "服务商类别";
			this.label7.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// cbSType
			// 
			this.cbSType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;
			this.cbSType.Location = new System.Drawing.Point(340, 24);
			this.cbSType.Name = "cbSType";
			this.cbSType.Size = new System.Drawing.Size(156, 20);
			this.cbSType.TabIndex = 1;
			// 
			// label10
			// 
			this.label10.Font = new System.Drawing.Font("宋体", 9F);
			this.label10.Location = new System.Drawing.Point(267, 48);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(69, 23);
			this.label10.TabIndex = 31;
			this.label10.Text = "联系人";
			this.label10.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label3
			// 
			this.label3.Font = new System.Drawing.Font("宋体", 9F);
			this.label3.Location = new System.Drawing.Point(27, 48);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(69, 23);
			this.label3.TabIndex = 24;
			this.label3.Text = "联系电话";
			this.label3.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label12
			// 
			this.label12.Font = new System.Drawing.Font("宋体", 9F);
			this.label12.Location = new System.Drawing.Point(27, 120);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(69, 23);
			this.label12.TabIndex = 41;
			this.label12.Text = "办公地址";
			this.label12.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label8
			// 
			this.label8.Font = new System.Drawing.Font("宋体", 9F);
			this.label8.Location = new System.Drawing.Point(27, 96);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(64, 23);
			this.label8.TabIndex = 43;
			this.label8.Text = "地图位置";
			this.label8.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label14
			// 
			this.label14.Font = new System.Drawing.Font("宋体", 9F);
			this.label14.Location = new System.Drawing.Point(507, 96);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(56, 23);
			this.label14.TabIndex = 47;
			this.label14.Text = "差评数";
			this.label14.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label13
			// 
			this.label13.Font = new System.Drawing.Font("宋体", 9F);
			this.label13.Location = new System.Drawing.Point(267, 96);
			this.label13.Name = "label13";
			this.label13.Size = new System.Drawing.Size(56, 23);
			this.label13.TabIndex = 44;
			this.label13.Text = "好评数";
			this.label13.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label6
			// 
			this.label6.Font = new System.Drawing.Font("宋体", 9F);
			this.label6.Location = new System.Drawing.Point(27, 72);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(88, 23);
			this.label6.TabIndex = 29;
			this.label6.Text = "传真号码";
			this.label6.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label4
			// 
			this.label4.Font = new System.Drawing.Font("宋体", 9F);
			this.label4.Location = new System.Drawing.Point(507, 48);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(72, 23);
			this.label4.TabIndex = 26;
			this.label4.Text = "服务商网址";
			this.label4.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label11
			// 
			this.label11.Font = new System.Drawing.Font("宋体", 9F);
			this.label11.Location = new System.Drawing.Point(507, 72);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(56, 23);
			this.label11.TabIndex = 38;
			this.label11.Text = "服务内容";
			this.label11.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label9
			// 
			this.label9.Font = new System.Drawing.Font("宋体", 9F);
			this.label9.Location = new System.Drawing.Point(507, 24);
			this.label9.Name = "label9";
			this.label9.Size = new System.Drawing.Size(56, 23);
			this.label9.TabIndex = 28;
			this.label9.Text = "加盟时间";
			this.label9.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 9F);
			this.label1.Location = new System.Drawing.Point(27, 152);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 23);
			this.label1.TabIndex = 25;
			this.label1.Text = "服务商简介";
			this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label5
			// 
			this.label5.Font = new System.Drawing.Font("宋体", 9F);
			this.label5.Location = new System.Drawing.Point(267, 72);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(88, 23);
			this.label5.TabIndex = 27;
			this.label5.Text = "邮件地址";
			this.label5.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// label2
			// 
			this.label2.Font = new System.Drawing.Font("宋体", 9F);
			this.label2.Location = new System.Drawing.Point(27, 24);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(88, 23);
			this.label2.TabIndex = 23;
			this.label2.Text = "服务商名称";
			this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
			// 
			// ServiceProviderManage
			// 
			this.AutoScroll = true;
			this.Controls.Add(this.panel2);
			this.Controls.Add(this.panel1);
			this.Name = "ServiceProviderManage";
			this.Size = new System.Drawing.Size(848, 549);
			this.Load += new System.EventHandler(this.ServiceProviderManage_Load);
			((System.ComponentModel.ISupportInitialize)(this.panel2)).EndInit();
			this.panel2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dgPriver)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.panel1)).EndInit();
			this.panel1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dateTimePicker1.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtBad.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtNeiRong.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtWeb.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtGood.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtEmail.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtRPerson.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtMemo.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtAddr.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtPosition.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtFax.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtTel.Properties)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.txtname.Properties)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void ServiceProviderManage_Load(object sender, System.EventArgs e)
		{
			ServiceProviderBLL sbll=new ServiceProviderBLL();
			DataSet ds=new DataSet();
			ds=sbll.getSPType_DataSet("stype");
			this.cbSType.DataSource=ds.Tables["stype"].DefaultView;
			this.cbSType.DisplayMember=ds.Tables["stype"].Columns["stname"].ToString();
			this.cbSType.ValueMember=ds.Tables["stype"].Columns["id"].ToString();
			this.gridDataFilter1.checkbox=this.checkBox1;

			ClearData();
			getDataBind();
			this.txtname.Focus();
		}

		private void btAdd_Click(object sender, System.EventArgs e)
		{
			try
			{
				insertData();
				
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
		}
		private void insertData()
		{
			if(!this.checkValidate())
			{
				return ;
			}
			ServiceProviderInfo sinfo=new ServiceProviderInfo();
			sinfo=setData("添加");
			if(sinfo==null)
			{
				return;
			}
			ServiceProviderBLL sbll=new ServiceProviderBLL();
			if(sbll.addServiceProvider(sinfo).ToString()!=null)
			{
				MessageBox.Show("添加成功","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
				getDataBind();
				ClearData();
			}
			else
			{
				MessageBox.Show("添加失败！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
			}
			
		}
		private ServiceProviderInfo setData(string tag)
		{
			ServiceProviderInfo sinfo=new ServiceProviderInfo();
			if(tag=="修改")
			{
				sinfo.id=Convert.ToInt32(this.dgPriver[this.dgPriver.CurrentCell.RowNumber,1]);
			}
			
			sinfo.sname=this.txtname.Text;
			sinfo.stelephone=this.txtTel.Text;
			sinfo.sfax=this.txtFax.Text;
			sinfo.saddress=this.txtAddr.Text;
			
			sinfo.position=Convert.ToInt32(this.txtPosition.Text==""?"0":this.txtPosition.Text);
			sinfo.sbrief=this.txtMemo.Text;
			sinfo.stype=Convert.ToInt32(this.cbSType.SelectedValue);
			sinfo.slinkname=this.txtRPerson.Text;
			sinfo.semail=this.txtEmail.Text;
			
			sinfo.sgood=Convert.ToInt32(this.txtGood.Text==""?"0":this.txtGood.Text);
			sinfo.sdate=this.dateTimePicker1.Text.ToString();
			sinfo.sweb=this.txtWeb.Text;
			sinfo.ckeywords=this.txtNeiRong.Text;
			sinfo.sbad=Convert.ToInt32(this.txtBad.Text==""?"0":this.txtBad.Text);
			
			return sinfo;
		}
		private void getDataBind()
		{	
			this.dgPriver.CaptionBackColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
			this.dgPriver.BackgroundColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
			this.checkBox1.BackColor=Color.FromArgb(ShareClass.Rcolor,ShareClass.Gcolor,ShareClass.Bcolor);
			
			dsservice=new DataSet();
			ServiceProviderBLL sbll=new ServiceProviderBLL();
			ServiceProviderInfo sinfo=new ServiceProviderInfo();
			dsservice=sbll.queryServiceProvider_DataSet(sinfo,"service");


			System.Type myDataType;
			myDataType = System.Type.GetType("System.Boolean");
			System.Data.DataColumn myColumn = new System.Data.DataColumn("check");
			// Set various properties.
			myColumn.AutoIncrement = false;
			myColumn.ReadOnly = false;
			myColumn.ColumnMapping = System.Data.MappingType.Attribute;
			myColumn.Caption = "check";
			myColumn.DefaultValue = "false";
			myColumn.DataType = myDataType;
			
			
			

			dsservice.Tables["service"].Columns.Add(myColumn);

			DataView dv=new DataView();
			dv=dsservice.Tables["service"].DefaultView;
			dv.AllowNew=false;
			

			this.dgPriver.DataSource=dv;//dsservice.Tables["service"].DefaultView;
			
		
			this.dgPriver.TableStyles.Clear();
			DataGridTableStyle ts = new DataGridTableStyle();
			ts.MappingName = dsservice.Tables["service"].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 = "id";
			gs0.HeaderText = "编号";
			gs0.Width=40;
			gs0.ReadOnly=true;
			gs0.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs0);
			

			DataGridColumnStyle gs1 = new DataGridTextBoxColumn();
			gs1.MappingName = "sname";
			gs1.HeaderText = "服务商名称";
			gs1.NullText = "";
			gs1.Width=200;
			gs1.ReadOnly=true;
			gs1.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs1);

			DataGridColumnStyle gs2 = new DataGridTextBoxColumn();
			gs2.MappingName = "stname";
			gs2.HeaderText = "服务商类别";
			gs2.NullText = "";
			gs2.Width=100;
			gs2.ReadOnly=true;
			gs2.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs2);

			DataGridColumnStyle gst2 = new DataGridTextBoxColumn();
			gst2.MappingName = "sdate";
			gst2.HeaderText = "加盟时间";
			gst2.NullText = "";
			gst2.Width=80;
			gst2.ReadOnly=true;
			gst2.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gst2);

			DataGridColumnStyle gs3 = new DataGridTextBoxColumn();
			gs3.MappingName = "slinkname";
			gs3.HeaderText = "联系人";
			gs3.NullText = "";
			gs3.Width=80;
			gs3.ReadOnly=true;
			gs3.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs3);