wf_order.aspx.cs

某大型国企试用的网上订餐管理系统完整源代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace WebApplication1
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WebF_Order : System.Web.UI.Page
	{
		protected System.Data.DataSet dataSet1;
		protected System.Data.Odbc.OdbcCommand odbcSelectCommand1;
		protected System.Data.Odbc.OdbcCommand odbcInsertCommand1;
		protected System.Data.Odbc.OdbcCommand odbcUpdateCommand1;
		protected System.Data.Odbc.OdbcCommand odbcDeleteCommand1;
		protected System.Data.Odbc.OdbcDataAdapter odbcDataAdapter1;
		protected System.Data.Odbc.OdbcCommand odbcCommand1;
		protected System.Data.DataView dataView1;
		protected System.Data.Odbc.OdbcConnection odbcConnection1;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Button BAdd;
		protected System.Web.UI.WebControls.Button BUpdate;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.CheckBox CBWorkFood;
		protected System.Web.UI.WebControls.Label lblDate;
		protected System.Web.UI.WebControls.DropDownList DDLDest;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox TBMemo;
		protected System.Web.UI.WebControls.DataGrid DGFind;
		protected System.Web.UI.WebControls.DataGrid DGEdit;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Button BDele;

		protected  bool  WorkFoodState;
		protected  string  WorkFoodState1;
		//private string selectstr;

		private string Insertstr;
		private string Updatastr;
		private string strCurDate;
		private string strCurTime;
		private string strDinner,strDinner2;
		private string strUser, strUserName;
		private string strDept, strDeptName;
		private string  strDinnerName;
		private float price_str=0;
		private float   Totel_price;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.Button Button4;
		private int   T_order_count;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面


		  DGEdit.HeaderStyle.Height=30;
			Totel_price = Global.GetFreeAmount();
   		WorkFoodState = Global.isIncludeFreeDinner();
			strCurDate = DateTime.Now.ToString("yyyy'-'MM'-'dd");
			strCurTime = DateTime.Now.ToString("HH':'mm");
			FindDinner();
			CBWorkFood.Checked = false;
			CBWorkFood.Enabled = WorkFoodState;
			if (WorkFoodState) 
			{
				WorkFoodState1="1";
				}
			else
			{
				WorkFoodState1="0";
			}
			strUser = (string)Session["strUser"];
			strUserName = (string)Session["strUserName"];
			strDept = (string)Session["strDept"];
			strDeptName = (string)Session["strDeptName"];

			if (!Page.IsPostBack)
			{
				if (CBWorkFood.Checked)
				{

					Label4.Text="总金额:"+price_str.ToString()+"元;工作餐标准:"+Totel_price.ToString()+"元;" +
						"剩余标准:"+(Totel_price-price_str).ToString()+"元";
					Label2.Text = Label4.Text;
				}
				else
				{
					Label4.Text="总金额:"+price_str.ToString() +"元";
					Label2.Text = Label4.Text;

				}
				if (!Global.CheckUserValidation((string)Session["strRole"], Global.MENU_ORDER))
				{
				 Response.Redirect("err_session.htm", true);
				}	
			Finddestdata();
			}  

			Findselectdata();
			Query_select();
			Label3.Text = "您已经订了"+T_order_count.ToString()+"份"+strDinnerName+"餐";
			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dataSet1 = new System.Data.DataSet();
			this.odbcSelectCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcInsertCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcUpdateCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcDeleteCommand1 = new System.Data.Odbc.OdbcCommand();
			this.odbcDataAdapter1 = new System.Data.Odbc.OdbcDataAdapter();
			this.odbcCommand1 = new System.Data.Odbc.OdbcCommand();
			this.dataView1 = new System.Data.DataView();
			this.odbcConnection1 = new System.Data.Odbc.OdbcConnection();
			((System.ComponentModel.ISupportInitialize)(this.dataSet1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).BeginInit();
			this.Button4.Click += new System.EventHandler(this.BUpdate_Click);
			this.CBWorkFood.CheckedChanged += new System.EventHandler(this.CBWorkFood_CheckedChanged);
			this.DGFind.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DGFind_PageIndexChanged);
			this.DGFind.SelectedIndexChanged += new System.EventHandler(this.DGFind_SelectedIndexChanged);
			this.DGEdit.SelectedIndexChanged += new System.EventHandler(this.DGEdit_SelectedIndexChanged);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.BAdd.Click += new System.EventHandler(this.BAdd_Click);
			this.BUpdate.Click += new System.EventHandler(this.BUpdate_Click);
			this.BDele.Click += new System.EventHandler(this.BDele_Click);
			this.Button3.Click += new System.EventHandler(this.BAdd_Click);
			this.Button2.Click += new System.EventHandler(this.Button1_Click);
			// 
			// dataSet1
			// 
			this.dataSet1.DataSetName = "NewDataSet";
			this.dataSet1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// odbcDataAdapter1
			// 
			this.odbcDataAdapter1.DeleteCommand = this.odbcDeleteCommand1;
			this.odbcDataAdapter1.InsertCommand = this.odbcInsertCommand1;
			this.odbcDataAdapter1.SelectCommand = this.odbcSelectCommand1;
			this.odbcDataAdapter1.UpdateCommand = this.odbcUpdateCommand1;
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSet1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataView1)).EndInit();

		}
		#endregion

		private void FindDinner()
		{
			if (Global.FindBookTime(out strDinner, out strCurDate))
			{
				Botton_False();
				Botton_True();
				switch (strDinner)
				{
					case "A":
						lblDate.Text = "您订的是：" + strCurDate + " 的早餐";
						strDinnerName = "早";
						strDinner2 = "A";
						break;
					case "B":
						lblDate.Text = "您订的是：" + strCurDate + " 的午餐";
						strDinnerName = "午";
						strDinner2 = "B";
						break;
					case "C":
						lblDate.Text = "您订的是：" + strCurDate + " 的晚餐";
						strDinnerName = "晚";
						strDinner2 = "C";
						break;
					case "D":
						lblDate.Text = "您订的是：" + strCurDate + " 的零点餐";
						strDinnerName = "零点";
						strDinner2 = "D";
						break;
				}
			}
			else
			{
				Botton_False();
				switch (strDinner)
				{
					case "A":
						lblDate.Text = "订 " + strCurDate + " 早餐时间已过";
						strDinnerName = "早";
						strDinner2 = "B";
						break;
					case "B":
						lblDate.Text = "订 " + strCurDate + " 午餐时间已过";
						strDinnerName = "午";
						strDinner2 = "C";
						break;
					case "C":
						lblDate.Text = "订 " + strCurDate + " 晚餐时间已过";
						strDinnerName = "晚";
						strDinner2 = "D";
						break;
					case "D":
						lblDate.Text = "订 " + strCurDate + " 零点餐时间已过";
						strDinnerName = "零点";
						strDinner2 = "A";
						break;
				}
			}
		}
		private void Botton_False()
		{
				   BUpdate.Enabled=false;
					BAdd.Enabled=false;
					BDele.Enabled=false;
               Button4.Enabled=false;
               Button3.Enabled=false;

		}
		private void Botton_True()
		{
			//BUpdate.Enabled=true;
			BAdd.Enabled=true;
			//BDele.Enabled=true;
			//Button4.Enabled=true;
			Button3.Enabled=true;
		}
		private void connectionDB()
		{
			Global.OpenConnection(ref odbcConnection1);
				//	System.Data.Odbc.OdbcTransaction   adb = odbcConnection1.BeginTransaction();
				//	adb.Commit;
				//	adb.Rollback;
		}

		private void closeDB()
		{	
			if (odbcConnection1.State != ConnectionState.Closed)	
			{
				odbcConnection1.Close ();
			}	
		}	
 
		private void Query_select()　　　　　　　　　　　　　　//查找当日菜谱数据
		{
			DGEdit.CurrentPageIndex=0;
			dataSet1 =new DataSet();
			selectdata();
			PageIndexNbr();
		}	
		private void selectdata()
		{
			connectionDB();
			odbcDataAdapter1.SelectCommand.CommandText = "select  Style as 'Style1',Food_Id as 'Food_Id1',Name as 'Name1',TRUNCATE(Price/100.0,2) as 'Price1',1 as 'Nbr', Description as 'desc1',Image as 'Image2'"+
				"from T_Current_menu  where Date='"+strCurDate +"'and Kind='"+strDinner+"' order by Style desc";
			odbcDataAdapter1.SelectCommand.Connection = odbcConnection1;
			odbcDataAdapter1.Fill ( dataSet1 , "T_Current_Menu" ) ;
			dataSet1.Tables ["T_Current_Menu"].Columns.Add("check1", Type.GetType("System.Boolean"));
			foreach (DataRow dr in dataSet1.Tables ["T_Current_Menu"].Rows)
			{
				dr["check1"] = false;
			}

			DataView dataView1 = dataSet1.Tables [ "T_Current_Menu" ].DefaultView ;
			DGEdit.DataSource = dataView1 ;
			DGEdit.DataBind() ;
			closeDB();	
		  DGEdit.HeaderStyle.Height=30;
		}	

		private void PageIndexNbr()
		{
			DGEdit.AllowPaging = true;
		}

		private void Finddestdata()　　　　　　　　　　////查找dest数据
		{
			connectionDB();
			odbcDataAdapter1.SelectCommand.CommandText = "select Dest_id as 'ID',`Desc` as 'Name' from T_Dest order by Dest_Id desc";
			odbcDataAdapter1.SelectCommand.Connection = odbcConnection1;
			odbcDataAdapter1.Fill ( dataSet1 , "T_dest" ) ;
			DataView dataView1 = dataSet1.Tables [ "T_dest" ].DefaultView ;
			DDLDest.DataSource = dataView1 ;
			DDLDest.DataBind() ;
			closeDB();
					  
		}

		private void Findselectdata()
		{
			connectionDB();
		//	odbcDataAdapter1 =new System.Data.Odbc.OdbcDataAdapter ("select Order_id as '个人订单号',Date as '定餐日期',Kind as '餐别',Send_dest as	'送餐地点',"+
		//		"Name as '用户姓名',Department_id as	'部门ID',Department as '所在部门',Totel_price as '使用金额',Free as '是否免费',Memo as '备注',User_id as'员工编号' from T_order "+
		//		"where  Date='"+strCurDate+"'and Kind='"+strDinner+"'and user_id='"+strUser+"'"+" order by Order_id  desc" ,odbcConnection1 ) ;
			odbcDataAdapter1.SelectCommand.CommandText = "select Order_id ,Date ,Kind ,Send_dest,"+
				"Name ,Department_id ,Department,TRUNCATE(Totel_price/100.0,2) as Totel_price,Free ,Memo ,User_id  from T_order "+
				"where  Date='"+strCurDate+"'and Kind='"+strDinner+"'and user_id='"+strUser+"'"+" order by Order_id  desc";
			odbcDataAdapter1.SelectCommand.Connection = odbcConnection1;
		//int
			odbcDataAdapter1.Fill ( dataSet1 , "T_order" ) ;
			DataView dataView1 = dataSet1.Tables [ "T_order" ].DefaultView ;
			DGFind.DataSource = dataView1 ;
			DGFind.DataBind() ;
			closeDB();	
			DGFind.HeaderStyle.Height=30;
			T_order_count = dataSet1.Tables [ "T_order" ].Rows.Count;
		}

		private void DGFind_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DataTable Dt1;
			connectionDB();
         price_str=0;
			string order_id_index_str2=DGFind.SelectedItem .Cells [1].Text ;
			for (int i =0;i< DDLDest.Items.Count;i++)
			{
				if(DDLDest.Items[i].Text==DGFind.SelectedItem .Cells [4].Text)
				{
					DDLDest.SelectedValue=DDLDest.Items[i].Value;
				}
			}
			TBMemo.Text += DGFind.SelectedItem .Cells [10].Text ;
			//是否免费
			if (DGFind.SelectedItem .Cells [9].Text=="免费")
			{
				CBWorkFood.Checked=true;
			}
			else
				CBWorkFood.Checked=false;
			//	Query_select();
			//	dataSet1.Tables["t_order_detail"].Clear();