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