/// <summary> /// 更新一条数据 /// </summary> public bool Update(int UserID, CUSTOMRP.Model.QUERYPARAMS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update QUERYPARAMS set "); strSql.Append("REPORT=@REPORT,"); strSql.Append("NAME=@NAME,"); strSql.Append("VALUE=@VALUE"); strSql.Append(" where REPORT=@REPORT and NAME=@NAME"); SqlParameter[] parameters = { new SqlParameter("@REPORT", SqlDbType.Int), new SqlParameter("@NAME", SqlDbType.NVarChar,50), new SqlParameter("@VALUE", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.REPORT; parameters[1].Value = model.NAME; parameters[2].Value = model.VALUE; int rows = DbHelperSQL.ExecuteSql(UserID, strSql.ToString(), parameters); if (rows > 0) { Model.AUDITLOG auditobj = model.GetAuditLogObject(null); auditobj.UserID = UserID; auditobj.CreateDate = DateTime.Now; auditobj.MessageType = Model.AUDITLOG.Severity.Audit; auditobj.ModuleName = "DAL.QUERYPARAMS.Update"; auditobj.Message = String.Format(AppNum.AuditMessage.QueryParamsUpdateSuccess, model.REPORT, model.NAME); AUDITLOG.Add(auditobj); return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(int UserID, CUSTOMRP.Model.QUERYPARAMS model) { return(dal.Update(UserID, model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(int UserID, CUSTOMRP.Model.QUERYPARAMS model) { return(dal.Add(UserID, model)); }