public HttpResponseBase replaceVerifyQuery()
{
List<QueryandVerifyCustom> resultList = new List<QueryandVerifyCustom>();
string result = "{success:false}";
try
{
JavaScriptSerializer jsSer = new JavaScriptSerializer();
int startPage = Convert.ToInt32(Request.Form["start"] ?? "0");
int endPage = Convert.ToInt32(Request.Form["limit"] ?? "10");
QueryVerifyCondition query = new QueryVerifyCondition();
if (!string.IsNullOrEmpty(Request.Params["queryCondition"]))
{
query = jsSer.Deserialize<QueryVerifyCondition>(Request.Params["queryCondition"]);
if (query.category_id == 2) //Root表示全選
{
query.category_id = 0;
}
}
if (!string.IsNullOrEmpty(Request.Params["time_start"]))
{
query.time_start = CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["time_start"]).ToString("yyyy/MM/dd 00:00:00")).ToString();
}
if (!string.IsNullOrEmpty(Request.Params["time_end"]))
{
query.time_end = CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["time_end"]).ToString("yyyy/MM/dd 23:59:59")).ToString();
}
query.Start = startPage;
query.Limit = endPage;
_productMgr = new ProductMgr(connectionString);
int totalCount = 0;
resultList = _productMgr.verifyWaitQuery(query, out totalCount);
foreach (QueryandVerifyCustom 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;
}
public HttpResponseBase waitVerifyQuery()
{
List<QueryandVerifyCustom> resultList = new List<QueryandVerifyCustom>();
string result = "{success:false}";
try
{
uint brand_id, category_id;
int combination, 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();
query.product_status = 1; //待審核商品列表只查詢商品狀態為審請審核的
query.brand_id = brand_id;
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;
}
query.combination = combination;
query.prev_status = prev_status;
query.date_type = Request.Params["date_type"];
query.name_number = Request.Params["key"];
query.Start = Convert.ToInt32(Request.Form["start"] ?? "0");
query.Limit = Convert.ToInt32(Request.Form["limit"] ?? "25");
if (!string.IsNullOrEmpty(query.date_type))
{
if (query.date_type != "apply_time") //time 為整型
{
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");
}
}
_prodMgr = new ProductMgr(connectionString);
int totalCount = 0;
resultList = _prodMgr.verifyWaitQuery(query, out totalCount);
foreach (QueryandVerifyCustom 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;
}