📄 global.asax.cs
字号:
using System;
using System.Data;
using System.Collections;
using System.ComponentModel;
using System.Web;
using System.Web.SessionState;
using System.Configuration;
namespace WebApplication1
{
/// <summary>
/// Global 的摘要说明。
/// </summary>
public class Global : System.Web.HttpApplication
{
/// <summary>
/// 必需的设计器变量。
/// </summary>
//系统全局参数
public static string MENU_LOGIN="00";
public static string MENU_MANAGER="01";
public static string MENU_LOGER="02";
public static string MENU_DEST="03";
public static string MENU_PARA="04";
public static string MENU_BACKUP="05";
public static string MENU_TOTALMENU="06";
public static string MENU_CURRENTMENU="07";
public static string MENU_PRINT="08";
public static string MENU_STATISTIC="09";
public static string MENU_BATCHPRE="10";
public static string MENU_BATCH="11";
public static string MENU_ORDER="12";
public static string MENU_CHANGEPSW="13";
public static string MENU_ORDERHISTORY="14";
public static string MENU_VIEWRPT="20";
public static string MENU_BATCHORDERHISTORY="21";
public static char ACTION_ADD='0';
public static char ACTION_UPDATE='1';
public static char ACTION_DELETE='2';
public static char ACTION_OTHER='3';
//自定义变量，由本类内使用
private static string strConnString;
private static string strRemoteConnString;
private static string[] strMoring;
private static string[] strNoon;
private static string[] strEvening;
private static string[] strNight;
private static string isFreeDinner; //0-not include free; 1-include free
private static int FreeAmount;
private static bool EnableLOG;
public Global()
{
InitializeComponent();
//初始化系统全局参数
System.Data.Odbc.OdbcConnection conTmp;
System.Data.Odbc.OdbcCommand cmdTemp;
strConnString = ConfigurationSettings.AppSettings ["connstring"];
strRemoteConnString = ConfigurationSettings.AppSettings ["remoteconnstring"];
strMoring = new string[4];
strNoon = new string[4];
strEvening = new string[4];
strNight = new string[4];
isFreeDinner = "0";
FreeAmount = 500;
conTmp = new System.Data.Odbc.OdbcConnection(strConnString); // ("DRIVER={MySQL ODBC 3.51 Driver};Server=localhost;Database=dinner;PORT=3306;UID=root;Password=abc;CharSet=utf8;");
conTmp.Open ();
cmdTemp = new System.Data.Odbc.OdbcCommand();
cmdTemp.Connection = conTmp;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'a_start1'";
strMoring[0] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'a_start1'";
strMoring[0] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'a_end1'";
strMoring[1] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'a_start2'";
strMoring[2] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'a_end2'";
strMoring[3] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'b_start1'";
strNoon[0] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'b_end1'";
strNoon[1] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'b_start2'";
strNoon[2] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'b_end2'";
strNoon[3] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'c_start1'";
strEvening[0] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'c_end1'";
strEvening[1] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'c_start2'";
strEvening[2] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'c_end2'";
strEvening[3] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'd_start1'";
strNight[0] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'd_end1'";
strNight[1] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'd_start2'";
strNight[2] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'd_end2'";
strNight[3] = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'no_fee'";
isFreeDinner = cmdTemp.ExecuteScalar ().ToString() ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'limit_fee'";
FreeAmount = Convert.ToInt32(cmdTemp.ExecuteScalar ().ToString()) ;
cmdTemp.CommandText = "select `value` from t_sys_para where para_id = 'EnableLOG'";
EnableLOG = (cmdTemp.ExecuteScalar ().ToString().CompareTo("1")==0) ;
conTmp.Close();
}
public static bool FindBookTime(out string strDinner, out string strCurDate)
{
string strCurTime;
bool isInBookingTime;
strCurDate = DateTime.Now.ToString ("yyyy'-'MM'-'dd");
strCurTime = DateTime.Now.ToString ("HH':'mm");
isInBookingTime = true;
if ( strCurTime.CompareTo (Global.strMoring[2]) >= 0 && strCurTime.CompareTo (Global.strMoring[3]) <= 0)
{
strDinner = "A";
return isInBookingTime;
}
if ( strCurTime.CompareTo (Global.strNoon[2]) >= 0 && strCurTime.CompareTo (Global.strNoon[3]) <= 0)
{
strDinner = "B";
return isInBookingTime;
}
if ( strCurTime.CompareTo (Global.strEvening[2]) >= 0 && strCurTime.CompareTo (Global.strEvening[3]) <= 0)
{
strDinner = "C";
return isInBookingTime;
}
if ( strCurTime.CompareTo (Global.strNight[2]) >= 0 && strCurTime.CompareTo (Global.strNight[3]) <= 0)
{
strDinner = "D";
return isInBookingTime;
}
isInBookingTime = false;
if (strCurTime.CompareTo (Global.strNight[3]) > 0 || strCurTime.CompareTo (Global.strMoring[2]) < 0)
{
strDinner = "D";
return isInBookingTime;
}
if (strCurTime.CompareTo (Global.strEvening[3]) > 0)
{
strDinner = "C";
return isInBookingTime;
}
if (strCurTime.CompareTo (Global.strNoon[3]) > 0)
{
strDinner = "B";
return isInBookingTime;
}
strDinner = "A";
return isInBookingTime;
}
public static bool FindSetMenuTime(out string strDinner, out string strCurDate)
{
string strCurTime;
bool isInBookingTime;
strCurDate = DateTime.Now.ToString ("yyyy'-'MM'-'dd");
strCurTime = DateTime.Now.ToString ("HH':'mm");
isInBookingTime = true;
if ( strCurTime.CompareTo (Global.strMoring[0]) >= 0 && strCurTime.CompareTo (Global.strMoring[1]) <= 0)
{
strDinner = "A";
return isInBookingTime;
}
if ( strCurTime.CompareTo (Global.strNoon[0]) >= 0 && strCurTime.CompareTo (Global.strNoon[1]) <= 0)
{
strDinner = "B";
return isInBookingTime;
}
if ( strCurTime.CompareTo (Global.strEvening[0]) >= 0 && strCurTime.CompareTo (Global.strEvening[1]) <= 0)
{
strDinner = "C";
return isInBookingTime;
}
if ( strCurTime.CompareTo (Global.strNight[0]) >= 0 && strCurTime.CompareTo (Global.strNight[1]) <= 0)
{
strDinner = "D";
return isInBookingTime;
}
isInBookingTime = false;
if (strCurTime.CompareTo (Global.strNight[1]) > 0 || strCurTime.CompareTo (Global.strMoring[0]) < 0)
{
strDinner = "D";
return isInBookingTime;
}
if (strCurTime.CompareTo (Global.strEvening[1]) > 0)
{
strDinner = "C";
return isInBookingTime;
}
if (strCurTime.CompareTo (Global.strNoon[1]) > 0)
{
strDinner = "B";
return isInBookingTime;
}
strDinner = "A";
return isInBookingTime;
}
public static bool isIncludeFreeDinner()
{
return (isFreeDinner.CompareTo("1") == 0);
}
public static int GetFreeAmount()
{
return FreeAmount;
}
public static void OpenConnection(ref System.Data.Odbc.OdbcConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Close();
conn.ConnectionString = strConnString;
conn.Open();
}
}
public static void OpenRemoteConnection(ref System.Data.Odbc.OdbcConnection conn)
{
if (conn.State != ConnectionState.Open)
{
conn.Close();
conn.ConnectionString = strRemoteConnString;
conn.Open();
}
}
public static bool WriteLog(ref System.Data.Odbc.OdbcConnection conn, string strUser, string menu_id, char action, string action_str)
{
int iRows;
string strCmd;
if (!EnableLOG) return EnableLOG;
if (action_str.Length > 155)
{
string strAction;
strAction = action_str.Substring(0,50) + ".....";
strAction += action_str.Substring(action_str.Length-100,100);
action_str = strAction;
}
action_str.Replace(@"""", "");
strCmd = "insert into t_sys_log (`time`, `manager_id`, `menu_id`, `action`, `action_str`) values (";
strCmd += "now()";
strCmd += ", '" + strUser + "'";
strCmd += ", '" + menu_id + "'";
strCmd += ", '" + action + "'";
strCmd += ", " + '"' + action_str + '"';
strCmd += ")";
OpenConnection(ref conn);
System.Data.Odbc.OdbcCommand logCmd = new System.Data.Odbc.OdbcCommand();
logCmd.CommandText = strCmd;
logCmd.Connection = conn;
iRows = logCmd.ExecuteNonQuery();
return (iRows == 1);
}
public static bool CheckUserValidation(string strRole, string menu_id)
{
bool isValid = false;
switch(strRole)
{
case "0":
isValid = menu_id.CompareTo(MENU_MANAGER)==0 ||
menu_id.CompareTo(MENU_LOGER)==0 ||
menu_id.CompareTo(MENU_DEST)==0 ||
menu_id.CompareTo(MENU_PARA)==0 ||
menu_id.CompareTo(MENU_BACKUP)==0 ||
menu_id.CompareTo(MENU_ORDER)==0;
break;
case "1":
isValid = menu_id.CompareTo(MENU_TOTALMENU)==0 ||
menu_id.CompareTo(MENU_CURRENTMENU)==0 ||
menu_id.CompareTo(MENU_PRINT)==0 ||
menu_id.CompareTo(MENU_STATISTIC)==0 ||
menu_id.CompareTo(MENU_CHANGEPSW)==0 ||
menu_id.CompareTo(MENU_VIEWRPT)==0 ||
menu_id.CompareTo(MENU_ORDER)==0;
break;
case "2":
isValid = menu_id.CompareTo(MENU_CURRENTMENU)==0 ||
menu_id.CompareTo(MENU_PRINT)==0 ||
menu_id.CompareTo(MENU_CHANGEPSW)==0 ||
menu_id.CompareTo(MENU_VIEWRPT)==0 ||
menu_id.CompareTo(MENU_ORDER)==0;
break;
case "3":
isValid = menu_id.CompareTo(MENU_BATCHPRE)==0 ||
menu_id.CompareTo(MENU_ORDER)==0 ||
menu_id.CompareTo(MENU_BATCHORDERHISTORY)==0;
break;
case "4":
isValid = menu_id.CompareTo(MENU_BATCH)==0 ||
menu_id.CompareTo(MENU_ORDER)==0 ||
menu_id.CompareTo(MENU_BATCHORDERHISTORY)==0;
break;
case "5":
isValid = menu_id.CompareTo(MENU_ORDER)==0 ||
menu_id.CompareTo(MENU_ORDERHISTORY)==0;
break;
default:
isValid = false;
break;
}
return isValid;
}
protected void Application_Start(Object sender, EventArgs e)
{
}
protected void Session_Start(Object sender, EventArgs e)
{
Session["strUser"] = "Null";
Session["strUserName"] = "Null user";
Session["strDept"] = "Null";
Session["strDeptName"] = "Null dept";
Session["strRole"] = "Null";
}
protected void Application_BeginRequest(Object sender, EventArgs e)
{
}
protected void Application_EndRequest(Object sender, EventArgs e)
{
}
protected void Application_AuthenticateRequest(Object sender, EventArgs e)
{
}
protected void Application_Error(Object sender, EventArgs e)
{
}
protected void Session_End(Object sender, EventArgs e)
{
}
protected void Application_End(Object sender, EventArgs e)
{
}
#region Web 窗体设计器生成的代码
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -