public ActionResult HistoryActions(int activeID, string type)
{
var content = "";
var result = WebActivityManager.HistoryActions(activeID, type).OrderBy(h => h.ChangeDatetime);
if (result != null && result.Count() > 0)
{
if (type == "AddGetRule")
{
System.Text.StringBuilder sbr = new System.Text.StringBuilder();
sbr.AppendFormat(@"<table><tr><td>序号</td><td>操作</td><td>操作人账号</td><td>操作时间</td></tr>");
int k = result.Count();
foreach (var h in result.Reverse())
{
sbr.AppendFormat($"<tr><td>{k}</td><td>{GetAddGetRuleOper(h.Operation)}</td><td>{h.Author}</td><td>{h.ChangeDatetime}</td></tr>");
k--;
}
sbr.AppendFormat("</table>");
content = sbr.ToString();
}
else
{
foreach (var h in result)
{
content += "<span style='display:block;margin-bottom:5px;'>" + (String.IsNullOrWhiteSpace(h.Author) ? (String.IsNullOrWhiteSpace(h.HostName) ? (String.IsNullOrWhiteSpace(h.IpAddress) ? "无用户名" : h.IpAddress) : h.HostName) : h.Author) + h.ChangeDatetime + h.Operation + "</span>";
}
}
}
else
{
content = "暂无记录";
}
return(Content(content));
}
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));
}
public ActionResult WebActive(string id)
{
if (String.IsNullOrWhiteSpace(id))
{
ViewBag.ActiveID = Convert.ToInt32(WebActivityManager.GetLastActiveID()) + 1;
ViewBag.action = "新增";
return(View(new WebActive()));
}
ViewBag.action = "更新";
ViewBag.ActiveID = id;
var data = WebActivityManager.WebActivityDetail(id);
return(View(data));
}
public ActionResult Index()
{
var model1 = WebActivityManager.SelectAllWebActivity();
IEnumerable <ActivityModel> model2 = null;
IConnectionManager cm = new ConnectionManager(ConfigurationManager.ConnectionStrings["Gungnir"].ConnectionString);
using (var conn = cm.OpenConnection())
{
var data = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "SELECT* FROM Activity..tbl_FlashSale AS FS WHERE FS.WebBanner IS NOT NULL ");
cm.CloseConnection();
if (data.Rows.Count > 0)
{
model2 = data.Rows.Cast <DataRow>().Select(row => new ActivityModel(row));
}
}
return(View(Tuple.Create(model1, model2)));
}
public ActionResult InsertHistoryAction(int ActiveID, string ObjectType, string AfterValue, string Operation)
{
return(Json(WebActivityManager.InsertHistoryActions(ActiveID, ObjectType, AfterValue, Operation, User == null ? "" : User.Identity.Name, Request.UserHostName, ""), JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteActivity(string actID, int Type)
{
return(Json(WebActivityManager.DeleteWebActivity(actID, Type), JsonRequestBehavior.AllowGet));
}
