public ActionResult QueryItemId()///add by wwei0216w 2015/8/12 { string itemIdStr = ""; string requestProduct_id = Request["product_id"]; int product_id = requestProduct_id == null ? 0 : Convert.ToInt32(requestProduct_id); List<ProductItem> productItem_list = new List<ProductItem>(); try { IProductItemImplMgr _productItemMgr = new ProductItemMgr(connectionString); productItem_list = _productItemMgr.GetProductItemByID(product_id); if (productItem_list.Count == 0) return Json(new { itemIds = itemIdStr}); foreach (ProductItem pi in productItem_list) { itemIdStr += pi.Item_Id + ","; } itemIdStr = itemIdStr.Remove(itemIdStr.ToString().Length - 1, 1); return Json(new { itemIds = itemIdStr}); } 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); return new EmptyResult(); } }
public HttpResponseBase GetProductName() { ProductItemQuery pItem = new ProductItemQuery(); if (!string.IsNullOrEmpty(Request.Params["item_id"])) { pItem.Item_Id = uint.Parse(Request.Params["item_id"]); } productItemMgr = new ProductItemMgr(mySqlConnectionString); string jsonStr = string.Empty; try { List<ProductItemQuery> ItemList = new List<ProductItemQuery>(); ItemList = productItemMgr.GetProductItemByID(pItem); if (ItemList.Count > 0) { jsonStr = "{success:true,msg:\"[" + ItemList[0].Product_Id + "]" + ItemList[0].Remark +" "+ ItemList[0].Spec_Name_1 + ItemList[0].Spec_Name_2 + "\",product_id:\"" + ItemList[0].Product_Id + "\"}"; } else { jsonStr = "{success:true,msg:\"" + 100 + "\"}"; } } 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); jsonStr = "{success:false}"; } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }