public ActionResult Edit(PersonalCenterConfig model) { string js = "<script>alert(\"保存失败 \");location='/PersonalCenterConfig/Index';</script>"; if (model.Id != 0) { if (PersonalCenterConfigManager.UpdatePersonalCenterConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } else { if (PersonalCenterConfigManager.InsertPersonalCenterConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } }
public static bool InsertPersonalCenterConfig(PersonalCenterConfig model) { const string sql = @" INSERT INTO Configuration..PersonalCenterConfig (Location, Sort, Grade, UrlType, Route, Status, Image, Link, IOSProcessValue, AndroidProcessValue, IOSCommunicationValue, AndroidCommunicationValue, CreateTime, VIPAuthorizationRuleId ) VALUES( @Location, --Location - int @Sort, --Sort - int @Grade, --Grade - int @UrlType, @Route, @Status, --Status - bit @Image, --Image - nvarchar(1000) @Link, --Link - nvarchar(500) @IOSProcessValue, --IOSProcessValue - nvarchar(500) @AndroidProcessValue, --AndroidProcessValue - nvarchar(500) @IOSCommunicationValue, --IOSCommunicationValue - nvarchar(500) @AndroidCommunicationValue, --AndroidCommunicationValue - nvarchar(500) GETDATE(), @VIPAuthorizationRuleId )"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Location", model.Location), new SqlParameter("@Sort", model.Sort), new SqlParameter("@Status", model.Status), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty), new SqlParameter("@Grade", model.Grade), new SqlParameter("@UrlType", model.UrlType), new SqlParameter("@Route", model.Route), new SqlParameter("@Image", model.Image), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue), new SqlParameter("@IOSProcessValue", model.IOSProcessValue), new SqlParameter("@Link", model.Link ?? string.Empty), new SqlParameter("@VIPAuthorizationRuleId", model.VIPAuthorizationRuleId) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public bool InsertPersonalCenterConfig(PersonalCenterConfig model) { try { return(DALPersonalCenterConfig.InsertPersonalCenterConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new PersonalCenterConfigException(1, "InsertPersonalCenterConfig", ex); Logger.Log(Level.Error, exception, "InsertPersonalCenterConfig"); throw ex; } }
public static bool UpdatePersonalCenterConfig(PersonalCenterConfig model) { const string sql = @"UPDATE Configuration..PersonalCenterConfig SET Location=@Location, Sort=@Sort, Grade=@Grade, UrlType=@UrlType, Route=@Route, Status=@Status, Image=@Image, Link=@Link, IOSProcessValue=@IOSProcessValue, AndroidProcessValue=@AndroidProcessValue, IOSCommunicationValue=@IOSCommunicationValue, AndroidCommunicationValue=@AndroidCommunicationValue, CreateTime= GETDATE(), VIPAuthorizationRuleId=@VIPAuthorizationRuleId WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Location", model.Location), new SqlParameter("@Sort", model.Sort), new SqlParameter("@Status", model.Status), new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty), new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty), new SqlParameter("@Grade", model.Grade), new SqlParameter("@UrlType", model.UrlType), new SqlParameter("@Route", model.Route), new SqlParameter("@Image", model.Image), new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue), new SqlParameter("@IOSProcessValue", model.IOSProcessValue), new SqlParameter("@Link", model.Link ?? string.Empty), new SqlParameter("@Id", model.Id), new SqlParameter("@VIPAuthorizationRuleId", model.VIPAuthorizationRuleId) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }