workmanage.cs

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

			ts.GridColumnStyles.Add(gs10);

			DataGridColumnStyle gst2 = new DataGridTextBoxColumn();
			gst2.MappingName = "ctelnumber";
			gst2.HeaderText = "客户来电号码";
			gst2.NullText = "";
			gst2.Width=200;
			gst2.ReadOnly=true;
			gst2.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gst2);

			DataGridColumnStyle gs3 = new DataGridTextBoxColumn();
			gs3.MappingName = "brief";
			gs3.HeaderText = "服务内容简介";
			gs3.NullText = "";
			gs3.Width=400;
			gs3.ReadOnly=true;
			gs3.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs3);

			DataGridColumnStyle gs4 = new DataGridTextBoxColumn();
			gs4.MappingName = "ndate";
			gs4.HeaderText = "工单生成时间";
			gs4.NullText = "";
			gs4.Width=200;
			gs4.ReadOnly=true;
			gs4.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs4);

			//			DataGridColumnStyle gs5 = new DataGridTextBoxColumn();
			//			gs5.MappingName = "sid";
			//			gs5.HeaderText = "操作员编号";
			//			gs5.NullText = "";
			//			gs5.Width=80;
			//			gs5.ReadOnly=true;
			//			ts.GridColumnStyles.Add(gs5);

			DataGridColumnStyle gs6 = new DataGridTextBoxColumn();
			gs6.MappingName = "sname";
			gs6.HeaderText = "操作员姓名";
			gs6.NullText = "";
			gs6.Width=100;
			gs6.ReadOnly=true;
			gs6.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs6);

			DataGridColumnStyle gs7 = new DataGridTextBoxColumn();
			gs7.MappingName = "wbstate";
			gs7.HeaderText = "工单状态";
			gs7.NullText = "";
			gs7.Width=60;
			gs7.ReadOnly=true;
			gs7.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs7);

			DataGridColumnStyle gs8 = new DataGridTextBoxColumn();
			gs8.MappingName = "gshow";
			gs8.HeaderText = "满意度";
			gs8.NullText = "";
			gs8.Width=100;
			gs8.ReadOnly=true;
			gs8.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs8);

			DataGridColumnStyle gs9 = new DataGridTextBoxColumn();
			gs9.MappingName = "ccomment";
			gs9.HeaderText = "用户评议";
			gs9.NullText = "";
			gs9.Width=200;
			gs9.ReadOnly=true;
			gs9.Alignment = HorizontalAlignment.Left;
			ts.GridColumnStyles.Add(gs9);


			this.dgWorker.TableStyles.Add(ts);

		
			//如果指定了DataGridTableStyle，则gridDataFilter1会加载它的标题
			this.gridDataFilter1.DataGridTableStyle = this.dgWorker.TableStyles[0];
			

			if (this.dgWorker.DataSource != null)
			{
				this.gridDataFilter1.Enabled = true;
			}
			else
			{
				this.gridDataFilter1.Enabled = false;
			}


			this.gridDataFilter1.DataSource=this.dgWorker.DataSource;
			this.gridDataFilter1.Begin();
		}

		private void dgWorker_CurrentCellChanged(object sender, System.EventArgs e)
		{
			try
			{
				if(this.dgWorker[this.dgWorker.CurrentCell.RowNumber,1].ToString()=="")
				{
					throw new Exception("请选择有效行");
				}
				if(this.dgWorker.CurrentCell.ColumnNumber==0)
				{
					if((bool)this.dgWorker[this.dgWorker.CurrentCell.RowNumber,0]==false)
					{
						this.dgWorker[this.dgWorker.CurrentCell.RowNumber,0]=true;
					}
					else
					{
						this.dgWorker[this.dgWorker.CurrentCell.RowNumber,0]=false;
					}
				}
				this.dgWorker.Select(this.dgWorker.CurrentCell.RowNumber);
				//			this.dgWorker.ReadOnly=true;
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
		}

		private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
		{
			switch (e.Button.Tag.ToString())
			{
				case "删除":
					try
					{
						if(MessageBox.Show("确定要删除此条记录吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.Yes)
						{
							WorkBillBLL wbll=new WorkBillBLL();
							if(wbll.delWorkBill(Convert.ToString(this.dgWorker[this.dgWorker.CurrentCell.RowNumber,0]))<=0)
							{
								MessageBox.Show("删除失败！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
							}
							else
							{
								//							wbll.delWorkBill(Convert.ToString(this.dgWorker[this.dgWorker.CurrentCell.RowNumber,0]));
								MessageBox.Show("删除成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
								getDataBind();
								
							}
					
						}
					}
					catch(Exception ex)
					{
						MessageBox.Show(ex.Message);
					}
					break;
					//				case "退出":
					//					this.Close();
					//					break;
				
			}
		}


		private void button1_Click(object sender, System.EventArgs e)
		{
			try
			{
				


				string strSel = "check = true";
				System.Data.DataRow[] rowArray =dsworker.Tables["worker"].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 ;
				}
				strCheck=strCheck.Substring(1,strCheck.Length - 1);
//				MessageBox.Show(strCheck);
				
				if(MessageBox.Show("确定要删除此条记录吗？","提示",MessageBoxButtons.YesNo,MessageBoxIcon.Warning)==DialogResult.Yes)
				{

					WorkBillBLL wbll=new WorkBillBLL();
					if(wbll.delWorkBill(strCheck)<=0)
					{
						MessageBox.Show("删除失败！","警告",MessageBoxButtons.OK,MessageBoxIcon.Warning);
					}
					else
					{
						//							wbll.delWorkBill(Convert.ToString(this.dgWorker[this.dgWorker.CurrentCell.RowNumber,0]));
						MessageBox.Show("删除成功！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
						getDataBind();
						//								ClearData();
					}
					
				}
			}
			catch(Exception ex)
			{
				MessageBox.Show(ex.Message);
			}
		}

		private void button1_Click_1(object sender, System.EventArgs e)
		{
			//			this.Close();
		}

		private void btSave_Click(object sender, System.EventArgs e)
		{
			CustomerBLL cbll=new CustomerBLL();
			CustomerInfo cinfo=new CustomerInfo();
			WorkBillBLL wbll=new WorkBillBLL();
			WorkBillInfo winfo=new WorkBillInfo();
			cinfo=cbll.getCustomerById(Convert.ToInt32(this.dgWorker[this.dgWorker.CurrentCell.RowNumber,2]));
			winfo=wbll.getWorkBillById(Convert.ToInt32(this.dgWorker[this.dgWorker.CurrentCell.RowNumber,1]));
			//			WorkBillForm wform=new WorkBillForm(cinfo,winfo);
			//			wform.ShowDialog();

			SPServiceNoteBLL spbll = new SPServiceNoteBLL();
			
			IList spnList = spbll.getSPServiceNoteByWBId(winfo.id);
			if(spnList.Count>0)
			{
				new WorkBillSPNForm(cinfo,winfo).ShowDialog();
			}
			else
			{
				new WorkBillForm(cinfo,winfo).ShowDialog();
			}
		}

		private void checkBox1_CheckedChanged(object sender, System.EventArgs e)
		{
			CurrencyManager cm = (CurrencyManager)dgWorker.BindingContext[dgWorker.DataSource,dgWorker.DataMember];
			int icount=cm.List.Count;

			//			MessageBox.Show(icount.ToString());
			if(this.checkBox1.Checked==true)
			{
				for(int dr=0;dr<icount;dr++)
				{
					dgWorker[dr,0]=true;
				}
			}
			else
			{
				for(int dr=0;dr<icount;dr++)
				{
					dgWorker[dr,0]=false;
				}
			}
		}

	}
}