Exemple #1
0
 /// <summary>
 /// 新增/删除/修改 sys_Event
 /// </summary>
 /// <param name="fam">sys_EventTable实体类</param>
 /// <returns>返回0操正常</returns>
 public override int sys_EventInsertUpdate(sys_EventTable fam)
 {
     int rInt = 0;
     using (SqlConnection Conn = GetSqlConnection())
     {
         SqlCommand cmd = new SqlCommand("sys_EventInsertUpdateDelete", Conn);
         cmd.CommandType = CommandType.StoredProcedure;
         //设置参数
         cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录
         cmd.Parameters.Add("@EventID", SqlDbType.Int).Value = fam.EventID;  //事件ID号
         cmd.Parameters.Add("@E_U_LoginName", SqlDbType.NVarChar).Value = fam.E_U_LoginName;  //用户名
         cmd.Parameters.Add("@E_UserID", SqlDbType.Int).Value = fam.E_UserID;  //操作时用户ID与sys_Users中UserID
         cmd.Parameters.Add("@E_DateTime", SqlDbType.DateTime).Value = fam.E_DateTime;  //事件发生的日期及时间
         cmd.Parameters.Add("@E_ApplicationID", SqlDbType.Int).Value = fam.E_ApplicationID;  //所属应用程序ID与sys_Applicatio
         cmd.Parameters.Add("@E_A_AppName", SqlDbType.NVarChar).Value = fam.E_A_AppName;  //所属应用名称
         cmd.Parameters.Add("@E_M_Name", SqlDbType.NVarChar).Value = fam.E_M_Name;  //PageCode模块名称与sys_Module相同	
         cmd.Parameters.Add("@E_M_PageCode", SqlDbType.VarChar).Value = fam.E_M_PageCode;  //发生事件时模块名称
         cmd.Parameters.Add("@E_From", SqlDbType.NVarChar).Value = fam.E_From;  //来源
         cmd.Parameters.Add("@E_Type", SqlDbType.Int).Value = fam.E_Type;  //日记类型,1:操作日记2:安全日志3	
         cmd.Parameters.Add("@E_IP", SqlDbType.VarChar).Value = fam.E_IP;  //客户端IP地址
         cmd.Parameters.Add("@E_Record", SqlDbType.NVarChar).Value = fam.E_Record;  //详细描述
         Conn.Open();
         rInt = Convert.ToInt32(cmd.ExecuteScalar());
         cmd.Dispose();
         Conn.Dispose();
         Conn.Close();
     }
     return rInt;
 }
Exemple #2
0
 /// <summary>
 /// 写入日志到DB
 /// </summary>
 /// <param name="E_Type">日志类型:日记类型,1:操作日记2:安全日志</param>
 /// <param name="E_Record">日志内容</param>
 /// <param name="userid">关联用户id</param>
 public static void EventWriteDB(int E_Type, string E_Record, int userid)
 {
     sys_EventTable s_Et = new sys_EventTable();
     s_Et.E_DateTime = DateTime.Now;
     s_Et.E_From = Common.GetScriptUrl;
     s_Et.E_IP = Common.GetIPAddress();
     s_Et.E_Record = E_Record;
     s_Et.E_UserID = userid;
     s_Et.E_U_LoginName = UserData.Get_sys_UserTable(s_Et.E_UserID).U_LoginName;
     s_Et.E_Type = E_Type;
     s_Et.DB_Option_Action_ = "Insert";
     Permission PMI = FrameWorkPermission.Get_Permission;
     if (PMI != null)
     {
         s_Et.E_ApplicationID = PMI.ApplicationID;
         s_Et.E_A_AppName = BusinessFacade.sys_ApplicationsDisp(PMI.ApplicationID).A_AppName;
         s_Et.E_M_PageCode = PMI.PageCode;
         s_Et.E_M_Name = BusinessFacade.sys_ModuleDisp(PMI.ApplicationID, PMI.PageCode).M_CName;
     }
     BusinessFacade.sys_EventInsertUpdate(s_Et);
 }
