/// <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;
}
/// <summary>
/// 獲取商品數據
/// </summary>
/// <returns></returns>
public HttpResponseBase UpdateTrialProdCate()
{
List<TrialProdCateQuery> storeLi = new List<TrialProdCateQuery>();
string json = string.Empty;
try
{
_pcsMgr = new ProductCategorySetMgr(mySqlConnectionString);
_trialProdMgr = new TrialProdCateMgr(mySqlConnectionString);
//獲取新館類別
prodCateMgr = new ProductCategoryMgr(mySqlConnectionString);//實例化對象mgr
List<ProductCategory> category = prodCateMgr.QueryAll(new ProductCategory { category_display = 0 });//獲取所有的類別 顯示的隱藏的
ProductCategory useCate = prodCateMgr.QueryAll(new ProductCategory { category_father_id = 754, category_name = "用品館" }).FirstOrDefault();
string cateUseStr = string.Empty;//設定對象獲取用品館所有子類別
GetAllCategory_id(category, useCate.category_id, ref cateUseStr);//設定對象獲取用品館所有子類別 顯示的
ProductCategory eatCate = prodCateMgr.QueryAll(new ProductCategory { category_father_id = 754, category_name = "食品館" }).FirstOrDefault();
string cateEatStr = string.Empty;//設定對象獲取食品館所有子類別
GetAllCategory_id(category, eatCate.category_id, ref cateEatStr);//設定對象獲取食品館所有子類別 顯示的
_prodMgr = new ProductMgr(mySqlConnectionString);
//找到商品
List<TrialProdCateQuery> store = _trialProdMgr.UadateTrialProd();
Product prodModel = new Product();
//找到商品新館所有類別
foreach (var item in store)
{
if (item.product_id != 0)
{
prodModel = _prodMgr.QueryClassify(Convert.ToUInt32(item.product_id));
DataTable dt = new DataTable();
if (prodModel != null)
{
if (prodModel.Prod_Classify == 10)
{
item.type = 1;
dt = _pcsMgr.GetCateByProds(item.product_id.ToString(), cateEatStr);
//找到大類類別
bool isTrue = false;
if (dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
ProductCategory pcModel = new ProductCategory();
GetFatherCategory_id(category, ref isTrue, eatCate.category_id, Convert.ToUInt32(row["category_id"]), ref pcModel);
if (isTrue && pcModel != null)
{
if (item.category_id == 0)
{
item.category_id = pcModel.category_id;
storeLi.Add(item);
}
else
{
if (pcModel.category_id != item.category_id)
{
TrialProdCateQuery queryItem = new TrialProdCateQuery();
queryItem.product_id = item.product_id;
queryItem.event_id = item.event_id;
queryItem.type = item.type;
queryItem.start_date = item.start_date;
queryItem.end_date = item.end_date;
queryItem.category_id = pcModel.category_id;
List<TrialProdCateQuery> CFLi = storeLi.FindAll(p => p.category_id == queryItem.category_id && p.product_id == queryItem.product_id && p.type == queryItem.type && p.event_id == queryItem.event_id).ToList();
if (CFLi.Count == 0)
{
storeLi.Add(queryItem);
}
}
}
}
}
}
}
else if (prodModel.Prod_Classify == 20)
{
item.type = 2;
dt = _pcsMgr.GetCateByProds(item.product_id.ToString(), cateUseStr);
//找到大類類別
bool isTrue = false;
if (dt.Rows.Count != 0)
{
foreach (DataRow row in dt.Rows)
{
ProductCategory pcModel = new ProductCategory();
GetFatherCategory_id(category, ref isTrue, useCate.category_id, Convert.ToUInt32(row["category_id"]), ref pcModel);
if (isTrue && pcModel != null)
{
if (item.category_id == 0)
{
item.category_id = pcModel.category_id;
storeLi.Add(item);
}
else
{
if (pcModel.category_id != item.category_id)
{
TrialProdCateQuery queryItem = new TrialProdCateQuery();
queryItem.product_id = item.product_id;
queryItem.event_id = item.event_id;
queryItem.type = item.type;
queryItem.start_date = item.start_date;
queryItem.end_date = item.end_date;
queryItem.category_id = pcModel.category_id;
List<TrialProdCateQuery> CFLi = storeLi.FindAll(p => p.category_id == queryItem.category_id && p.product_id == queryItem.product_id && p.type == queryItem.type && p.event_id == queryItem.event_id).ToList();
if (CFLi.Count == 0)
{
storeLi.Add(queryItem);
}
}
}
}
}
}
}
}
}
}
//插入數據到主表trial_prod_cate
if (_trialProdMgr.InsertTrialProd(storeLi))
{
json = "{success:true}";
}
else
{
json = "{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);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetPromotionsAmountTrialList()
{
List<PromotionsAmountTrialQuery> store = new List<PromotionsAmountTrialQuery>();
string json = string.Empty;
try
{
PromotionsAmountTrialQuery query = new PromotionsAmountTrialQuery();
#region 獲取query對象數據
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Form["limit"]))
{
query.Limit = Convert.ToInt32(Request.Params["limit"]);
}
if (!string.IsNullOrEmpty(Request.Params["ddlSel"]))
{
query.expired = Convert.ToInt32(Request.Params["ddlSel"]);
}
if (!string.IsNullOrEmpty(Request.Params["serchcontent"]))
{
query.key = Request.Params["serchcontent"];
}
#endregion
_promotionsAmountTrialMgr = new PromotionsAmountTrialMgr(mySqlConnectionString);
_prodMgr = new ProductMgr(mySqlConnectionString);
int totalCount = 0;
_ITrialRecordMgr = new TrialRecordMgr(mySqlConnectionString);
store = _promotionsAmountTrialMgr.Query(query, out totalCount);
List<Parametersrc> ProductFreightStore = new List<Parametersrc>();
List<Parametersrc> DeviceStore = new List<Parametersrc>();
List<Parametersrc> EventTypeStore = new List<Parametersrc>();
_parasrcMgr = new ParameterMgr(mySqlConnectionString);
ProductFreightStore = _parasrcMgr.GetElementType("product_freight");//---deliver_type
DeviceStore = _parasrcMgr.GetElementType("device");//--device
EventTypeStore = _parasrcMgr.GetElementType("event_type");//--event_type
foreach (var item in store)
{
for (int i = 0; i < ProductFreightStore.Count; i++)
{
if (int.Parse(ProductFreightStore[i].ParameterCode) == item.freight_type)
{
item.freight = ProductFreightStore[i].parameterName;
}
}
for (int i = 0; i < DeviceStore.Count; i++)
{
if (DeviceStore[i].ParameterCode == item.device.ToString())
{
item.device_name = DeviceStore[i].parameterName;
}
}
for (int i = 0; i < EventTypeStore.Count; i++)
{
if (EventTypeStore[i].ParameterCode == item.event_type)
{
item.eventtype = EventTypeStore[i].parameterName;
}
}
if (item.sale_productid != 0)
{
item.sale_product_name = _prodMgr.QueryClassify(Convert.ToUInt32(item.sale_productid)).Product_Name;
}
if (item.event_img_small != "")
{
item.event_img_small = imgServerPath + promoPath + item.event_img_small;
}
else
{
item.event_img_small = defaultImg;
}
if (item.event_img != "")
{
item.event_img = imgServerPath + promoPath + item.event_img;
}
else
{
item.event_img = defaultImg;
}
if (item.product_img != "")
{
if (item.product_img.ToString().StartsWith("T1") || item.product_img.ToString().StartsWith("T2"))
{
item.product_img = imgServerPath + promoPath + item.product_img;
}
else
{
item.product_img = imgServerPath + prodPath + GetDetailFolder(item.product_img) + item.product_img;
}
}
else
{
item.product_img = defaultImg;
}
DataTable _dtCount = _ITrialRecordMgr.GetSumCount(item);
if (_dtCount.Rows.Count != 0)
{
if (_dtCount.Rows[0][1].ToString() != "")
{
item.recordCount = Convert.ToInt32(_dtCount.Rows[0][1].ToString());
};
if (_dtCount.Rows[0][2].ToString() != "")
{
item.shareCount = Convert.ToInt32(_dtCount.Rows[0][2].ToString());
}
}
}
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,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}