/// <summary> /// 功能描述 : 添加[tblFW_Log]表的记录 /// 创建者 : Auto Generator /// 创建日期 : 2009-04-18 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="objInsert">需要添加的实体类</param> /// <returns>返回新增记录的PK主键的值</returns> public long Insert(tblFW_Log objInsert) { try { usp_tblFW_Log_Insert uspInsert = new usp_tblFW_Log_Insert(); uspInsert.ReceiveParameter(objInsert); uspInsert.ExecNoQuery(1); if (uspInsert.fldAutoID > 0) { return(uspInsert.fldAutoID); } else { throw new Exception("插入新记录失败"); } } catch (DBOpenException e) { throw new InsertException("打开数据库连接失败", "RuletblFW_Log", "Insert", objInsert.ToString()); } catch (DBPKException e) { throw new InsertException("相同的记录已经存在,违反表的唯一键约束", "RuletblFW_Log", "Insert", objInsert.ToString()); } catch (DBQueryException e) { throw new InsertException("执行Sql语句失败", "RuletblFW_Log", "Insert", objInsert.ToString()); } catch (Exception e) { throw new InsertException(e.Message, "RuletblFW_Log", "Insert", objInsert.ToString()); } }
/// <summary> /// 功能描述 : 写入操作日志 /// 创建者 : 马立军 /// 创建日期 : 2009-04-18 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="iModalID">操作模块ID(从CheckRight方法返回,0为找不到)</param> /// <param name="sContent">操作内容</param> public void WriteLog(int iModalID, string sContent, string uName, int userId, int cityId) { if (uName == "yzadmin") { return; } try { if (iModalID < 1) { iModalID = 0; } tblFW_Log objLog = new tblFW_Log(); objLog.fldModalID = iModalID; objLog.fldUserID = userId; objLog.fldCityID = cityId; objLog.fldContent = sContent; objLog.fldDate_operate = DateTime.Now; RuletblFW_Log ruleLog = new RuletblFW_Log(); ruleLog.Insert(objLog); } catch (Exception e) { BusiRuleException pexcep = new BusiRuleException(e.Message, "Page.PageBase", "WriteLog", "sContent:" + sContent); } }
/// <summary> /// 功能描述 : 写入操作日志 /// 创建者 : 马立军 /// 创建日期 : 2009-04-18 /// 修改者 : /// 修改日期 : /// 修改原因 : /// </summary> /// <param name="iModalID">操作模块ID(从CheckRight方法返回,0为找不到)</param> /// <param name="sContent">操作内容</param> public void WriteLog(int iModalID, string sContent, int UserID, int CityID, string UserHostAddress) { //if (this.userinfo.UserName == "yzadmin") // return; //if (iModalID < 1) // iModalID = 0; tblFW_Log objLog = new tblFW_Log(); objLog.fldModalID = iModalID; objLog.fldUserID = UserID; objLog.fldCityID = CityID; objLog.fldContent = sContent; objLog.fldDate_operate = DateTime.Now; objLog.fldIPAddress = UserHostAddress; RuletblFW_Log ruleLog = new RuletblFW_Log(); ruleLog.Insert(objLog); }