/// <summary>
/// 獲取商品數據
/// </summary>
/// <returns></returns>
public HttpResponseBase GetTrialProdCateList()
{
List<TrialProdCateQuery> store = new List<TrialProdCateQuery>();
string json = string.Empty;
try
{
TrialProdCateQuery query = new TrialProdCateQuery();
#region 獲取query對象數據
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Form["limit"]))
{
query.Limit = Convert.ToInt32(Request.Params["limit"]);
}
#endregion
_trialProdMgr = new TrialProdCateMgr(mySqlConnectionString);
_prodMgr = new ProductMgr(mySqlConnectionString);
prodCateMgr = new ProductCategoryMgr(mySqlConnectionString);//實例化對象mgr
_giftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString);
_trialMgr = new PromotionsAmountTrialMgr(mySqlConnectionString);
int totalCount = 0;
store = _trialProdMgr.Query(query, out totalCount);
foreach (var item in store)
{
item.product_name = _prodMgr.QueryClassify(Convert.ToUInt32(item.product_id)).Product_Name;
item.category_name = prodCateMgr.QueryAll(new ProductCategory { category_id = item.category_id }).FirstOrDefault().category_name;
if (item.event_id.StartsWith("T1") || item.event_id.StartsWith("T2"))
{
int id = Convert.ToInt16(item.event_id.Substring(2).ToString());
item.event_name = _trialMgr.GetModel(id).name;
}
if (item.event_id.StartsWith("G3"))
{
int id = Convert.ToInt16(item.event_id.Substring(2).ToString());
item.event_name = _giftMgr.GetModel(id).name;
}
}
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}";//返回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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase FirstSaveGift()
{
string jsonStr = String.Empty;
try
{
PromotionsAmountGiftQuery model = new PromotionsAmountGiftQuery();
#region 獲取第一步保存model的數據
if (!string.IsNullOrEmpty(Request.Params["name"]))
{
model.name = Request.Params["name"].ToString();
}
else
{
model.name = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["desc"]))
{
model.event_desc = Request.Params["desc"].ToString();
}
else
{
model.event_desc = string.Empty;
}
if (!string.IsNullOrEmpty(Request.Params["vendor_coverage"]))
{
model.vendor_coverage = Convert.ToInt32(Request.Params["vendor_coverage"].ToString());
}
else
{
model.vendor_coverage = 0;
}
if (!string.IsNullOrEmpty(Request.Params["amount"]))
{
model.amount = Convert.ToInt32(Request.Params["amount"].ToString());
}
else
{
model.amount = 0;
}
if (!string.IsNullOrEmpty(Request.Params["quantity"]))
{
model.quantity = Convert.ToInt32(Request.Params["quantity"].ToString());
}
else
{
model.quantity = 0;
}
model.kuser = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id.ToString();
model.created = DateTime.Now;
model.status = 0;
if (!string.IsNullOrEmpty(Request.Params["event_type_name"]))
{
//獲取event_type和category_father_id
_parasrcMgr = new ParameterMgr(mySqlConnectionString);
List<Parametersrc> fatherIdResult = _parasrcMgr.QueryUsed(new Parametersrc { ParameterType = "event_type", parameterName = Request.Params["event_type_name"].ToString(), Used = 1 });
if (fatherIdResult.Count == 1)
{
model.event_type = fatherIdResult[0].ParameterCode;
model.category_father_id = Convert.ToUInt32(fatherIdResult[0].ParameterProperty);
}
}
else
{
model.event_type = string.Empty;
model.category_father_id = 0;
}
model.category_ipfrom = Request.UserHostAddress;
#endregion
_promoAmountGiftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString);
int id = _promoAmountGiftMgr.Save(model);
// DataTable dt = _promoAmountGiftMgr.SelectDt(query);
PromotionsAmountGift pag = _promoAmountGiftMgr.GetModel(id);
string event_id = CommonFunction.GetEventId(pag.event_type.ToString(), pag.id.ToString());
if (pag != null)
{
jsonStr = "{success:true,\"id\":\"" + pag.id + "\",\"cateID\":\"" + pag.category_id + "\",\"event_type\":\"" + pag.event_type + "\",\"event_id\":\"" + event_id + "\"}";
}
else
{
jsonStr = "{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);
jsonStr = "{success:false}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
/// <summary>
/// 刪除列表頁數據
/// </summary>
/// <returns></returns>
public HttpResponseBase DeletePromoAmountGift()
{
PromotionsAmountGift pag = new PromotionsAmountGift();
string jsonStr = String.Empty;
_promoAmountGiftMgr = new PromotionsAmountGiftMgr(mySqlConnectionString);
if (!String.IsNullOrEmpty(Request.Params["rowID"]))
{
try
{
foreach (string rid in Request.Params["rowID"].ToString().Split('|'))
{
if (rid != null)
{
pag = _promoAmountGiftMgr.GetModel(Convert.ToInt32(rid));
var eventid = CommonFunction.GetEventId(pag.event_type, pag.id.ToString());
if (!string.IsNullOrEmpty(rid))
{
if (_promoAmountGiftMgr.Delete(Convert.ToInt32(rid), eventid) > 0)
{
jsonStr = "{success:true}";
}
else
{
jsonStr = "{success:false}";
}
}
}
}
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;
}