📄 wf_sys_maintenance.aspx.cs

📁 某大型国企试用的网上订餐管理系统完整源代码
💻 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;
//using System.Windows.Forms;
namespace WebApplication1
{
	/// <summary>
	/// WebForm1 的摘要说明。
	/// </summary>
	public class WF_SYS_MAINTENANCE : System.Web.UI.Page
	{
		protected System.Data.Odbc.OdbcConnection odbcConnection1;
		protected System.Data.Odbc.OdbcCommand odbcCommand1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.Label Label10;
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Web.UI.WebControls.RangeValidator vldSysLog;
		protected System.Web.UI.WebControls.RangeValidator vldOrder;
		protected System.Web.UI.WebControls.Button btnOrder;
		protected System.Web.UI.WebControls.Button btnCurrentMenu;
		protected System.Web.UI.WebControls.Button btnAll;
		protected System.Web.UI.WebControls.TextBox txtOrder;
		protected System.Web.UI.WebControls.TextBox txtCurrentMenu;
		protected System.Web.UI.WebControls.TextBox txtSysLog;
		protected System.Web.UI.WebControls.TextBox txtBatch;
		protected System.Web.UI.WebControls.Button btnBatch;
		protected System.Web.UI.WebControls.CheckBox cbAll;
		protected System.Web.UI.WebControls.RangeValidator vldBatch;
		protected System.Web.UI.WebControls.RangeValidator vldCurrentMenu;
		protected System.Web.UI.WebControls.Button btnSysLog;
		protected System.Web.UI.WebControls.Label lblTotalMsg;
		protected System.Web.UI.WebControls.Label lblMessage;

		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!Page.IsPostBack)
			{
				if (!Global.CheckUserValidation((string)Session["strRole"], Global.MENU_BACKUP))
				{
					Response.Redirect("err_session.htm", true);
				}
				txtBatch.Text = DateTime.Today.AddDays(-180).ToString("yyyy'-'MM'-'dd");
				txtOrder.Text = DateTime.Today.AddDays(-180).ToString("yyyy'-'MM'-'dd");
				txtCurrentMenu.Text = DateTime.Today.AddDays(-180).ToString("yyyy'-'MM'-'dd");
				txtSysLog.Text = DateTime.Today.AddDays(-90).ToString("yyyy'-'MM'-'dd");
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.odbcConnection1 = new System.Data.Odbc.OdbcConnection();
			this.odbcCommand1 = new System.Data.Odbc.OdbcCommand();
			this.btnOrder.Click += new System.EventHandler(this.btnOrder_Click);
			this.btnCurrentMenu.Click += new System.EventHandler(this.btnCurrentMenu_Click);
			this.btnSysLog.Click += new System.EventHandler(this.btnSysLog_Click);
			this.btnAll.Click += new System.EventHandler(this.btnAll_Click);
			this.btnBatch.Click += new System.EventHandler(this.btnBatch_Click);
			this.cbAll.CheckedChanged += new System.EventHandler(this.cbAll_CheckedChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void connectionDB()
		{
			Global.OpenConnection(ref odbcConnection1);
		}
		

		private void closeDB()
		{
			odbcConnection1.Close();	
		}

		private void btnBatch_Click(object sender, System.EventArgs e)
		{
			lblTotalMsg.Text = "";

			if (!vldBatch.IsValid || txtBatch.Text.Trim().CompareTo("") == 0)
			{
				lblMessage.Text = "部门工作餐表的日期格式错误。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""部门工作餐表的日期格式错误。请检查！"")</script>");
				return;
			}

			string strSql;
			int iRows=0;

			strSql = "select * from t_batch_order where `date` < '" + txtBatch.Text + "'";
			strSql += " INTO OUTFILE ";
			strSql += "'T_BATCH_ORDER." + txtBatch.Text + ".";
			strSql += DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt'";
			strSql += " FIELDS TERMINATED BY '|' ";

			connectionDB();
			odbcCommand1.Connection = odbcConnection1;
			odbcCommand1.CommandText = strSql;
			iRows = odbcCommand1.ExecuteNonQuery();

			if (iRows < 1)
			{
				lblMessage.Text = "部门工作餐表写文件时发生错误或没有找到符合条件的数据。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""部门工作餐表写文件时发生错误或没有找到符合条件的数据。请检查！"")</script>");
			}
			else
			{
				strSql = "delete from t_batch_order where `date` < '" + txtBatch.Text + "'";
				odbcCommand1.CommandText = strSql;
				iRows = odbcCommand1.ExecuteNonQuery();
				if (iRows < 1)
				{
					lblMessage.Text = "部门工作餐表删除数据时发生错误。请检查！";
					Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""部门工作餐表删除数据时发生错误。请检查！"")</script>");
				}
				else
				{
					Global.WriteLog(ref odbcConnection1, (string)Session["strUser"], Global.MENU_BACKUP, Global.ACTION_OTHER, strSql);
				}
			}

