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);
}