Exemple #3
0
        /// <summary>
        /// 将记录集转为sys_EventTable实体类
        /// </summary>
        /// <param name="dr">记录集</param>
        /// <returns>sys_EventTable</returns>
        protected object Populatesys_Event(IDataReader dr)
        {
            sys_EventTable nc = new sys_EventTable();

            if (!Convert.IsDBNull(dr["EventID"])) nc.EventID = Convert.ToInt32(dr["EventID"]); // 事件ID号
            if (!Convert.IsDBNull(dr["E_U_LoginName"])) nc.E_U_LoginName = Convert.ToString(dr["E_U_LoginName"]).Trim(); // 用户名
            if (!Convert.IsDBNull(dr["E_UserID"])) nc.E_UserID = Convert.ToInt32(dr["E_UserID"]); // 操作时用户ID与sys_Users中UserID
            if (!Convert.IsDBNull(dr["E_DateTime"])) nc.E_DateTime = Convert.ToDateTime(dr["E_DateTime"]); // 事件发生的日期及时间
            if (!Convert.IsDBNull(dr["E_ApplicationID"])) nc.E_ApplicationID = Convert.ToInt32(dr["E_ApplicationID"]); // 所属应用程序ID与sys_Applicatio
            if (!Convert.IsDBNull(dr["E_A_AppName"])) nc.E_A_AppName = Convert.ToString(dr["E_A_AppName"]).Trim(); // 所属应用名称
            if (!Convert.IsDBNull(dr["E_M_Name"])) nc.E_M_Name = Convert.ToString(dr["E_M_Name"]).Trim(); // PageCode模块名称与sys_Module相同
            if (!Convert.IsDBNull(dr["E_M_PageCode"])) nc.E_M_PageCode = Convert.ToString(dr["E_M_PageCode"]).Trim(); // 发生事件时模块名称
            if (!Convert.IsDBNull(dr["E_From"])) nc.E_From = Convert.ToString(dr["E_From"]).Trim(); // 来源
            if (!Convert.IsDBNull(dr["E_Type"])) nc.E_Type = Convert.ToInt32(dr["E_Type"]); // 日记类型,1:操作日记2:安全日志3
            if (!Convert.IsDBNull(dr["E_IP"])) nc.E_IP = Convert.ToString(dr["E_IP"]).Trim(); // 客户端IP地址
            if (!Convert.IsDBNull(dr["E_Record"])) nc.E_Record = Convert.ToString(dr["E_Record"]).Trim(); // 详细描述
            return nc;
        }
Exemple #4
0
 /// <summary>
 /// 新增/删除/修改 sys_Event
 /// </summary>
 /// <param name="fam">sys_EventTable实体类</param>
 /// <returns>返回0操正常</returns>
 public abstract int sys_EventInsertUpdate(sys_EventTable fam);
Exemple #5
0
 /// <summary>
 /// 新增/删除/修改 sys_Event
 /// </summary>
 /// <param name="fam">sys_EventTable实体类</param>
 /// <returns>返回0操正常</returns>
 public static int sys_EventInsertUpdate(sys_EventTable fam)
 {
     return DataProvider.Instance().sys_EventInsertUpdate(fam);
 }
Exemple #6
0
 /// <summary>
 /// 根据ID返回 sys_EventTable实体类 单笔资料
 /// </summary>
 /// <param name="EventID">事件ID号</param>
 /// <returns>返回sys_EventTable实体类 EventID为0则无记录</returns>
 public static sys_EventTable sys_EventDisp(int EventID)
 {
     sys_EventTable fam = new sys_EventTable();
     QueryParam qp = new QueryParam();
     qp.PageIndex = 1;
     qp.PageSize = 1;
     qp.Where = " Where sys_Event.EventID = " + EventID;
     int RecordCount = 0;
     ArrayList lst = sys_EventList(qp, out RecordCount);
     if (RecordCount > 0)
     {
         fam = (sys_EventTable)lst[0];
     }
     return fam;
 }