public IEnumerable <SWfsVActivity> VCodeLists(int pageIndex, int pageSize, out int count)
{
SWfsVActivity obj = new SWfsVActivity();
var dic = new Dictionary <string, object>();
string code = Request.QueryString["ActivityCode"];
string name = Request.QueryString["ActivityName"];
string datetem = Request.QueryString["tb_Query_Time"];
ViewBag.ActivityCode = code;
ViewBag.ActivityName = name;
ViewBag.ListingOutletFlag = Request.QueryString["ListingOutletFlag"];
dic.Add("ActivityCode", code ?? "");
dic.Add("ActivityName", name ?? "");
if (Request.QueryString["ListingOutletFlag"] != null && Request.QueryString["ListingOutletFlag"] != "-1")
{
dic.Add("ListingOutletFlag", Request.QueryString["ListingOutletFlag"]);
}
else
{
dic.Add("ListingOutletFlag", "");
}
if (Request.QueryString["Query_Time"] != null && Request.QueryString["Query_Time"] != "-1" && Request.QueryString["tb_Query_Time"] != null && Request.QueryString["tb_Query_Time"] != "")
{
if (Request.QueryString["Query_Time"] == "1")
{
dic.Add("ActivityDateStart", datetem);
}
else
{
dic.Add("ActivityDateStart", "");
}
if (Request.QueryString["Query_Time"] == "2")
{
dic.Add("ActivityDateEnd", datetem);
}
else
{
dic.Add("ActivityDateEnd", "");
}
if (Request.QueryString["Query_Time"] == "3")
{
dic.Add("DateCreate", datetem);
}
else
{
dic.Add("DateCreate", "");
}
//DateTime time = DateTime.Parse(Request.QueryString["tb_Query_Time"]);
//string timeType = string.Empty;
//switch (Request.QueryString["Query_Time"])
//{
// case "1": timeType = "ActivityDateStart"; break;
// case "2": timeType = "ActivityDateEnd"; break;
// case "3": timeType = "DateCreate"; break;
//}
//dic.Add(timeType, time);
//dic.Add("ActivityDateStart", timeType);
//dic.Add("ActivityDateEnd", timeType);
//dic.Add("DateCreate", time);
ViewBag.Query_Time = Request.QueryString["Query_Time"];
ViewBag.tb_Query_Time = datetem;
}
else
{
if (Request.QueryString["Query_Time"] == "1")
{
dic.Add("ActivityDateStart", "");
}
else
{
dic.Add("ActivityDateStart", "");
}
if (Request.QueryString["Query_Time"] == "2")
{
dic.Add("ActivityDateEnd", "");
}
else
{
dic.Add("ActivityDateEnd", "");
}
if (Request.QueryString["Query_Time"] == "3")
{
dic.Add("DateCreate", "");
}
else
{
dic.Add("DateCreate", "");
}
}
IEnumerable <SWfsVActivity> list = DapperUtil.Query <SWfsVActivity>("ComBeziWfs_WfsCmsContent_SWfsVActivity_List", dic, new { ActivityCode = dic["ActivityCode"], ActivityName = dic["ActivityName"], ActivityDateStart = Request.QueryString["tb_Query_Time"], ActivityDateEnd = Request.QueryString["tb_Query_Time"], DateCreate = Request.QueryString["tb_Query_Time"], ListingOutletFlag = Request.QueryString["ListingOutletFlag"], pageIndex = pageIndex, pageSize = pageSize }).OrderByDescending(c => c.DateCreate).ToList();
count = DapperUtil.Query <int>("ComBeziWfs_WfsCmsContent_SWfsVActivity_List_Count", dic, new { ActivityCode = dic["ActivityCode"], ActivityName = dic["ActivityName"], ActivityDateStart = dic["ActivityDateStart"], ActivityDateEnd = Request.QueryString["tb_Query_Time"], DateCreate = Request.QueryString["tb_Query_Time"], ListingOutletFlag = Request.QueryString["ListingOutletFlag"], pageIndex = pageIndex, pageSize = pageSize }).First <int>();
return(list);
}
/// <summary>
/// 修改V码活动
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public bool VCodeUpdate(SWfsVActivity obj)
{
return(DapperUtil.Update <SWfsVActivity>(obj));
}
public string VCodeCreate()
{
SWfsVActivity obj = null;
bool isupdate = false;//用isupdat来区分添加和修改操作
string activityId = Request.Form["ActivityId"];
if (!string.IsNullOrEmpty(activityId))
{
isupdate = true;
obj = DapperUtil.QueryByIdentityWithNoLock <SWfsVActivity>(activityId);
}
else
{
obj = new SWfsVActivity();
obj.DateCreate = DateTime.Now;
}
//添加操作需要赋值的部分
if (isupdate == false)
{
string activityNo = DateTime.Now.ToString("yyyyMMdd") + DateTime.Now.Millisecond.ToString();
obj.ActivityId = activityNo;
}
//修改添加都需要赋值的【公共部分】
obj.ActivityTypeId = 7;
obj.ActivityName = Request.Form["ActivityName"];
//如保存过v码则不允许编辑对于disabled数据后台获取不到 需判断值
if (!string.IsNullOrEmpty(Request.Form["ActivityCode"]))
{
obj.ActivityCode = Request.Form["ActivityCode"];
}
obj.ActivityStatus = Request.Form["ActivityStatus"] != null?Convert.ToInt16(Request.Form["ActivityStatus"]) : (short)1;
obj.ActivityDateStart = DateTime.Parse(Request.Form["ActivityDateStart"]);
obj.ActivityDateEnd = DateTime.Parse(Request.Form["ActivityDateEnd"]);
obj.OperatorId = PresentationHelper.GetPassport().UserName;
obj.ListingOutletFlag = short.Parse(Request.Form["siteNo"]);
//根据isupdat谁的操作去做谁的事
if (isupdate == false)
{
if (Vcode.VCodeCreate(obj) >= 0)
{
return("{\"result\":\"success\"}");
}
else
{
return("{\"result\":\"false\"}");
}
}
else
{
if (Vcode.VCodeUpdate(obj))
{
return("{\"result\":\"success\"}");
}
else
{
return("{\"result\":\"false\"}");
}
}
}
/// <summary>
/// 添加V码活动
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int VCodeCreate(SWfsVActivity obj)
{
return(DapperUtil.Insert <SWfsVActivity>(obj, false));
}
