public static List <ActivityBuild> ConvertToActivityBuild(DataTable dt) { List <ActivityBuild> list = new List <ActivityBuild>(); try { if (dt != null) { foreach (DataRow row in dt.Rows) { var item = new ActivityBuild() { id = Convert.ToInt32(row["id"] == DBNull.Value ? 0 : row["id"]), Title = row["Title"]?.ToString(), Content = row["Content"]?.ToString(), StartDT = Convert.ToDateTime(row["StartDT"] == DBNull.Value ? DateTime.MinValue : row["StartDT"]), EndDate = Convert.ToDateTime(row["EndDate"] == DBNull.Value ? DateTime.MaxValue : row["EndDate"]) }; list.Add(item); } } } catch (Exception ex) { } return(list); }
public ActionResult ActivityEdit(ActivityBuild model) { if (model.id == 0) { if (!string.IsNullOrEmpty(model.Content)) { bool result = ActivityManager.InsertActivityBuild(model); return(Json(result)); } } else { if (!string.IsNullOrEmpty(model.Content)) { string activityMenu = JsonConvert.SerializeObject(ActivityMenuBll.GetList(model.id.ToString())); string activityHome = JsonConvert.SerializeObject(ActivityHomeBll.GetList(model.id.ToString())); model.ActivityHome = activityHome; model.ActivityMenu = activityMenu; bool result = ActivityManager.UpdateActivityBuild(model, model.id); return(Json(result)); } } return(Json(false)); }
public ActionResult Index(int id) { ActivityBuild activityBuild = ActivityManager.GetActivityBuildById(id); htmlActivity = GetArticleContent(activityBuild); return(this.Content(htmlActivity)); }
public string GetActivityBuild(ActivityBuild model) { if (!string.IsNullOrEmpty(model.id.ToString()) && model.id != 0) { model = ActivityManager.GetActivityBuildById(model.id); return(JsonConvert.SerializeObject(model)); } return(""); }
public ActionResult Update(int id = 0) { ActivityBuild model = ActivityManager.GetActivityBuildById(id); ViewBag.ActivityBuild = model; List <ActivityContent> ContentList = JsonConvert.DeserializeObject <List <ActivityContent> >(model.Content); ViewBag.ContentList = ContentList; return(View()); }
public ActionResult AddActivity(ActivityBuild activityBuild) { if (!string.IsNullOrEmpty(activityBuild.Content)) { //string pureHtml = GetArticleContent(activityBuild); //byte[] array = System.Text.Encoding.UTF8.GetBytes(pureHtml); //Stream stream = new MemoryStream(array); //activityBuild.ActivityUrl = UploadFile(stream, "Activity_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".html"); return(Json(ActivityManager.InsertActivityBuild(activityBuild))); } return(Json(false)); }
public bool InsertActivityBuild(ActivityBuild model) { try { return(handler.InsertActivityBuild(model)); } catch (Exception ex) { var exception = new ActivityException(1, "InsertActivityBuild", ex); Logger.Error("InsertActivityBuild", exception); throw ex; } }
public bool UpdateActivityBuild(ActivityBuild model, int id) { try { return(handler.UpdateActivityBuild(model, id)); } catch (Exception ex) { var exception = new ActivityException(1, "UpdateActivityBuild", ex); Logger.Error("UpdateActivityBuild", exception); throw ex; } }
public ActionResult ActivityEdit(int id = 0) { ActivityBuild model = new ActivityBuild(); if (id != 0) { model = ActivityManager.GetActivityBuildById(id); } else { model.Content = "{total:0,rows:[]}"; } return(View(model)); }
public ActivityBuild GetActivityForPage(int pkid) { ActivityBuild result = null; try { result = dbScopeReadManager.Execute(conn => DALActivityBoard.GetActivityForPage(conn, pkid)); } catch (Exception ex) { logger.Log(Level.Error, ex, "GetActivityForPage"); } return(result); }
public static bool UpdateActivityBuild(SqlConnection conn, ActivityBuild model, int id) { string sql = @" UPDATE Activity..ActivityBuild SET Title=@Title, BgImageUrl=@BgImageUrl, SBgImageUrl=@SBgImageUrl, BgColor=@BgColor, Content = @Content , UpdateTime = GETDATE(), TireBrand=@TireBrand, ActivityType=@ActivityType, EndDate=@EndDate, DataParames=@DataParames, BigActivityHome=@BigActivityHome, ActivityHome=@ActivityHome, MenuType=@MenuType, ActivityMenu=@ActivityMenu,SelKeyName=@SelKeyName,SelKeyImage=@SelKeyImage,IsShowDate=@IsShowDate,IsTireSize=@IsTireSize,TireSizeConfig=@TireSizeConfig,UpdateUser=@UpdateUser,ActivityConfigType=@ActivityConfigType,StartDT=@StartDT,PersonWheel=@PersonWheel WHERE id = @id"; var sqlPrams = new SqlParameter[] { new SqlParameter("@Title", model.Title ?? string.Empty), new SqlParameter("@BgImageUrl", model.BgImageUrl ?? string.Empty), new SqlParameter("@SBgImageUrl", model.SBgImageUrl ?? string.Empty), new SqlParameter("@BgColor", model.BgColor ?? string.Empty), new SqlParameter("@Content", model.Content ?? string.Empty), new SqlParameter("@ActivityUrl", model.ActivityUrl ?? string.Empty), new SqlParameter("@id", id), new SqlParameter("@TireBrand", model.TireBrand ?? string.Empty), new SqlParameter("@ActivityType", model.ActivityType), new SqlParameter("@EndDate", model.EndDate), new SqlParameter("@DataParames", model.DataParames), new SqlParameter("@BigActivityHome", model.BigActivityHome), new SqlParameter("@ActivityHome", model.ActivityHome), new SqlParameter("@MenuType", model.MenuType), new SqlParameter("@ActivityMenu", model.ActivityMenu), new SqlParameter("@SelKeyName", model.SelKeyName), new SqlParameter("@SelKeyImage", model.SelKeyImage), new SqlParameter("@IsShowDate", model.IsShowDate), new SqlParameter("@IsTireSize", model.IsTireSize), new SqlParameter("@TireSizeConfig", model.TireSizeConfig), new SqlParameter("@UpdateUser", model.UpdateUser), new SqlParameter("@ActivityConfigType", model.ActivityConfigType), new SqlParameter("@PersonWheel", model.PersonWheel), new SqlParameter("@StartDT", model.StartDT) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0); }
public ActionResult ActivityEdit(int id = 0, int copy = 0) { ActivityBuild model = new ActivityBuild(); if (id != 0) { model = ActivityManager.GetActivityBuildById(id); if (string.IsNullOrWhiteSpace(model.ActivityMenu)) { model.MenuType = -1; } if (copy == 1) { model.id = 0; } } else { model.MenuType = -1; model.Content = "{total:0,rows:[]}"; } return(View(model)); }
private static string GetArticleContent(ActivityBuild model) { string pureHtml = GetPureHtml("/Content/CommonFile/ActivityTemplate.html"); pureHtml = pureHtml.Replace("$title$", model.Title); var activityContent = JsonConvert.DeserializeObject <List <ActivityContent> >(model.Content); string content = string.Empty; foreach (var item in activityContent.OrderBy(x => x.OrderBy).ToList()) { if (!string.IsNullOrWhiteSpace(item.PID)) { if (item.Type == 0 && item.BigImg == 1) //轮胎,1图 { content += " <a href=\"javascript:void(0);\" class=\"img\" iostype=\"#testapp#customSegue#TNTireInfoVC#\" androidtype=\"cn.TuHu.Activity.TireInfoUI\" pid=\"" + item.PID + "\" vid=\"" + item.VID + "\" activityid=\"" + item.ActivityId + "\" ><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 1 && item.BigImg == 1) //车品,1图 { content += " <a href=\"javascript:void(0);\" class=\"img\" iostype=\"#testapp#customSegue#TNGoodsListDetailViewController#\" androidtype=\"cn.TuHu.Activity.AutomotiveProducts.AutomotiveProductsDetialUI\" pid=\"" + item.PID + "\" vid=\"" + item.VID + "\" activityid=\"" + item.ActivityId + "\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 0 && item.BigImg == 0) //轮胎,2图 { content += " <a href=\"javascript:void(0);\" class=\"content\" iostype=\"#testapp#customSegue#TNTireInfoVC#\" androidtype=\"cn.TuHu.Activity.TireInfoUI\" pid=\"" + item.PID + "\" vid=\"" + item.VID + "\" activityid=\"" + item.ActivityId + "\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 1 && item.BigImg == 0)//车品,2图 { content += " <a href=\"javascript:void(0);\" class=\"content\" iostype=\"#testapp#customSegue#TNGoodsListDetailViewController#\" androidtype=\"cn.TuHu.Activity.AutomotiveProducts.AutomotiveProductsDetialUI\" pid=\"" + item.PID + "\" vid=\"" + item.VID + "\" activityid=\"" + item.ActivityId + "\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 0 && item.BigImg == 2)//轮胎,3图 { content += " <a href=\"javascript:void(0);\" class=\"content\" iostype=\"#testapp#customSegue#TNTireInfoVC#\" androidtype=\"cn.TuHu.Activity.TireInfoUI\" pid=\"" + item.PID + "\" vid=\"" + item.VID + "\" activityid=\"" + item.ActivityId + "\"><img class=\"img3\" src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 1 && item.BigImg == 2)//轮胎,3图 { content += " <a href=\"javascript:void(0);\" class=\"content\" iostype=\"#testapp#customSegue#TNGoodsListDetailViewController#\" androidtype=\"cn.TuHu.Activity.AutomotiveProducts.AutomotiveProductsDetialUI\" pid=\"" + item.PID + "\" vid=\"" + item.VID + "\" activityid=\"" + item.ActivityId + "\"><img class=\"img3\" src=\"" + item.Image + "\" alt=\"\" /></a>"; } } else { if (item.Type == 2 && item.BigImg == 2)//链接,3图 { content += " <a href=\"" + item.LinkUrl + "\" class=\"content\"><img class=\"img3\" src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 2 && item.BigImg == 0)//链接,2图 { content += " <a href=\"" + item.LinkUrl + "\" class=\"content\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 2 && item.BigImg == 1)//链接,1图 { content += " <a href=\"" + item.LinkUrl + "\" class=\"img\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 3 && item.BigImg == 1)//无,1图 { content += " <a href=\"javascript:void(0);\" class=\"img\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 3 && item.BigImg == 0)//无,2图 { content += " <a href=\"javascript:void(0);\" class=\"content\"><img src=\"" + item.Image + "\" alt=\"\" /></a>"; } else if (item.Type == 3 && item.BigImg == 2)//无,3图 { content += " <a href=\"javascript:void(0);\" class=\"content\"><img class=\"img3\" src=\"" + item.Image + "\" alt=\"\" /></a>"; } } } pureHtml = pureHtml.Replace("$content$", content); return(pureHtml); }
public ActionResult ActivityEdit(ActivityBuild model) { if (model.id == 0) { if (!string.IsNullOrEmpty(model.Content)) { model.CreatetorUser = User.Identity.Name; bool result = ActivityManager.InsertActivityBuild(model); if (result) { int id = ActivityManager.GetMaxID(); if (id > 0) { try { using (var client = new Tuhu.Service.SEO.CouchbaseRemovalClient()) { var resultClient = client.GetOrSetWXActivityPush(id, true); resultClient.ThrowIfException(true); } ActivityManager.ReloadActivity(HttpContext.Request.Headers["Host"].Contains(".tuhu.cn") ? "wx.tuhu.cn" : "wx.tuhu.work", model.id); LoggerManager.InsertOplog(new ConfigHistory() { AfterValue = model.Content, Author = User.Identity.Name, Operation = "新增活动:" + model.Title, ObjectType = "ACFV2", ObjectID = id.ToString() }); Business.CommonServices.CallCRMService.NewAddActivity(model.Title, model.StartDT.Value, model.EndDate.Value, "https://wx.tuhu.cn/staticpage/activity/list.html?id=" + id, null, id.ToString(), DataAccess.Entity.CommonServices.CRMSourceType.ActivityV2, User.Identity.Name); } catch (Exception em) { } finally { } } } return(Json(result)); } } else { if (!string.IsNullOrEmpty(model.Content)) { // string activityMenu = JsonConvert.SerializeObject( ActivityMenuBll.GetList(model.id.ToString())); // string activityHome = JsonConvert.SerializeObject(ActivityHomeBll.GetList(model.id.ToString())); // model.ActivityHome = activityHome; // model.ActivityMenu = activityMenu; var temp = ActivityManager.GetActivityBuildById(model.id); model.UpdateUser = User.Identity.Name; bool result = ActivityManager.UpdateActivityBuild(model, model.id); if (result) { try { using (var client = new Tuhu.Service.SEO.CouchbaseRemovalClient()) { var resultClient = client.GetOrSetWXActivityPush(model.id, true); resultClient.ThrowIfException(true); } ActivityManager.ReloadActivity(HttpContext.Request.Headers["Host"].Contains(".tuhu.cn") ? "wx.tuhu.cn" : "wx.tuhu.work", model.id); LoggerManager.InsertOplog(new ConfigHistory() { BeforeValue = temp.Content, AfterValue = model.Content, Author = User.Identity.Name, Operation = "修改活动:" + model.Title, ObjectType = "ACFV2", ObjectID = model.id.ToString() }); Business.CommonServices.CallCRMService.NewUpdateActivity(model.Title, model.StartDT.Value, model.EndDate.Value, "https://wx.tuhu.cn/staticpage/activity/list.html?id=" + model.id, null, model.id.ToString(), DataAccess.Entity.CommonServices.CRMSourceType.ActivityV2, User.Identity.Name); } catch (Exception em) { } finally { } } return(Json(result)); } } return(Json(false)); }
public ActionResult UpdateActivity(ActivityBuild activityBuild, int id) { return(Json(ActivityManager.UpdateActivityBuild(activityBuild, id))); }
public bool InsertActivityBuild(ActivityBuild model) { return(dbManager.Execute(conn => DALActivity.InsertActivityBuild(conn, model))); }
public bool UpdateActivityBuild(ActivityBuild model, int id) { return(dbManager.Execute(conn => DALActivity.UpdateActivityBuild(conn, model, id))); }
// private static readonly string GungnirReadConnStr = ConfigurationManager.ConnectionStrings["Gungnir_AlwaysOnRead"].ConnectionString; public static bool InsertActivityBuild(SqlConnection conn, ActivityBuild model) { string sql = @" INSERT INTO Activity..ActivityBuild ( Title , Content , BgImageUrl, SBgImageUrl, ActivityUrl , BgColor, CreateTime, TireBrand, ActivityType, EndDate, DataParames, BigActivityHome, ActivityHome, MenuType, ActivityMenu, SelKeyName,SelKeyImage,IsShowDate,IsTireSize,TireSizeConfig,CreatetorUser,UpdateUser,ActivityConfigType,StartDT,PersonWheel ) VALUES ( @Title , @Content , @BgImageUrl, @SBgImageUrl, @ActivityUrl , @BgColor, GETDATE(), @TireBrand, @ActivityType, @EndDate, @DataParames, @BigActivityHome, @ActivityHome , @MenuType, @ActivityMenu,@SelKeyName,@SelKeyImage,@IsShowDate,@IsTireSize,@TireSizeConfig,@CreatetorUser,@UpdateUser,@ActivityConfigType,@StartDT,@PersonWheel )"; var sqlPrams = new SqlParameter[] { new SqlParameter("@Title", model.Title ?? string.Empty), new SqlParameter("@Content", model.Content ?? string.Empty), new SqlParameter("@BgImageUrl", model.BgImageUrl ?? string.Empty), new SqlParameter("@SBgImageUrl", model.SBgImageUrl ?? string.Empty), new SqlParameter("@ActivityUrl", model.ActivityUrl ?? string.Empty), new SqlParameter("@BgColor", model.BgColor ?? string.Empty), new SqlParameter("@TireBrand", model.TireBrand ?? string.Empty), new SqlParameter("@ActivityType", model.ActivityType), new SqlParameter("@EndDate", model.EndDate), new SqlParameter("@DataParames", model.DataParames), new SqlParameter("@BigActivityHome", model.BigActivityHome ?? string.Empty), new SqlParameter("@ActivityHome", model.ActivityHome ?? string.Empty), new SqlParameter("@MenuType", model.MenuType), new SqlParameter("@ActivityMenu", model.ActivityMenu ?? string.Empty), new SqlParameter("@SelKeyName", model.SelKeyName), new SqlParameter("@SelKeyImage", model.SelKeyImage), new SqlParameter("@IsShowDate", model.IsShowDate), new SqlParameter("@IsTireSize", model.IsTireSize), new SqlParameter("@TireSizeConfig", model.TireSizeConfig), new SqlParameter("@CreatetorUser", model.CreatetorUser), new SqlParameter("@UpdateUser", model.UpdateUser), new SqlParameter("@ActivityConfigType", model.ActivityConfigType), new SqlParameter("@StartDT", model.StartDT), new SqlParameter("@PersonWheel", model.PersonWheel) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0); }
public ActionResult ViewActivity(ActivityBuild activityBuild) { htmlActivity = GetArticleContent(activityBuild); return(Json(true)); }