public bool Update(JobCouponConfigModel model) { try { return(handler.Update(model)); } catch (Exception ex) { logger.Log(Level.Error, ex.ToString()); return(false); } }
public static bool Insert(SqlConnection sqlconn, JobCouponConfigModel model) { string sql = @" INSERT INTO Configuration..SE_JobCouponConfig ( ActivityName , RuleID , CouponNum , CouponName , CouponExplain , ValidityTime , ProductType , OrderState, OrderMoney, ReturnType , State , CouponRules , CreateTime ) VALUES ( @ActivityName, @RuleID, @CouponNum, @CouponName, @CouponExplain, @ValidityTime, @ProductType , @OrderState, @OrderMoney, @ReturnType, @State, @CouponRules, @CreateTime )"; var sqlParas = new SqlParameter[] { new SqlParameter("@ActivityName", model.ActivityName), new SqlParameter("@RuleID", model.RuleID), new SqlParameter("@CouponNum", model.CouponNum), new SqlParameter("@CouponName", model.CouponName), new SqlParameter("@CouponExplain", model.CouponExplain), new SqlParameter("@ValidityTime", model.ValidityTime), new SqlParameter("@ProductType", model.ProductType), new SqlParameter("@OrderState", model.OrderState), new SqlParameter("@OrderMoney", model.OrderMoney), new SqlParameter("@ReturnType", model.ReturnType), new SqlParameter("@State", model.State), new SqlParameter("@CouponRules", model.CouponRules), new SqlParameter("@CreateTime", model.CreateTime) }; return(SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, sql, sqlParas) > 0); }
public ActionResult Save(int id, JobCouponConfigModel model) { bool result = false; if (id == 0) { //新增 model.CreateTime = DateTime.Now; result = _JobCouponConfigManager.Insert(model); } else { //修改 result = _JobCouponConfigManager.Update(model); } return(RedirectToAction("Index")); }
public static bool Update(SqlConnection sqlconn, JobCouponConfigModel model) { string sql = @" UPDATE Configuration..[SE_JobCouponConfig] SET [ActivityName] = @ActivityName ,[RuleID] = @RuleID ,[CouponNum] = @CouponNum ,[CouponName] = @CouponName ,[CouponExplain] = @CouponExplain ,[ValidityTime] = @ValidityTime ,[ProductType] = @ProductType ,[OrderState] = @OrderState ,[OrderMoney] = @OrderMoney ,[ReturnType] = @ReturnType ,[State] = @State ,[CouponRules] = @CouponRules ,[CreateTime] = @CreateTime WHERE ID = @ID "; var sqlParas = new SqlParameter[] { new SqlParameter("@ActivityName", model.ActivityName), new SqlParameter("@RuleID", model.RuleID), new SqlParameter("@CouponNum", model.CouponNum), new SqlParameter("@CouponName", model.CouponName), new SqlParameter("@CouponExplain", model.CouponExplain), new SqlParameter("@ValidityTime", model.ValidityTime), new SqlParameter("@ProductType", model.ProductType), new SqlParameter("@OrderState", model.OrderState), new SqlParameter("@OrderMoney", model.OrderMoney), new SqlParameter("@ReturnType", model.ReturnType), new SqlParameter("@State", model.State), new SqlParameter("@CouponRules", model.CouponRules), new SqlParameter("@CreateTime", model.CreateTime), new SqlParameter("@ID", model.ID) }; return(SqlHelper.ExecuteNonQuery(sqlconn, CommandType.Text, sql, sqlParas) > 0); }
public ActionResult AddOrEdit(int id) { if (id != 0) { //修改 JobCouponConfigModel model = _JobCouponConfigManager.SelectById(id) ?? new JobCouponConfigModel() { ID = -1 }; return(View(model)); } else { //新增 JobCouponConfigModel model = new JobCouponConfigModel() { ID = 0, State = true, ReturnType = 1, CreateTime = DateTime.Now }; return(View(model)); } }
public bool Update(JobCouponConfigModel model) { Func <SqlConnection, bool> action = (connection) => JobCouponConfigDAL.Update(connection, model); return(dbManager.Execute(action)); }