/// <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);
}
/// <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);
}
private void OnStart()
{
int EventID = (int)Common.sink("EventID", MethodType.Get, 255, 1, DataType.Int);
sys_EventTable et = BusinessFacade.sys_EventDisp(EventID);
EventID_Txt.Text = et.EventID.ToString();
E_A_AppName_Txt.Text = et.E_A_AppName;
E_DateTime_Txt.Text = et.E_DateTime.ToString();
E_From_Txt.Text = et.E_From;
E_IP_Txt.Text = Common.GetIPLookUrl(et.E_IP);
E_M_Name_Txt.Text = et.E_M_Name;
E_Record_Txt.Text = et.E_Record;
E_Type_Txt.Text = MessageBox.Get_Type(et.E_Type);
E_U_LoginName_Txt.Text = et.E_U_LoginName;
}
/// <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);
}
/// <summary> /// 新增/删除/修改 sys_Event /// </summary> /// <param name="fam">sys_EventTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_EventInsertUpdate(sys_EventTable fam);
