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