public ActionResult Edit(DefaultSearchConfig model)
{
string js = "<script>alert(\"保存失败 \");location='/DefaultSearchConfig/Index';</script>";
if (model.Id != 0)
{
if (DefaultSearchConfigManager.UpdateDefaultSearchConfig(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
else
{
if (DefaultSearchConfigManager.InsertDefaultSearchConfig(model))
{
return(RedirectToAction("Index"));
}
else
{
return(Content(js));
}
}
}
public ActionResult Edit(int id = 0)
{
if (id == 0)
{
DefaultSearchConfig model = new DefaultSearchConfig();
model.Type = 2;
return(View(model));
}
else
{
return(View(DefaultSearchConfigManager.GetDefaultSearchConfig(id)));
}
}
public static bool UpdateDefaultSearchConfig(DefaultSearchConfig model)
{
const string sql = @"
UPDATE Configuration..DefaultSearchConfig
SET Name = @Name ,
Keywords = @Keywords ,
Image = @Image ,
Description = @Description ,
Link = @Link ,
IOSProcessValue = @IOSProcessValue ,
AndroidProcessValue = @AndroidProcessValue ,
IOSCommunicationValue = @IOSCommunicationValue ,
AndroidCommunicationValue = @AndroidCommunicationValue ,
WXAPPValue = @WXAPPValue ,
H5Value = @H5Value ,
Type = @Type ,
CreateTime = GETDATE() ,
ActivityType = @ActivityType ,
ActivityPromotionId = @ActivityPromotionId ,
ActivityStartTime = @ActivityStartTime ,
ActivityEndTime = @ActivityEndTime,
IsJump=@IsJump
WHERE Id = @Id;";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@Name", model.Name ?? string.Empty),
new SqlParameter("@Keywords", model.Keywords ?? string.Empty),
new SqlParameter("@Image", model.Image ?? string.Empty),
new SqlParameter("@Description", model.Description ?? string.Empty),
new SqlParameter("@Link", model.Link ?? string.Empty),
new SqlParameter("@IOSProcessValue", model.IOSProcessValue ?? string.Empty),
new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty),
new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue ?? string.Empty),
new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty),
new SqlParameter("@WXAPPValue", model.WXAPPValue ?? string.Empty),
new SqlParameter("@H5Value", model.H5Value ?? string.Empty),
new SqlParameter("@Type", model.Type),
new SqlParameter("@Id", model.Id),
new SqlParameter("@ActivityType", model.ActivityType),
new SqlParameter("@ActivityPromotionId", model.ActivityPromotionId),
new SqlParameter("@ActivityStartTime", model.ActivityStartTime),
new SqlParameter("@ActivityEndTime", model.ActivityEndTime),
new SqlParameter("@IsJump", model.IsJump?1:0)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
public bool InsertDefaultSearchConfig(DefaultSearchConfig model)
{
try
{
return(DALDefaultSearchConfig.InsertDefaultSearchConfig(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DefaultSearchConfigException(1, "InsertDefaultSearchConfig", ex);
Logger.Log(Level.Error, exception, "InsertDefaultSearchConfig");
throw ex;
}
}
public static bool InsertDefaultSearchConfig(DefaultSearchConfig model)
{
const string sql = @"
INSERT INTO Configuration..DefaultSearchConfig
( [Name] ,
[Keywords] ,
[Image] ,
[Description] ,
[Link] ,
[IOSProcessValue] ,
[AndroidProcessValue] ,
[IOSCommunicationValue] ,
[AndroidCommunicationValue] ,
[WXAPPValue] ,
[H5Value] ,
[Type] ,
[CreateTime] ,
ActivityType ,
ActivityPromotionId ,
ActivityStartTime ,
ActivityEndTime
)
VALUES ( @Name ,
@Keywords ,
@Image ,
@Description ,
@Link ,
@IOSProcessValue ,
@AndroidProcessValue ,
@IOSCommunicationValue ,
@AndroidCommunicationValue ,
@WXAPPValue ,
@H5Value ,
@Type ,
GETDATE() ,
@ActivityType ,
@ActivityPromotionId ,
@ActivityStartTime ,
@ActivityEndTime
);";
var sqlParameter = new SqlParameter[]
{
new SqlParameter("@Name", model.Name ?? string.Empty),
new SqlParameter("@Keywords", model.Keywords ?? string.Empty),
new SqlParameter("@Image", model.Image ?? string.Empty),
new SqlParameter("@Description", model.Description ?? string.Empty),
new SqlParameter("@Link", model.Link ?? string.Empty),
new SqlParameter("@IOSProcessValue", model.IOSProcessValue ?? string.Empty),
new SqlParameter("@AndroidProcessValue", model.AndroidProcessValue ?? string.Empty),
new SqlParameter("@IOSCommunicationValue", model.IOSCommunicationValue ?? string.Empty),
new SqlParameter("@AndroidCommunicationValue", model.AndroidCommunicationValue ?? string.Empty),
new SqlParameter("@WXAPPValue", model.WXAPPValue ?? string.Empty),
new SqlParameter("@H5Value", model.H5Value ?? string.Empty),
new SqlParameter("@Type", model.Type),
new SqlParameter("@ActivityType", model.ActivityType),
new SqlParameter("@ActivityPromotionId", model.ActivityPromotionId),
new SqlParameter("@ActivityStartTime", model.ActivityStartTime),
new SqlParameter("@ActivityEndTime", model.ActivityEndTime)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0);
}
