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