//根據upcid獲取item_id public HttpResponseBase GetItemidByUpcid() { string json = string.Empty; _IiupcMgr = new IupcMgr(mySqlConnectionString); _iproductitemMgr = new ProductItemMgr(mySqlConnectionString); Iupc m = new Iupc(); DataTable dt = new DataTable(); bool isUpc = true; try { //獲取條碼 if (!string.IsNullOrEmpty(Request.Params["upc_id"])) { m.upc_id = Request.Params["upc_id"].ToString().Trim(); //6位整數時先判斷輸入的是否為item_id Regex reg = new Regex("^\\d{6}$"); if (reg.IsMatch(m.upc_id)) { ProductItemQuery query = new ProductItemQuery(); query.Item_Id = Convert.ToUInt32(m.upc_id); List<ProductItemQuery> store = _iproductitemMgr.GetProductItemByID(query); if (store.Count == 0) { isUpc = true; } else if (store.Count > 1) { isUpc = true; } else { json = "{success:true,msg:1,itemid:" + query.Item_Id + "}"; isUpc = false; } } if (isUpc) { dt = _IiupcMgr.upcid(m); if (dt.Rows.Count == 0) { json = "{success:false,msg:0}"; } else if (dt.Rows.Count > 1) { json = "{success:false,msg:2}"; } else { json = "{success:true,msg:1,itemid:" + dt.Rows[0]["item_id"].ToString() + "}"; } } } } 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 BrowseDataList() { string json = string.Empty; DataTable dtBrowseData = new DataTable(); int totalCount = 0; BrowseDataQuery query = new BrowseDataQuery(); string type=Request.Params["type"]; string searchContent = Request.Params["searchContent"]; if (!string.IsNullOrEmpty(type)) { query.type = Convert.ToInt32(type); } if (!string.IsNullOrEmpty(searchContent)) { query.SearchCondition = searchContent; } if (!string.IsNullOrEmpty(Request.Params["true"])) { if (Request.Params["true"] == "true") { query.isSecret = true; } else { query.isSecret = false; } } if (!string.IsNullOrEmpty(Request.Params["searchType"])) { query.SearchType = Convert.ToInt32(Request.Params["searchType"]); } query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); _IBrowseDataMgr = new BrowseDataMgr(mySqlConnectionString); _IProductItemMgr=new ProductItemMgr(mySqlConnectionString); _IOrderMasterMgr = new OrderMasterMgr(mySqlConnectionString); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; try { dtBrowseData = _IBrowseDataMgr.GetBrowseDataList(query, out totalCount); if (dtBrowseData.Rows.Count>0) { dtBrowseData.Columns.Add("buyCount"); for (int i = 0; i < dtBrowseData.Rows.Count; i++) { string user_id = dtBrowseData.Rows[i]["user_id"].ToString(); string product_id = dtBrowseData.Rows[i]["product_id"].ToString(); string item_id = string.Empty; if (query.isSecret) { dtBrowseData.Rows[i]["user_name"] = dtBrowseData.Rows[i]["user_name"].ToString().Substring(0, 1) + "**"; } List<ProductItem> listProductItem = _IProductItemMgr.GetProductItemByID(Convert.ToInt32(product_id)); if (listProductItem.Count > 0) { item_id = listProductItem[0].Item_Id.ToString(); } OrderMasterQuery orderMasterQuery = new OrderMasterQuery { User_Id = Convert.ToUInt32(dtBrowseData.Rows[i]["user_id"]), Item_Id = Convert.ToInt32(item_id) }; dtBrowseData.Rows[i]["buyCount"] = _IOrderMasterMgr.GetBuyCount(orderMasterQuery); } json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(dtBrowseData, Formatting.Indented, timeConverter) + "}"; } else { json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(dtBrowseData, Formatting.Indented, timeConverter) + "}"; //json = "{success:false,msg:0}"; } } 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,msg:0}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }