/// <summary> ///根据主键值查找Log_SqlError记录 /// </summary> /// <param name="keyId">KeyId</param> /// <returns>Log_SqlError</returns> public Log_SqlError FindLog_SqlError(int keyId) { string sql = @"SELECT KeyId, SPName, Description, LogTime FROM dbo.Log_SqlError WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, keyId); Log_SqlError log_SqlError = null; using (IDataReader dr = db.ExecuteReader(command)) { if (dr.Read()) { log_SqlError = new Log_SqlError(); log_SqlError.KeyId = (int)dr["KeyId"]; log_SqlError.SPName = (string)dr["SPName"]; log_SqlError.Description = (string)dr["Description"]; log_SqlError.LogTime = (DateTime)dr["LogTime"]; } } return(log_SqlError); }
/// <summary> /// 插入Log_SqlError记录 /// </summary> /// <param name="log_SqlError">Log_SqlError对象</param> /// <returns></returns> public int InsertLog_SqlError(Log_SqlError log_SqlError) { string sql = @"INSERT INTO dbo.Log_SqlError(SPName, Description, LogTime) VALUES(@SPName, @Description, @LogTime); SELECT @KeyId = SCOPE_IDENTITY()"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddOutParameter(command, "KeyId", DbType.Int32, sizeof(int)); db.AddInParameter(command, "SPName", DbType.String, log_SqlError.SPName); db.AddInParameter(command, "Description", DbType.String, log_SqlError.Description); db.AddInParameter(command, "LogTime", DbType.DateTime, log_SqlError.LogTime); int affectedRecords = db.ExecuteNonQuery(command); if (affectedRecords < 1) { throw new ApplicationException("插入数据失败, 没有记录被插入"); } else { string strTemp = "select @@identity"; DataTable dt = GetDataTable(strTemp); if (dt != null && dt.Rows.Count > 0) { affectedRecords = int.Parse(dt.Rows[0][0].ToString()); } } return(affectedRecords); }
/// <summary> /// 更新Log_SqlError记录 /// </summary> /// <param name="log_SqlError">Log_SqlError对象</param> /// <returns>受影响的记录数</returns> public int UpdateLog_SqlError(Log_SqlError log_SqlError) { string sql = @"UPDATE dbo.Log_SqlError SET SPName = @SPName, Description = @Description, LogTime = @LogTime WHERE KeyId = @KeyId"; Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); db.AddInParameter(command, "KeyId", DbType.Int32, log_SqlError.KeyId); db.AddInParameter(command, "SPName", DbType.String, log_SqlError.SPName); db.AddInParameter(command, "Description", DbType.String, log_SqlError.Description); db.AddInParameter(command, "LogTime", DbType.DateTime, log_SqlError.LogTime); return(db.ExecuteNonQuery(command)); }
/// <summary> /// 返回满足查询条件的Log_SqlError实体列表 /// </summary> /// <param name="param">查询条件</param> /// <returns>Log_SqlError实体列表</returns> public IList <Log_SqlError> GetLog_SqlErrors(QueryParameter param) { string sql = @"SELECT KeyId, SPName, Description, LogTime FROM dbo.Log_SqlError"; if (param != null) { sql = QueryParameter.CompleteSqlString(sql, param); } Database db = DatabaseFactory.CreateDatabase(DBLink.SysDBLink.ToString()); DbCommand command = db.GetSqlStringCommand(sql); if (param != null) { //设置参数 foreach (IExpression exp in param.WhereExpressions) { if (exp is SimpleExpression) { SimpleExpression simple = exp as SimpleExpression; db.AddInParameter(command, simple.ExpName, simple.DbType, simple.Value); } } } IList <Log_SqlError> list = new List <Log_SqlError>(); using (IDataReader dr = db.ExecuteReader(command)) { while (dr.Read()) { Log_SqlError log_SqlError = new Log_SqlError(); log_SqlError.KeyId = (int)dr["KeyId"]; log_SqlError.SPName = (string)dr["SPName"]; log_SqlError.Description = (string)dr["Description"]; log_SqlError.LogTime = (DateTime)dr["LogTime"]; list.Add(log_SqlError); } } return(list); }
/// <summary> /// 更新Log_SqlError /// </summary> /// <param name="log_SqlError">实体类</param> /// <param name="logEntity">日志类</param> /// <returns></returns> public string UpdateLog_SqlError(Log_SqlError log_SqlError, Log_Operate logEntity) { string strResult = ""; using (TransactionScope trans = new TransactionScope()) { try { this._log_SqlErrorDAO.UpdateLog_SqlError(log_SqlError); Log_OperateFacade logFacade = new Log_OperateFacade(); int intLog = logFacade.CreateLog_Operate(logEntity); trans.Complete(); } catch (Exception ex) { strResult = ex.Message; } } return(strResult); }
/// <summary> /// 创建Log_SqlError /// </summary> /// <param name="log_SqlError">实体类</param> /// <param name="logEntity">日志类</param> /// <param name="strResult">错误信息</param> /// <returns></returns> public int InsertLog_SqlError(Log_SqlError log_SqlError, Log_Operate logEntity, ref string strResult) { int intResult = 0; using (TransactionScope trans = new TransactionScope()) { try { this._log_SqlErrorDAO.InsertLog_SqlError(log_SqlError); Log_OperateFacade logFacade = new Log_OperateFacade(); logEntity.OperateFunction = "新增_log_SqlError表ID为" + intResult.ToString() + "的数据"; int intLog = logFacade.CreateLog_Operate(logEntity); trans.Complete(); } catch (Exception ex) { strResult = ex.Message; } } return(intResult); }
/// <summary> /// 更新Log_SqlError记录 /// </summary> /// <param name="log_SqlError"> /// Log_SqlError对象</param> /// <returns>受影响的记录数</returns> public int UpdateLog_SqlError(Log_SqlError log_SqlError) { return(this._log_SqlErrorDAO.UpdateLog_SqlError(log_SqlError)); }
/// <summary> /// 创建Log_SqlError记录 /// </summary> /// <param name="log_SqlError"> /// Log_SqlError对象</param> /// <returns></returns> public int CreateLog_SqlError(Log_SqlError log_SqlError) { return(this._log_SqlErrorDAO.InsertLog_SqlError(log_SqlError)); }