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; }