public ActionResult Edit(PointsCenterConfig model)
{
string js = "<script>alert(\"保存失败 \");location='/PointsCenterConfig/Index';</script>";
if (model.Id != 0)
{
if (PointsCenterConfigManager.UpdatePointsCenterConfig(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
else
{
if (PointsCenterConfigManager.InsertPointsCenterConfig(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
}
public static bool UpdatePointsCenterConfig(PointsCenterConfig model)
{
const string sql = @"UPDATE Configuration..PointsCenterConfig SET
Sort=@Sort,
Grade=@Grade,
Status=@Status,
Image=@Image,
Link=@Link,
IOSProcessValue=@IOSProcessValue,
AndroidProcessValue=@AndroidProcessValue,
IOSCommunicationValue=@IOSCommunicationValue,
AndroidCommunicationValue=@AndroidCommunicationValue,
CreateTime= GETDATE(),
Description=@Description
WHERE Id=@Id";
var sqlParameter = new SqlParameter[]
{
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("@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("@Description", model.Description ?? string.Empty)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
public bool InsertPointsCenterConfig(PointsCenterConfig model)
{
try
{
return(DAlPointsCenterConfig.InsertPointsCenterConfig(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new PointsCenterConfigException(1, "InsertPointsCenterConfig", ex);
Logger.Log(Level.Error, exception, "InsertPointsCenterConfig");
throw ex;
}
}
public static bool InsertPointsCenterConfig(PointsCenterConfig model)
{
const string sql = @" INSERT INTO Configuration..PointsCenterConfig
(Sort ,
Grade ,
Status ,
Image ,
Link ,
IOSProcessValue ,
AndroidProcessValue ,
IOSCommunicationValue ,
AndroidCommunicationValue ,
CreateTime,
Description
)
VALUES(
@Sort, --Sort - int
@Grade, --Grade - int
@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(),-- CreateTime - datetime
@Description
)";
var sqlParameter = new SqlParameter[]
{
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("@Image", model.Image),
new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue),
new SqlParameter("@IOSProcessValue", model.IOSProcessValue),
new SqlParameter("@Link", model.Link ?? string.Empty),
new SqlParameter("@Description", model.Description ?? string.Empty)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
