public ActionResult Edit(ShareActivityRulesConfig model)
 {
     if (model.Id != 0)
     {
         return(Json(ShareActivityRulesConfigManager.UpdateShareActivityRules(model)));
     }
     else
     {
         return(Json(ShareActivityRulesConfigManager.InsertShareActivityRules(model)));
     }
 }
 public bool InsertShareActivityRules(ShareActivityRulesConfig model)
 {
     try
     {
         return(DALShareActivityRules.InsertShareActivityRules(model));
     }
     catch (TuhuBizException)
     {
         throw;
     }
     catch (Exception ex)
     {
         var exception = new ShareActivityRulesConfigException(1, "InsertShareActivityRules", ex);
         Logger.Log(Level.Error, exception, "InsertShareActivityRules");
         throw ex;
     }
 }
Example #3
0
        public static bool UpdateShareActivityRules(ShareActivityRulesConfig model)
        {
            const string sql          = @"UPDATE Configuration..ShareActivityRulesConfig SET                                      
                                               Image= @Image  
                                              ,Status=@Status
                                              ,Rules=@Rules
                                              ,CreateTime=GETDATE()
                                WHERE Id=@Id";
            var          sqlParameter = new SqlParameter[]
            {
                new SqlParameter("@Status", model.Status),
                new SqlParameter("@Image", model.Image ?? string.Empty),
                new SqlParameter("@Rules", model.Rules ?? string.Empty),
                new SqlParameter("@Id", model.Id)
            };

            return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
        }
Example #4
0
        public static bool InsertShareActivityRules(ShareActivityRulesConfig model)
        {
            const string sql = @"  INSERT INTO Configuration..ShareActivityRulesConfig
                                          (    [Image]
                                              ,[Status]
                                              ,[Rules]
                                              ,[CreateTime]
                                          )
                                  VALUES(     @Image  
                                              ,@Status
                                              ,@Rules
                                              ,GETDATE()
                                          
                                          )";

            var sqlParameter = new SqlParameter[]
            {
                new SqlParameter("@Status", model.Status),
                new SqlParameter("@Image", model.Image ?? string.Empty),
                new SqlParameter("@Rules", model.Rules ?? string.Empty)
            };

            return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
        }