/// <summary> /// 添加 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Add(T_SYS_LOG_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("INSERT INTO T_SYS_LOG(LOGTYPE, OPERATION, OPERATIONCONTENT, LOGINUSERID, USERIP, OPERATETIME,SYSFLAG)"); sb.AppendFormat("VALUES("); sb.AppendFormat("'{0}'", ClsSql.EncodeSql(m.LOGTYPE)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPERATION)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPERATIONCONTENT)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.LOGINUSERID)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.USERIP)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.OPERATETIME)); sb.AppendFormat(",'{0}'", ClsSql.EncodeSql(m.SYSFLAG)); sb.AppendFormat(")"); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "添加成功!", "")); } else { return(new Message(false, "添加失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 根据查询条件获取某一条用户信息记录,用于修改、删除、用户登录验证 /// </summary> /// <param name="sw">参见模型</param> /// <returns>参见模型</returns> public static T_SYS_LOG_Model getModel(T_SYS_LOG_SW sw) { DataTable dtLog = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTFLAG = "日志类别" }); DataTable dt = BaseDT.T_SYS_LOG.getDT(sw); T_SYS_LOG_Model m = new T_SYS_LOG_Model(); if (dt.Rows.Count > 0) { int i = 0; DataTable dtUserRole = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { USERID = dt.Rows[i]["LOGINUSERID"].ToString() }); m.LOGTYPENAME = BaseDT.T_SYS_DICT.getName(dtLog, dt.Rows[i]["LOGTYPE"].ToString()); m.LOGID = dt.Rows[i]["LOGID"].ToString(); m.LOGTYPE = dt.Rows[i]["LOGTYPE"].ToString(); m.OPERATION = dt.Rows[i]["OPERATION"].ToString(); m.OPERATIONCONTENT = dt.Rows[i]["OPERATIONCONTENT"].ToString(); m.LOGINUSERID = dt.Rows[i]["LOGINUSERID"].ToString(); m.USERIP = dt.Rows[i]["USERIP"].ToString(); m.OPERATETIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["OPERATETIME"].ToString()); m.SYSFLAG = dt.Rows[i]["SYSFLAG"].ToString(); m.LOGINUSERName = BaseDT.T_SYSSEC_USER.getName(dtUserRole, dt.Rows[i]["LOGINUSERID"].ToString()); dtUserRole.Clear(); dtUserRole.Dispose(); } dtLog.Clear(); dtLog.Dispose(); dt.Clear(); dt.Dispose(); return(m); }
/// <summary> /// 日志保存 /// </summary> /// <param name="type">日志类型</param> /// <param name="title">标题</param> /// <param name="nr">内容</param> public static void LogSave(string type, string title, string nr) { T_SYS_LOG_Model m = new T_SYS_LOG_Model(); m.LOGTYPE = type; m.OPERATION = title; m.OPERATIONCONTENT = nr; m.LOGINUSERID = getUserID(); m.USERIP = ClsHtml.GetIP(); m.OPERATETIME = PublicClassLibrary.ClsSwitch.SwitTM(DateTime.Now); m.opMethod = "Add"; m.returnUrl = ""; m.SYSFLAG = ConfigCls.getSystemFlag(); BaseDT.T_SYS_LOG.Add(m); }
/// <summary> /// 删除 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Del(T_SYS_LOG_Model m) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("delete T_SYS_LOG"); sb.AppendFormat(" where LOGID= '{0}'", ClsSql.EncodeSql(m.LOGID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "删除成功!", "")); } else { return(new Message(false, "删除失败,请检查各输入框是否正确!", "")); } }
/// <summary> /// 获取分页 /// </summary> /// <param name="sw">参见模型</param> /// <param name="total">记录总数</param> /// <returns>参见模型</returns> public static IEnumerable <T_SYS_LOG_Model> getListPagerModel(T_SYS_LOG_SW sw, out int total) { var result = new List <T_SYS_LOG_Model>(); DataTable dtLog = BaseDT.T_SYS_DICT.getDT(new T_SYS_DICTSW { DICTFLAG = "日志类别" }); DataTable dt = BaseDT.T_SYS_LOG.getDT(sw, out total);//列表 string uidList = ""; for (int i = 0; i < dt.Rows.Count; i++) { if (string.IsNullOrEmpty(uidList)) { uidList += dt.Rows[i]["LOGINUSERID"].ToString(); } else { uidList += "," + dt.Rows[i]["LOGINUSERID"].ToString(); } } DataTable dtUser = BaseDT.T_SYSSEC_USER.getDT(new T_SYSSEC_IPSUSER_SW { USERID = uidList }); for (int i = 0; i < dt.Rows.Count; i++) { T_SYS_LOG_Model m = new T_SYS_LOG_Model(); m.LOGTYPENAME = BaseDT.T_SYS_DICT.getName(dtLog, dt.Rows[i]["LOGTYPE"].ToString()); m.OPERATION = dt.Rows[i]["OPERATION"].ToString(); m.LOGINUSERName = BaseDT.T_SYSSEC_USER.getName(dtUser, dt.Rows[i]["LOGINUSERID"].ToString()); m.USERIP = dt.Rows[i]["USERIP"].ToString(); m.OPERATETIME = PublicClassLibrary.ClsSwitch.SwitTM(dt.Rows[i]["OPERATETIME"].ToString()); m.LOGID = dt.Rows[i]["LOGID"].ToString(); result.Add(m); } dtLog.Clear(); dtLog.Dispose(); dt.Clear(); dt.Dispose(); dtUser.Clear(); dtUser.Dispose(); return(result); }
/// <summary> /// 增、删、改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Manager(T_SYS_LOG_Model m) { if (m.opMethod == "Add") { Message msgUser = BaseDT.T_SYS_LOG.Add(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Mdy") { Message msgUser = BaseDT.T_SYS_LOG.Mdy(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } if (m.opMethod == "Del") { Message msgUser = BaseDT.T_SYS_LOG.Del(m); return(new Message(msgUser.Success, msgUser.Msg, m.returnUrl)); } return(new Message(false, "无效操作", "")); }
/// <summary> /// 修改 /// </summary> /// <param name="m">参见模型</param> /// <returns>参见模型</returns> public static Message Mdy(T_SYS_LOG_Model m) { StringBuilder sb = new StringBuilder(); //HID, HNAME, SN, PHONE, SEX, BIRTH, ONSTATE, BYORGNO sb.AppendFormat("UPDATE T_SYS_LOG"); sb.AppendFormat(" set "); sb.AppendFormat("LOGTYPE='{0}'", ClsSql.EncodeSql(m.LOGTYPE)); sb.AppendFormat(",OPERATION='{0}'", ClsSql.EncodeSql(m.OPERATION)); sb.AppendFormat(",OPERATIONCONTENT='{0}'", ClsSql.EncodeSql(m.OPERATIONCONTENT)); if (string.IsNullOrEmpty(m.LOGINUSERID) == false) { sb.AppendFormat(",LOGINUSERID='{0}'", ClsSql.EncodeSql(m.LOGINUSERID)); } if (string.IsNullOrEmpty(m.USERIP) == false) { sb.AppendFormat(",USERIP='{0}'", ClsSql.EncodeSql(m.USERIP)); } if (string.IsNullOrEmpty(m.OPERATETIME) == false) { sb.AppendFormat(",OPERATETIME='{0}'", ClsSql.EncodeSql(m.OPERATETIME)); } //sb.AppendFormat(",SYSFLAG='{0}'", ClsSql.EncodeSql(m.SYSFLAG)); sb.AppendFormat(" where LOGID= '{0}'", ClsSql.EncodeSql(m.LOGID)); bool bln = DataBaseClass.ExeSql(sb.ToString()); if (bln == true) { return(new Message(true, "修改成功!", "")); } else { return(new Message(false, "修改失败,请检查各输入框是否正确!", "")); } }