/// <summary>
/// 新增活动基本信息
/// </summary>
/// <param name="wa"></param>
/// <returns></returns>
public static int InsertWebActive(SqlDbHelper dbhelper, WebActive wa)
{
using (var cmd = new SqlCommand(@"INSERT INTO HuoDong..tbl_WebActivity
( ActiveID,
ActiveName,
ActiveLink,
ActiveDescription,
Banner,
CornerMark,
backgroundColor,
StartDateTime,
EndDateTime,
CreateDateTime
)
VALUES (@ActiveID, @ActiveName, @ActiveLink,@ActiveDescription ,@Banner, @CornerMark, @backgroundColor, @StartDateTime,@EndDateTime,GETDATE())" ))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ActiveID", wa.ActiveID);
cmd.Parameters.AddWithValue("@ActiveName", wa.ActiveName);
cmd.Parameters.AddWithValue("@ActiveLink ", wa.ActiveLink);
cmd.Parameters.AddWithValue("@ActiveDescription", wa.ActiveDescription);
cmd.Parameters.AddWithValue("@Banner", wa.Banner);
cmd.Parameters.AddWithValue("@CornerMark", wa.CornerMark);
cmd.Parameters.AddWithValue("@backgroundColor", wa.backgroundColor);
cmd.Parameters.AddWithValue("@StartDateTime", wa.StartDateTime);
cmd.Parameters.AddWithValue("@EndDateTime", wa.EndDateTime);
return(dbhelper.ExecuteNonQuery(cmd));
}
}
public ActionResult WebActiveConfig(string webActivity, string commodifyfloor, string otherpart, string Action)
{
WebActive webact = JsonConvert.DeserializeObject <WebActive>(webActivity);
webact.CommodifyFloor = JsonConvert.DeserializeObject <List <CommodityFloor> >(commodifyfloor);
webact.OtherPart = JsonConvert.DeserializeObject <List <OtherPart> >(otherpart);
var result = WebActivityManager.WebActiveConfig(webact, Action);
return(Json(result));
}
/// <summary>
/// 活动配置
/// </summary>
/// <param name="webact"></param>
/// <param name="action"></param>
/// <returns></returns>
public static int WebActiveConfig(WebActive webact, string action)
{
return(DALWebActivityDetail.InsertWebActivityDetail(webact, action));
}
/// <summary>
/// 新增活动/或更新活动
/// </summary>
/// <param name="webact"></param>
/// <param name="action"></param>
/// <returns></returns>
public static int InsertWebActivityDetail(WebActive webact, string action)
{
var result = 1;
var conn = ConfigurationManager.ConnectionStrings["Aliyun"].ConnectionString;
if (SecurityHelp.IsBase64Formatted(conn))
{
conn = SecurityHelp.DecryptAES(conn);
}
using (var dbhelper = new SqlDbHelper(conn))
{
dbhelper.BeginTransaction();
if (action == "更新")
{
result = DeleteWebActivity(webact.ActiveID, 1);
}
if (isExist(dbhelper, webact.ActiveID) <= 0 && result > 0)
{
result = InsertWebActive(dbhelper, webact);
if (result > 0)
{
foreach (var cf in webact.CommodifyFloor)
{
result = InsertCommodifyFloor(dbhelper, cf);
if (result > 0)
{
foreach (var p in cf.Products)
{
result = InsertProducts(dbhelper, p);
if (result <= 0)
{
result = -97;//产品插入失败
dbhelper.Rollback();
return(result);
}
}
}
else
{
result = -98;//商品楼层插入失败
dbhelper.Rollback();
return(result);
}
}
if (webact.OtherPart != null && webact.OtherPart.Count() > 0)
{
foreach (var op in webact.OtherPart)
{
result = InsertOtherPart(dbhelper, op);
if (result <= 0)
{
result = -96;//底部链接插入失败
dbhelper.Rollback();
return(result);
}
}
}
}
else
{
result = -99;//活动基本信息插入失败
dbhelper.Rollback();
return(result);
}
}
else
{
result = -1;//更新失败
dbhelper.Rollback();
return(result);
}
dbhelper.Commit();
return(result);
}
}
