public HttpResponseBase QueryProList(string priceMasterIds)
{
string json = string.Empty;
try
{
_prodMgr = new ProductMgr(connectionString);
int totalCount = 0;
List<QueryandVerifyCustom> pros = _prodMgr.QueryByProSite(priceMasterIds);
totalCount = pros.Count;
json = new JObject(
new JProperty("succes", true),
new JProperty("totalCount", totalCount),
new JProperty("item", new JArray(
from p in pros
select new JObject(
new JProperty("price_master_id", p.price_master_id),
new JProperty("product_image", p.product_image != "" ? (imgServerPath + prod50Path + GetDetailFolder(p.product_image) + p.product_image) : defaultImg),
new JProperty("product_id", p.product_id),
new JProperty("brand_name", p.brand_name),
new JProperty("product_name", p.product_name),
new JProperty("prod_sz", p.prod_sz),
new JProperty("combination", p.combination),
new JProperty("combination_id", p.combination_id),
new JProperty("price_type", p.price_type),
new JProperty("price_type_id", p.price_type_id),
new JProperty("product_status", p.product_status),
new JProperty("site_name", p.site_name),
new JProperty("user_level", p.user_level),
new JProperty("price", p.price),
new JProperty("cost", p.cost),
new JProperty("event_price", p.event_price),
new JProperty("event_cost", p.event_cost),
new JProperty("event_start", CommonFunction.GetNetTime(p.event_start).ToString("yyyy/MM/dd HH:mm:ss")),
new JProperty("event_end", CommonFunction.GetNetTime(p.event_end).ToString("yyyy/MM/dd HH:mm:ss")),
new JProperty("prepaid", p.prepaid)
)))
).ToString();
// json = "{succes:true,totalCount:" + totalCount + ",item:" + JsonConvert.SerializeObject(pros) + "}";
}
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 = "{succes:true,totalCount:0,item:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase QueryProList()
{
string json = string.Empty;
try
{
QueryVerifyCondition query = new QueryVerifyCondition();
#region 查询条件填充
query.IsPage = true;
query.Start = int.Parse(Request.Form["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Form["limit"]))
{
query.Limit = Convert.ToInt32(Request.Form["limit"]);
}
query.price_check = (Request.Form["price_check"] ?? "") == "true";
if (!string.IsNullOrEmpty(Request.Form["brand_id"]))
{
query.brand_id = uint.Parse(Request.Form["brand_id"]);
}
//庫存類型
if (!string.IsNullOrEmpty(Request.Form["stockStatus"]))
{
query.StockStatus = int.Parse(Request.Form["stockStatus"]);
}
if (!string.IsNullOrEmpty(Request.Form["comboProCate_hide"]))
{
query.cate_id = Request.Form["comboProCate_hide"].Trim();
}
if (!string.IsNullOrEmpty(Request.Form["comboFrontCage_hide"]))
{
query.category_id = uint.Parse(Request.Form["comboFrontCage_hide"]);
query.category_id = query.category_id == 2 ? 0 : query.category_id;
}
if (!string.IsNullOrEmpty(Request.Form["combination"]))
{
query.combination = int.Parse(Request.Form["combination"]);
}
if (!string.IsNullOrEmpty(Request.Form["outofstock_time_days"]))//add by dongya 2015/10/22
{
query.outofstock_days_stopselling = int.Parse(Request.Form["outofstock_time_days"]);
}
if (!string.IsNullOrEmpty(Request.Form["product_status"]))
{
query.product_status = int.Parse(Request.Form["product_status"]);
}
if (!string.IsNullOrEmpty(Request.Form["product_type"]))//add 2015/06/01
{
query.product_type = int.Parse(Request.Form["product_type"]);
}
if (!string.IsNullOrEmpty(Request.Form["product_freight_set"]))
{
query.freight = uint.Parse(Request.Form["product_freight_set"]);
}
if (!string.IsNullOrEmpty(Request.Form["product_mode"]))
{
query.mode = uint.Parse(Request.Form["product_mode"]);
}
if (!string.IsNullOrEmpty(Request.Form["tax_type"]))
{
query.tax_type = uint.Parse(Request.Form["tax_type"]);
}
query.date_type = Request.Form["date_type"] ?? "";
if (!string.IsNullOrEmpty(Request.Form["time_start"]))
{
query.time_start = CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Form["time_start"]).ToString("yyyy/MM/dd HH:mm:ss")).ToString();
}
if (!string.IsNullOrEmpty(Request.Form["time_end"]))
{
query.time_end = CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Form["time_end"]).ToString("yyyy/MM/dd HH:mm:ss")).ToString();
}
query.name_number = Request.Form["key"] ?? "";
if (query.price_check)
{
if (!string.IsNullOrEmpty(Request.Form["site_id"]))
{
query.site_id = uint.Parse(Request.Form["site_id"]);
}
if (!string.IsNullOrEmpty(Request.Form["user_level"]))
{
query.user_level = uint.Parse(Request.Form["user_level"]);
}
if (!string.IsNullOrEmpty(Request.Form["price_status"]))
{
query.price_status = uint.Parse(Request.Form["price_status"]);
}
}
//增加查詢值 按鈕選中 add by zhuoqin0830w 2015/02/10
if (!string.IsNullOrEmpty(Request.Form["priceCondition"]))
{
query.priceCondition = int.Parse(Request.Form["priceCondition"]);
}
//add by zhuoqin0830w 2015/03/11 已買斷商品的篩選功能
if (!string.IsNullOrEmpty(Request.Form["productPrepaid"]))
{
query.Prepaid = int.Parse(Request.Form["productPrepaid"]);
}
//add by zhuoqin0830w 2015/06/30 失格商品篩選
if (!string.IsNullOrEmpty(Request.Form["off_grade"]))
{
query.off_grade = int.Parse(Request.Form["off_grade"]);
}
//add by guodong1130w 2015/09/16 預購商品篩選
if (!string.IsNullOrEmpty(Request.Form["purchase_in_advance"]))
{
query.purchase_in_advance = int.Parse(Request.Form["purchase_in_advance"]);
}
#endregion
_prodMgr = new ProductMgr(connectionString);
int totalCount = 0;
List<QueryandVerifyCustom> pros = _prodMgr.QueryByProSite(query, out totalCount);
foreach (var item in pros)
{
if ((item.product_image != "" && item.product_image!="-1"))
{
item.product_image = imgServerPath + prod50Path + GetDetailFolder(item.product_image) + item.product_image;
}
else
{
item.product_image = defaultImg;
}
}
json = "{succes:true,totalCount:" + totalCount + ",item:" + JsonConvert.SerializeObject(pros) + "}";
}
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 = "{succes:true,totalCount:0,item:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
