editorder.cs

机械制造业信息管理系统(含源码) 是为一个粮仪厂开发的

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;

using System.Data;
using System.Data.OleDb;

namespace Eboer.MIS.MF.WinForm.Stock
{
	/// <summary>
	/// EditOrder 的摘要说明。
	/// </summary>
	public class EditOrder : System.Windows.Forms.Form
	{
		private System.Windows.Forms.Panel panel1;
		private System.Windows.Forms.Button button1;
		public System.Windows.Forms.Button button2;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Button button3;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Panel panel2;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.Button button4;
		public System.Windows.Forms.DataGrid list;
		private System.Windows.Forms.TextBox packSign;
		private System.Windows.Forms.TextBox pageSign;
		public System.Windows.Forms.TextBox sign;
		private System.Windows.Forms.DateTimePicker writeDate;
		private System.Windows.Forms.TextBox memo;
		private System.Windows.Forms.TextBox txExes;
		private System.Windows.Forms.Label addInfo;
		private System.Windows.Forms.Label modInfo;
		private System.ComponentModel.IContainer components;
		private System.Windows.Forms.ComboBox rgPlace;
		private System.Windows.Forms.ComboBox rgMeans;
		private System.Windows.Forms.ComboBox payMeans;
		private System.Windows.Forms.TextBox stockContactEr;
		private System.Windows.Forms.ComboBox stocker;
		private System.Windows.Forms.TextBox allExes;
		private System.Windows.Forms.DateTimePicker rgDate;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.ComboBox fplx;
		private System.Windows.Forms.TextBox hphm;
		private System.Windows.Forms.ComboBox yhzf;
		private System.Windows.Forms.ContextMenu contextMenu1;
		private System.Windows.Forms.MenuItem menuItem1;
		private System.Windows.Forms.MenuItem menuItem2;

		public  string autoID = null;

		public StockList _sl = null;

		public string selID = null;

		/// <summary>
		/// 数据源
		/// </summary>
		private DataSet ds = null;

		private int                            currentIndex = -1;
		private System.Windows.Forms.Button    button5;
		private System.Windows.Forms.ComboBox  jht;

		private ReportLibrary.ReportDocument rd = null;
		private System.Windows.Forms.ComboBox thisExecuteEr;
		private System.Windows.Forms.ComboBox payStat;
		private System.Windows.Forms.MenuItem menuItem3;
		private System.Windows.Forms.MenuItem menuItem4;
		private System.Windows.Forms.TextBox fc2;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.Timer timer1;

		private string _writeDate = "";

		public StockList scl = null;

		public EditOrder(StockList scl)
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			this.LoadConfig();

			this.timer1.Start();

			this.scl = scl;
		}

		public EditOrder(string selID){
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			this.selID = selID;

			this.LoadConfig();
		}

		private void LoadConfig(){

			this.LoadSelectItem();
			this.LoadBuyer();

			if(this.autoID == null){
				this.addInfo.Text = "录入：" + Public.userID + "," + DateTime.Now.ToString();
				this.button2.Enabled = false;
				this.button3.Enabled = false;
				this.button4.Enabled = false;
			}

			
			//当处理过数量时则重新计算总额
			//一个是列表中的总额，一个是基本信息中的总额
			this.list.CurrentCellChanged += new EventHandler(this.NumsChangeed);

			//
			//两个事件
			this.list.MouseDown   += new MouseEventHandler(this.ClickInDG);
			this.list.MouseUp     += new MouseEventHandler(this.UPInDG);		
		}

		///载入
		public void LoadItemCol(){
			try{

				string sql = "select proName as 品名,modelName as 规格,nums as 数量,unitName as 单位,price as 单价,allExes as 总额,content as 备注,spec as 编号 from StockList where";
				if(this.sign.Text.Trim() == ""){
					sql += " autoID = 0";
				}else{
					sql += " stockSign = '"+ this.sign.Text.Trim() +"'";
				}

				OleDbDataAdapter ad = new OleDbDataAdapter(sql,Public.conn);
				this.ds = new DataSet();
				ad.Fill(this.ds,"list");

				this.list.SetDataBinding(ds.Tables[0],"");

				Public.SizeColumnsToContent(this.list,-1,ds.Tables[0],new string[]{"编号"});
				this.InitDataGrid();

			}catch(Exception ex){
				MessageBox.Show(ex.Message.ToString());
				return;
			}

			this.packSign.Text = this.sign.Text;
		}

