Ejemplo n.º 1
0
 void context_AcquireRequestState(object sender, EventArgs e)
 {
     // 获取应用程序
     HttpApplication application = (HttpApplication)sender;
     HttpContext context = application.Context;
     // 获取Url
     string requestUrl = application.Request.Url.ToString();
     string AppRelative = application.Request.AppRelativeCurrentExecutionFilePath;
     string Url = AppRelative.Substring(2);
     string requestPage = requestUrl.Substring(requestUrl.LastIndexOf('/') + 1);
     if (!string.IsNullOrEmpty(context.Request.QueryString["MoudleId"]))
     {
         try
         {
             string Usercode = Authentication.GetUserCode();
             string MoudleId = context.Request.QueryString["MoudleId"];
             syslogLogic logic = new syslogLogic();
             syslogInfo info = new syslogInfo();
             info.MOUDLEID = Convert.ToInt64(MoudleId);
             info.USERCODE = Usercode;
             info.SJ = DateTime.Now;
             logic.Insert(info);
         }
         catch (Exception ex)
         {
         }
     }
 }
Ejemplo n.º 2
0
 /// <summary>
 /// 得到列表
 /// </summary>
 /// <param name="ent"></param>
 /// <returns></returns>
 public List<syslogInfo> GetsyslogList(string Where)
 {
     List<syslogInfo> list = new List<syslogInfo>();
     using(DbDataReader reader = DataBaseManage.ExecuteReader(DalSql+Where))
     {
         while (reader.Read())
         {
            syslogInfo ent = new syslogInfo();
             SetEnt(ent, reader);
             list.Add(ent);
         }
     }
     return list;
 }
Ejemplo n.º 3
0
        /// <summary>
        /// 根据Id得到
        /// </summary>
        /// <param name="ent"></param>
        /// <returns></returns>
        public syslogInfo Getsyslog( long ID)
        {
            syslogInfo ent = null;
            string sql = DalSql;
            sql = sql + " And  ID=@ID ";
            MySqlParameter[] paras = new MySqlParameter[]
            {
                new MySqlParameter("ID",ID)
            };
            using(DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
            {
                if (reader.Read())
                {
                    ent = new syslogInfo();
                    SetEnt(ent, reader);
                }

               		}
            return ent;
        }
Ejemplo n.º 4
0
 public int Update(syslogInfo ent)
 {
     return dao.Update(ent,null);
 }
Ejemplo n.º 5
0
 public int Insert(syslogInfo ent)
 {
     return dao.Insert(ent,null);
 }
Ejemplo n.º 6
0
 public int Delete(syslogInfo ent)
 {
     return dao.Delete(ent, null);
 }
Ejemplo n.º 7
0
 private int RunCommandWithTransatcion(syslogInfo ent, string vSql, IDbTransaction TRANS)
 {
     if (null == TRANS)
     {
         MySqlParameter[] paras = new MySqlParameter[ent.Column.Count];
         for (int i = 0; i < ent.Column.Count; i++)
         {
             paras[i] = new MySqlParameter();
             paras[i].ParameterName = ent.Column[i].FieldName;
             paras[i].DbType = ent.Column[i].FieldType;
             paras[i].Value = ent.Column[i].FieldValue;
         }
         return  DataBaseManage.ExecuteSql(vSql, paras);
     }
     else
     {
         System.Data.IDbCommand CM = TRANS.Connection.CreateCommand();
         CM.CommandText = vSql;
         CM.CommandType = CommandType.Text;
         CM.Transaction = TRANS;
         GetEntityDeleteParameter(CM, ent);
         try
         {
             return CM.ExecuteNonQuery();
         }
         catch (System.Exception e)
         {
             if (isDebug)
                 throw new Exception(e.Message);
             return 0;
         }
     }
 }
Ejemplo n.º 8
0
 public void SetEnt(syslogInfo ent, IDataReader dr)
 {
     ent.ID = MyConvert.ToLong(dr["ID"]);
     ent.USERCODE = MyConvert.ToString(dr["USERCODE"]);
     ent.MOUDLEID = MyConvert.ToLong(dr["MOUDLEID"]);
     ent.SJ = MyConvert.ToDateTime(dr["SJ"]);
 }