public HttpResponseBase waitVerifyQuery()
{
//todo:供應商商品審核列表需要修改
List<BLL.gigade.Model.Custom.VenderProductListCustom> resultList = new List<BLL.gigade.Model.Custom.VenderProductListCustom>();
string result = "{success:false}";
try
{
uint brand_id;
uint category_id;
int combination;
int prev_status;
uint.TryParse(Request.Params["brand_id"] ?? "0", out brand_id);
uint.TryParse(Request.Params["category_id"] ?? "0", out category_id);
int.TryParse(Request.Params["combination"] ?? "0", out combination);
int.TryParse(Request.Params["prev_status"] ?? "0", out prev_status);
QueryVerifyCondition query = new QueryVerifyCondition()
{
product_status = 1,//待審核商品列表只查詢商品狀態為審請審核的
brand_id = brand_id,
combination = combination,
prev_status = prev_status,
date_type = Request.Params["date_type"],
name_number = Request.Params["key"],
Start = Convert.ToInt32(Request.Form["start"] ?? "0"),
Limit = Convert.ToInt32(Request.Form["limit"] ?? "25")
};
if (!string.IsNullOrEmpty(Request.Params["cate_id"]))
{
query.cate_id = Request.Params["cate_id"].Trim();
}
if (category_id != 2) //ROOT 表全选
{
query.category_id = category_id;
}
if (!string.IsNullOrEmpty(query.date_type))
{
if (query.date_type != "apply_time") //time 為整型
{
//change by shiwei0620j 20151217 將00:00:00和23:59:59改為 HH:mm:ss
query.time_start = CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy/MM/dd HH:mm:ss")).ToString();
query.time_end = CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy/MM/dd HH:mm:ss")).ToString();
}
else
{
query.time_start = Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy/MM/dd HH:mm:ss");
query.time_end = Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy/MM/dd HH:mm:ss");
}
}
_prodTempMgr = new ProductTempMgr(connectionString);
int totalCount = 0;
resultList = _prodTempMgr.verifyWaitQuery(query, out totalCount);
foreach (VenderProductListCustom item in resultList)
{
if (item.product_image != "")
{
item.product_image = imgServerPath + prod50Path + GetDetailFolder(item.product_image) + item.product_image;
}
else
{
item.product_image = defaultImg;
}
}
result = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(resultList) + "}";
}
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);
}
Response.Clear();
Response.Write(result);
Response.End();
return this.Response;
}