public HttpResponseBase InestNewPromoPresent()
{
string jsonStr = String.Empty;
try
{
if (string.IsNullOrEmpty(Request.Params["row_id"]))
{
NewPromoPresentQuery newPresentQuery = new NewPromoPresentQuery();
newPresentQuery.event_type = Request.Params["event_type"];
if(newPresentQuery.event_type=="0")
{
newPresentQuery.event_type = "";
}
newPresentQuery.created = DateTime.Now;
newPresentQuery.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
newPresentQuery.modified = newPresentQuery.created;
newPresentQuery.muser = newPresentQuery.kuser;
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
newPresentQuery.start = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_start"])).ToString("yyyy-MM-dd HH:mm:ss"));
newPresentQuery.end = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_end"])).ToString("yyyy-MM-dd HH:mm:ss"));
newPresentQuery.bonus_expire_day = Convert.ToInt32(Request.Params["bonus_expire_day"]);
if (!string.IsNullOrEmpty(Request.Params["use_span_day"]))
{
newPresentQuery.use_span_day = Convert.ToInt32(Request.Params["use_span_day"]);
}
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
newPresentQuery.group_id = int.Parse(Request.Params["group_id"]);
}
//newPresentQuery.event_id = Request.Params["this_event_id"];
if (Convert.ToBoolean(Request.Params["state1"]) == true)
{
newPresentQuery.bonus_expire_day = 0;
newPresentQuery.gift_type = 1;
newPresentQuery.gift_id = Convert.ToInt32(Request.Params["gift_id"]);
newPresentQuery.freight_price = Convert.ToInt32(Request.Params["freight_price"]);
newPresentQuery.gift_amount = Convert.ToInt32(Request.Params["gift_amount"]);
}
else if (Convert.ToBoolean(Request.Params["state2"]) == true)
{
newPresentQuery.welfare_mulriple = Convert.ToDouble(Request.Params["welfare_mulriple"]);
newPresentQuery.gift_type = 2;
newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]);
newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString();
}
else if (Convert.ToBoolean(Request.Params["state3"]) == true)
{
newPresentQuery.gift_type = 3;
newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]);
newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString();
}
newPresentQuery.row_id = _INewPromoPresentMgr.GetNewPromoPresentMaxId();
newPresentQuery.event_id = BLL.gigade.Common.CommonFunction.GetEventId("PB", newPresentQuery.row_id.ToString());
if (_INewPromoPresentMgr.InsertNewPromoPresent(newPresentQuery) > 0)
{
jsonStr = "{success:true,event_id:\"" + newPresentQuery.event_id + "\"}";//返回json數據
}
else
{
jsonStr = "{success:false}";//返回json數據
}
}
else
{
NewPromoPresentQuery newPresentQuery = new NewPromoPresentQuery();
newPresentQuery.event_type = Request.Params["event_type"];
if (newPresentQuery.event_type == "0")
{
newPresentQuery.event_type = "";
}
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
newPresentQuery.row_id = Convert.ToInt32(Request.Params["row_id"]);
newPresentQuery.start = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_start"])).ToString("yyyy-MM-dd HH:mm:ss"));
newPresentQuery.end = Convert.ToDateTime((Convert.ToDateTime(Request.Params["valid_end"])).ToString("yyyy-MM-dd HH:mm:ss"));
newPresentQuery.bonus_expire_day = Convert.ToInt32(Request.Params["bonus_expire_day"]);
newPresentQuery.event_id = Request.Params["this_event_id"];
newPresentQuery.muser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
newPresentQuery.modified = DateTime.Now;
if (!string.IsNullOrEmpty(Request.Params["use_span_day"]))
{
newPresentQuery.use_span_day = Convert.ToInt32(Request.Params["use_span_day"]);
}
if (!string.IsNullOrEmpty(Request.Params["group_id"]))
{
newPresentQuery.group_id = int.Parse(Request.Params["group_id"]);
}
if (Convert.ToBoolean(Request.Params["state1"]) == true)
{
newPresentQuery.gift_type = 1;
newPresentQuery.gift_id = Convert.ToInt32(Request.Params["gift_id"]);
newPresentQuery.freight_price = Convert.ToInt32(Request.Params["freight_price"]);
newPresentQuery.gift_amount = Convert.ToInt32(Request.Params["gift_amount"]);
}
else if (Convert.ToBoolean(Request.Params["state2"]) == true)
{
newPresentQuery.welfare_mulriple = Convert.ToDouble(Request.Params["welfare_mulriple"]);
newPresentQuery.gift_type = 2;
newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]);
newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString();
}
else if (Convert.ToBoolean(Request.Params["state3"]) == true)
{
newPresentQuery.gift_type = 3;
newPresentQuery.deduct_welfare = Convert.ToInt32(Request.Params["deduct_welfare"]);
newPresentQuery.ticket_name = Request.Params["ticket_name"].ToString();
}
if (_INewPromoPresentMgr.UpdateNewPromoPresent(newPresentQuery) > 0)
{
jsonStr = "{success:true,event_id:0}";
}
else
{
jsonStr = "{success:false}";//返回json數據
}
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
public HttpResponseBase GetProductnameById()
{
string jsonStr = String.Empty;
string msg = string.Empty;
int tranInt = 0;
try
{
if (!string.IsNullOrEmpty(Request.Params["id"].ToString()) && int.TryParse(Request.Params["id"], out tranInt))
{
int id = Convert.ToInt32(Request.Params["id"]);
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
msg = _INewPromoPresentMgr.GetProductnameById(id);
if (!string.IsNullOrEmpty(msg))
{
jsonStr = "{success:true,msg:'" + msg + "'}";//返回json數據
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
else
{
jsonStr = "{success:false,msg:0}";//返回json數據
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
public HttpResponseBase GetNewPromoPresentList()
{
string json = string.Empty;
DataTable _dt = new DataTable();
NewPromoPresentQuery query = new NewPromoPresentQuery();
int totalCount = 0;
try
{
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
if (!string.IsNullOrEmpty(Request.Params["entId"]))
{
query.event_id = Request.Params["entId"].ToString();
}
//query.event_id = Request.Params["entId"];
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
_dt = _INewPromoPresentMgr.NewPromoPresentList(query, out totalCount);
for (int i = 0; i < _dt.Rows.Count; i++)
{
if(_dt.Rows[i]["event_type"].ToString()=="")
{
_dt.Rows[i]["event_type"] = "0";
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, Formatting.Indented, timeConverter) + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json.ToString());
this.Response.End();
return this.Response;
}
public HttpResponseBase DeleteNewPromoPresent()
{
string jsonStr = String.Empty;
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
NewPromoPresentQuery query = new NewPromoPresentQuery();
if (!String.IsNullOrEmpty(Request.Params["rowID"]))
{
try
{
foreach (string rid in Request.Params["rowID"].ToString().Split('|'))
{
if (!string.IsNullOrEmpty(rid))
{
query.row_id = Convert.ToInt32(rid);
_INewPromoPresentMgr.DeleteNewPromoPresent(query);
}
}
jsonStr = "{success:true}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false}";
}
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}
public JsonResult UpdateNewPromoPresentActive()
{
try
{
int currentUser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id;
int muser =0;
int activeValue = Convert.ToInt32(Request.Params["active"]);
if (!string.IsNullOrEmpty(Request.Params["muser"]))
{
muser = int.Parse(Request.Params["muser"].ToString());
}
if (currentUser == muser && activeValue == 1)
{
return Json(new { success = "stop" });
}
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
NewPromoPresentQuery modelPresent = new NewPromoPresentQuery();
modelPresent.status = Convert.ToInt32(Request.Params["active"]);
modelPresent.row_id = Convert.ToInt32(Request.Params["id"]);
modelPresent.muser = currentUser;
modelPresent.modified = DateTime.Now;
if (_INewPromoPresentMgr.UpdateActive(modelPresent) > 0)
{
return Json(new { success = "true" });
}
else
{
return Json(new { success = "false" });
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
return Json(new { success = "false" });
}
}
public HttpResponseBase GetNewPromoPresent()
{
string jsonStr = String.Empty;
_INewPromoPresentMgr = new NewPromoPresentMgr(mySqlConnectionString);
if (!String.IsNullOrEmpty(Request.Params["present_event_id"]))
{
try
{
int giftNum = _INewPromoPresentMgr.GetNewPromoPresent(Request.Params["present_event_id"].ToString());
jsonStr = "{success:true,count:" + giftNum + "}";
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,count:" + 0 + "}";
}
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}