		/// <summary>
		/// 载入基本信息
		/// </summary>
		private void LoadInfo(){
			if(this.autoID != null){
				try{
					string sql = "select * from StockOrder where autoID = " + this.autoID;
					OleDbDataAdapter ad = new OleDbDataAdapter(sql,Public.conn);
					DataSet ds = new DataSet();
					ad.Fill(ds,"list");

					if(ds != null && ds.Tables[0].Rows.Count > 0){
						DataRow row = ds.Tables[0].Rows[0];

						this.sign.Text           = row["sosign"].ToString();
						this.packSign.Text       = row["pactSign"].ToString();
						this.pageSign.Text       = row["pageSign"].ToString();
						this.writeDate.Text      = row["WriteDate"].ToString().Replace("0:00:00","");

						this._writeDate          = Public.GetChineseDate(Convert.ToDateTime(row["WriteDate"].ToString().Replace(" 0:00:00","")));
						

						this.stocker.Text        = row["offerName"].ToString() + "（" + row["offerSign"].ToString() + "）";
						this.stockContactEr.Text = row["offerContactEr"].ToString();
						this.thisExecuteEr.Text  = row["thisExecuteEr"].ToString();
						this.allExes.Text        = row["allExes"].ToString();
						this.rgPlace.Text        = row["rgPlace"].ToString();
						this.rgMeans.Text        = row["rgMeansName"].ToString();
						this.rgDate.Text         = row["rgDate"].ToString();
						this.payMeans.Text       = row["payMeansName"].ToString();
						this.txExes.Text         = row["tsExes"].ToString();
						this.memo.Text           = row["content"].ToString();

						this.fplx.Text = row["fplx"].ToString();
						this.hphm.Text = row["hphm"].ToString();
						this.yhzf.Text = row["yhzf"].ToString();

						if(this.txExes.Text.Trim().Replace("0","").Equals("") || this.txExes.Text.Trim().Replace("0","").Equals(".")) this.txExes.Text = "";

						this.jht.Text  = row["jhrType"].ToString();

						this.payStat.Text = row["fc1"].ToString();

						this.fc2.Text = row["fc2"].ToString();

						
						this.addInfo.Text = "录入：" + row["addEr"].ToString() + "," + row["addDate"].ToString();
						this.modInfo.Text = "修改：" + row["modifyEr"].ToString() + "," + row["modifyDate"].ToString();


						this.button2.Enabled = true;
						this.button3.Enabled = true;
						this.button4.Enabled = true;

						//检查供货商的资料是否存在，如果不存在则不能进行相关的修改操作
						//灰色化保存按钮
						sql = "select * from CorpColl where comType='STOCK' and sign='"+ row["offerSign"].ToString() +"'";
						ad  = new OleDbDataAdapter(sql,Public.conn);
						DataSet _ds = new DataSet();
						ad.Fill(_ds,"corp");
						if(_ds == null || _ds.Tables[0].Rows.Count == 0){
							MessageBox.Show("数据库中找不到相关编号的供货商资料，可能已被删除或更改了手工编号！\n\n因缺少供货商资料本条信息已被冻结，不能进行修改操作，但可删除！");
							this.stocker.Enabled = false;
							this.button2.Enabled = false;
						}
							

					}

					this.sign.Enabled = false;

					//
					Public.ReSetGridCellHeight(this.list,"list");

				}catch(Exception ex){
					MessageBox.Show(ex.Message.ToString());
					this.Close();

				}
			}
		}

		/// <summary>
		/// 载入订货商
		/// </summary>
		private void LoadBuyer(){
			try{
				string sql = "select * from CorpColl where comType='STOCK'";
				OleDbDataAdapter ad = new OleDbDataAdapter(sql,Public.conn);
				DataSet ds = new DataSet();
				ad.Fill(ds,"list");
				if(ds != null){
					foreach(DataRow row in ds.Tables[0].Rows){
						this.stocker.Items.Add(row["corName"].ToString() + "（" + row["sign"].ToString() +"）");
					}
				}

				//选择默认
				if(this.selID != null){
					for(int i=0;i<this.stocker.Items.Count;i++){
						if(this.stocker.Items[i].ToString().EndsWith("（"+ this.selID.ToString() +"）")){
							this.stocker.SelectedIndex = i;
						}
					}

					
				}

				

			}catch(Exception ex){
				MessageBox.Show(ex.Message.ToString());
				return;
			}
		}

		/// <summary>
		/// 载入选择项
		/// </summary>
		private void LoadSelectItem(){

			//收货地址
			DataSet ds = Public.GetDireItem("交货地点（ZD002");
			if(ds != null){
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.rgPlace.Items.Add(row["diName"].ToString());
				}
			}

			//收货地址
			ds = Public.GetDireItem("交货方法（ZD008");
			if(ds != null){
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.rgMeans.Items.Add(row["diName"].ToString());
				}
			}

			//我方职员
			ds = Public.GetDireItem("员工（ZD007");
			if(ds != null){
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.thisExecuteEr.Items.Add(row["diName"].ToString());
				}
			}

			ds = Public.GetDireItem("付款方法（ZD004");
			if(ds != null){
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.payMeans.Items.Add(row["diName"].ToString());
				}
			}


			ds = Public.GetDireItem("发票类型（ZD003");
			if(ds != null){
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.fplx.Items.Add(row["diName"].ToString());
				}
			}

			ds = Public.GetDireItem("运费支付方式（ZD009");
			if(ds != null){
				for(int i=0;i<ds.Tables[0].Rows.Count;i++){
					DataRow row = ds.Tables[0].Rows[i];
					this.yhzf.Items.Add(row["diName"].ToString());
				}
			}
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.components = new System.ComponentModel.Container();
			this.panel1 = new System.Windows.Forms.Panel();
			this.thisExecuteEr = new System.Windows.Forms.ComboBox();
			this.writeDate = new System.Windows.Forms.DateTimePicker();
			this.allExes = new System.Windows.Forms.TextBox();
			this.stockContactEr = new System.Windows.Forms.TextBox();
			this.stocker = new System.Windows.Forms.ComboBox();