wf_batch_order_pre.aspx.cs

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

			odbcDataAdapter1.SelectCommand.CommandText = selectstr;
			odbcDataAdapter1.Fill ( dataSet1 , "T_BATCH_ORDER" ) ;
			DataView dataView1 = dataSet1.Tables [ "T_BATCH_ORDER" ].DefaultView ;
			DataGrid1.DataSource = dataView1 ;
			DataGrid1.HeaderStyle.Height=30;//  .CellPadding=5;//  CellPaddin
			DataGrid1.DataBind() ;
			closeDB();
		}

		private void PageIndexNbr()
		{
			lblCurrentPage.Text = "第 " + (DataGrid1.CurrentPageIndex + 1).ToString() + " 页/"; 
			lblCurrentPage.Text += "共 " + DataGrid1.PageCount.ToString() + " 页"; 
		}
		private void DataGrid1_PageIndexChanged_1(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			 DataGrid1.CurrentPageIndex=e.NewPageIndex;
		 	 selectdata();
			 PageIndexNbr();
		}

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			string strSqlVal;

			if (!btnAdd.Enabled)
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：已经超过订餐时间!"")</script>");
				return;
			}

			lblMessage.Text = "";
			if (!valNum.IsValid || txtNum.Text .Trim ().CompareTo ("") == 0)
			{
				lblMessage.Text = "错误：订餐份数格式不对!";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：订餐份数格式不对!"")</script>");
				return;
			}
			ddlEffect.SelectedValue = "0";
	
			strSqlVal = "'" + strCurDate  + "'";
			strSqlVal += ",'" + strDinner + "'";
			strSqlVal += ",'" + strDept + "'";
			strSqlVal += ",'" + strDeptName + "'";
			strSqlVal += "," + txtNum.Text;
			strSqlVal += ",'" + ddlDest.SelectedItem.Text   + "'";
			strSqlVal += ",'" + txtReason.Text  + "'";
			strSqlVal += ",'" + strUser + "'";
			strSqlVal += ",'" + strUserName + "'";
			strSqlVal += ",'" + "0"  + "'";
			strSqlVal += ",NULL,NULL";

			Insertstr = "INSERT INTO T_batch_order(`Date`, `Kind`, `Department_ID`, `department`, `Num`, `send_dest`, " +
						"`reason`, `Manager_id`, `Manager_name`, `Effect`, `Checker_id`, `Checker_name`)";
			Insertstr += "	VALUES (" + strSqlVal + ")";

			// lblMessage.Text =Insertstr.Substring(Insertstr.Length-10,10)+Insertstr.Length.ToString(); return;

			connectionDB();
			odbcCommand1.CommandText = Insertstr;
			odbcCommand1.Connection = odbcConnection1;
			int i = odbcCommand1.ExecuteNonQuery ();
			closeDB();
			if (i != 1)
			{
				lblMessage.Text = "错误！写入数据库出错，请检查。";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误！写入数据库出错，请检查。"")</script>");
			}
			else
			{
				Global.WriteLog(ref odbcConnection1, strUser, Global.MENU_BATCHPRE, Global.ACTION_ADD, Insertstr);
				DataGrid1.SelectedIndex = -1;
				select();
			}
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			txtNum.Text="";
			ddlDest.SelectedIndex = 0;
			ddlEffect.SelectedIndex = 0;
			txtReason.Text = "";
			lblMessage.Text = "";
			Insertstr="";
			DataGrid1.SelectedIndex = -1;
			select();
		}

		private void btnModify_Click(object sender, System.EventArgs e)
		{
			string strUpdate;
			int iUpdateRowCount;

			if (!btnModify.Enabled)
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：已经超过订餐时间!"")</script>");
				return;
			}

			lblMessage.Text = "";
			if (!valNum.IsValid || txtNum.Text .Trim ().CompareTo ("") == 0)
			{
				lblMessage.Text = "错误：订餐份数格式不对!";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：订餐份数格式不对!"")</script>");
				return;
		}

			if (ddlEffect.SelectedValue .CompareTo ("1") == 0)
			{
				lblMessage.Text = "错误：已经审核的订单不能在本处修改!";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：已经审核的订单不能在本处修改!"")</script>");
				return;
			}

			if (DataGrid1.SelectedIndex < 0) //unselected
			{
				lblMessage.Text = "未选择记录！请先选择一条记录，然后才能对其进行修改。";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""未选择记录！请先选择一条记录，然后才能对其进行修改。"")</script>");
				return;
			}
			else
			{
				strUpdate = "UPDATE T_batch_order set " +
					"num = " + txtNum.Text + ", " +
					"`send_dest` = '" + ddlDest.SelectedItem .Text  + "', " +
					"`reason` = '" + txtReason.Text  + "', " +
					"`effect` = '" + ddlEffect.SelectedValue  + "'";
				if (ddlEffect.SelectedValue.CompareTo ("1") == 0)
				{
					strUpdate += ", checker_id = '" + strUser + "'";
					strUpdate += ", checker_name = '" + strUserName + "'";
				}
				else
				{
					strUpdate += ", checker_id = NULL";
					strUpdate += ", checker_name = NULL";
				}

				strUpdate += " where batch_order_id = " + DataGrid1.SelectedItem .Cells [1].Text;
			}
			
			//lblMessage.Text = strUpdate; return;

			connectionDB();
			odbcCommand1.CommandText = strUpdate;
			odbcCommand1.Connection = odbcConnection1;
			iUpdateRowCount = odbcCommand1.ExecuteNonQuery ();
			closeDB();
			if (iUpdateRowCount != 1)
			{
				lblMessage.Text = "错误！写入数据库出错，请检查。";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误！写入数据库出错，请检查。"")</script>");
			}
			else
			{
				Global.WriteLog(ref odbcConnection1, strUser, Global.MENU_BATCHPRE, Global.ACTION_UPDATE, strUpdate);
				DataGrid1.SelectedIndex = -1;
				select();
			}
		}

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			txtNum.Text = DataGrid1.SelectedItem .Cells [4].Text ;
			ddlDest.SelectedValue  = DataGrid1.SelectedItem .Cells [6].Text ;
			txtReason.Text = DataGrid1.SelectedItem .Cells [7].Text ;
			ddlEffect.SelectedValue = ((DropDownList)DataGrid1.SelectedItem .Cells [5].Controls [1]).SelectedValue ;
		}

		private void btnDelete_Click(object sender, System.EventArgs e)
		{
			string strUpdate;
			int iUpdateRowCount;

			if (!btnDelete.Enabled)
			{
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：已经超过订餐时间!"")</script>");
				return;
			}

			lblMessage.Text = "";

			if (DataGrid1.SelectedIndex < 0) //unselected
			{
				lblMessage.Text = "未选择记录！请先选择一条记录，然后进行删除。";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""未选择记录！请先选择一条记录，然后进行删除。"")</script>");
				return;
			}
			else
			{
				if (ddlEffect.SelectedValue .CompareTo ("1") == 0)
				{
					lblMessage.Text = "错误：已经审核的订单不能在本处删除!";
					Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误：已经审核的订单不能在本处删除!"")</script>");
					return;
				}
				strUpdate = "delete from T_batch_order " +
					"where batch_order_id = ";

				strUpdate += DataGrid1.SelectedItem .Cells [1].Text;
			}

			connectionDB();
			odbcCommand1.CommandText = strUpdate;
			odbcCommand1.Connection = odbcConnection1;
			iUpdateRowCount = odbcCommand1.ExecuteNonQuery ();
			closeDB();
			if (iUpdateRowCount != 1)
			{
				lblMessage.Text = "错误！删除记录时出错，请检查。";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""错误！删除记录时出错，请检查。"")</script>");
			}
			else
			{
				Global.WriteLog(ref odbcConnection1, strUser, Global.MENU_BATCHPRE, Global.ACTION_UPDATE, strUpdate);
				DataGrid1.SelectedIndex = -1;
				select();
			}
		}
	}
}