			closeDB();
			lblMessage.Text = "部门工作餐表数据维护成功！";
			lblTotalMsg.Text = lblMessage.Text;
		}

		private void btnOrder_Click(object sender, System.EventArgs e)
		{
			lblTotalMsg.Text = "";

			if (!vldOrder.IsValid || txtOrder.Text.Trim().CompareTo("") == 0)
			{
				lblMessage.Text = "个人订餐表的日期格式错误。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""个人订餐表的日期格式错误。请检查！"")</script>");
				return;
			}

			string strSql;
			string strNow;
			int iRows;

			strNow = DateTime.Now.ToString("yyyyMMddHHmmss");

			strSql = "select * from t_order_detail where order_id in (select order_id from t_order where `date` < '" + txtOrder.Text + "')";
			strSql += " INTO OUTFILE ";
			strSql += "'T_ORDER_DETAIL." + txtOrder.Text + ".";
			strSql += strNow + ".txt'";
			strSql += " FIELDS TERMINATED BY '|'";

			connectionDB();
			odbcCommand1.Connection = odbcConnection1;
			odbcCommand1.CommandText = strSql;
			iRows = odbcCommand1.ExecuteNonQuery();
			closeDB();
			if (iRows < 1)
			{
				lblMessage.Text = "个人订餐表(详细)写文件时发生错误或没有找到符合条件的数据。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""个人订餐表(详细)写文件时发生错误或没有找到符合条件的数据。请检查！"")</script>");
				return;
			}
			else
			{
				strSql = "delete from t_order_detail where order_id in (select order_id from t_order where `date` < '" + txtOrder.Text + "')";
				connectionDB();
				odbcCommand1.CommandText = strSql;
				iRows = odbcCommand1.ExecuteNonQuery();
				closeDB();
				if (iRows < 1)
				{
					lblMessage.Text = "个人订餐表(详细)删除数据时发生错误。请检查！";
					Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""个人订餐表(详细)删除数据时发生错误。请检查！"")</script>");
					return;
				}
				else
				{
					Global.WriteLog(ref odbcConnection1, (string)Session["strUser"], Global.MENU_BACKUP, Global.ACTION_OTHER, strSql);
				}
			}

			strSql = "select * from t_order where `date` < '" + txtOrder.Text + "'";
			strSql += " INTO OUTFILE ";
			strSql += "'T_ORDER." + txtOrder.Text + ".";
			strSql += strNow + ".txt'";
			strSql += " FIELDS TERMINATED BY '|' ";

			connectionDB();
			odbcCommand1.Connection = odbcConnection1;
			odbcCommand1.CommandText = strSql;
			iRows = odbcCommand1.ExecuteNonQuery();
			if (iRows < 1)
			{
				lblMessage.Text = "个人订餐表写文件时发生错误或没有找到符合条件的数据。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""个人订餐表写文件时发生错误或没有找到符合条件的数据。请检查！"")</script>");
			}
			else
			{
				strSql = "delete from t_order where `date` < '" + txtBatch.Text + "'";
				odbcCommand1.CommandText = strSql;
				iRows = odbcCommand1.ExecuteNonQuery();
				if (iRows < 1)
				{
					lblMessage.Text = "个人订餐表删除数据时发生错误。请检查！";
					Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""个人订餐表删除数据时发生错误。请检查！"")</script>");
				}
				else
				{
					Global.WriteLog(ref odbcConnection1, (string)Session["strUser"], Global.MENU_BACKUP, Global.ACTION_OTHER, strSql);
				}
			}

			closeDB();
			lblMessage.Text = "个人订餐表数据维护成功！";
			lblTotalMsg.Text = lblMessage.Text;
		}

		private void btnCurrentMenu_Click(object sender, System.EventArgs e)
		{
			lblTotalMsg.Text = "";

			if (!vldCurrentMenu.IsValid || txtCurrentMenu.Text.Trim().CompareTo("") == 0)
			{
				lblMessage.Text = "今日菜单表的日期格式错误。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""今日菜单表的日期格式错误。请检查！"")</script>");
				return;
			}

			string strSql;
			int iRows;

			strSql = "select * from t_current_menu where `date` < '" + txtCurrentMenu.Text + "'";
			strSql += " INTO OUTFILE ";
			strSql += "'T_CURRENT_MENU." + txtCurrentMenu.Text + ".";
			strSql += DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt'";
			strSql += " FIELDS TERMINATED BY '|' ";

			connectionDB();
			odbcCommand1.Connection = odbcConnection1;
			odbcCommand1.CommandText = strSql;
			iRows = odbcCommand1.ExecuteNonQuery();
			if (iRows < 1)
			{
				lblMessage.Text = "今日菜单表写文件时发生错误或没有找到符合条件的数据。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""今日菜单表写文件时发生错误或没有找到符合条件的数据。请检查！"")</script>");
			}
			else
			{
				strSql = "delete from t_current_menu where `date` < '" + txtCurrentMenu.Text + "'";
				odbcCommand1.CommandText = strSql;
				iRows = odbcCommand1.ExecuteNonQuery();
				if (iRows < 1)
				{
					lblMessage.Text = "今日菜单表删除数据时发生错误。请检查！";
					Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""今日菜单表删除数据时发生错误。请检查！"")</script>");
				}
				else
				{
					Global.WriteLog(ref odbcConnection1, (string)Session["strUser"], Global.MENU_BACKUP, Global.ACTION_OTHER, strSql);
				}
			}

			closeDB();
			lblMessage.Text = "今日菜单表数据维护成功！";
			lblTotalMsg.Text = lblMessage.Text;
		}

		private void btnSysLog_Click(object sender, System.EventArgs e)
		{
			lblTotalMsg.Text = "";

			if (!vldSysLog.IsValid || txtSysLog.Text.Trim().CompareTo("") == 0)
			{
				lblMessage.Text = "系统日志表的日期格式错误。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""系统日志表的日期格式错误。请检查！"")</script>");
				return;
			}

			string strSql;
			int iRows;

			strSql = "select * from t_sys_log where `date` < '" + txtSysLog.Text + "'";
			strSql += " INTO OUTFILE ";
			strSql += "'T_SYS_LOG." + txtSysLog.Text + ".";
			strSql += DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt'";
			strSql += " FIELDS TERMINATED BY '|' ";

			connectionDB();
			odbcCommand1.Connection = odbcConnection1;
			odbcCommand1.CommandText = strSql;
			iRows = odbcCommand1.ExecuteNonQuery();
			if (iRows < 1)
			{
				lblMessage.Text = "系统日志表写文件时发生错误或没有找到符合条件的数据。请检查！";
				Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""系统日志表写文件时发生错误或没有找到符合条件的数据。请检查！"")</script>");
			}
			else
			{
				strSql = "delete from t_current_menu where `date` < '" + txtSysLog.Text + "'";
				odbcCommand1.CommandText = strSql;
				iRows = odbcCommand1.ExecuteNonQuery();
				if (iRows < 1)
				{
					lblMessage.Text = "系统日志表删除数据时发生错误。请检查！";
					Page.RegisterStartupScript("alert", @"<script language=""javascript"">window.alert(""系统日志表删除数据时发生错误。请检查！"")</script>");
				}
				else
				{
					Global.WriteLog(ref odbcConnection1, (string)Session["strUser"], Global.MENU_BACKUP, Global.ACTION_OTHER, strSql);
				}
			}

			closeDB();
			lblMessage.Text = "系统日志表数据维护成功！";
			lblTotalMsg.Text = lblMessage.Text;
		}

		private void btnAll_Click(object sender, System.EventArgs e)
		{
			string mes="";

			btnBatch_Click(sender, e);
			mes += lblMessage.Text + "\n";

			btnOrder_Click(sender, e);
			mes += lblMessage.Text + "\n";
			
			btnCurrentMenu_Click(sender, e);
			mes += lblMessage.Text + "\n";
			
			btnSysLog_Click(sender, e);
			mes += lblMessage.Text + "\n";

			lblTotalMsg.Text = mes;
		}

		private void cbAll_CheckedChanged(object sender, System.EventArgs e)
		{
			btnAll.Enabled = cbAll.Checked;
		}	
	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -