/// <summary>
/// 获取上架商品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public PagerList <MdmGoodsList> GetPutAwayGoodsList(GoodsInfoInputModel model)
{
return(_sqlQuery.Select(@"GL_ID as Id, GL_NO, GL_NAME, GL_PRINT_NAME, GL_TYPE, GL_LARGECLASS, GL_INCLASS, GL_SMALLCLASS, GL_SUBCLASS, GL_LEVEL, CAR_BRAND_ID, CAR_BRAND_DESC, CAR_CLASS_ID, CAR_CLASS_DESC, CAR_TYPE_ID, CAR_TYPE_DESC, GL_UNIT, MNEMONIC_CODE, GL_SPEC, GL_MODEL, GL_MATERIAL, GL_SHELFLIFE, MADE_IN, GL_STATUS, BU_NO, GL_RMK, GL_PROPERTY, COMMENT_NUM, HIT_NUM, PROMOTION_INFO, GL_DESC, GL_SPEC_DESC, GL_PACKAGE_DESC, GL_DESC_M, GL_SPEC_DESC_M, GL_PACKAGE_DESC_M, GL_WARRANTY_DESC, GL_PUR_ATTR, GL_QA, GL_BRAND, GL_FUNC, IS_COMBO, GOODS_ATTR, LGS_SP, LGS_SP_NO, GL_SDATE, GL_EDATE, UDF1, UDF2, UDF3, UDF4, UDF5, UDF6, UDF7, UDF8, UDF9, UDF10, CREATE_PSN, CREATE_DATE, UPDATE_PSN, UPDATE_DATE, CREATE_ORG_NO, DEL_FLAG, PROMOTION_ATTR, BG_NO, MEMBER_PRICE, MENBER_POINTS, ENABLE_MP, GOODS_SALES, IS_ERPGOODS")
.Filter("del_flag", 1)
.Filter("GL_STATUS", 1)
.Filter("IS_ERPGOODS", 1)
.Filter("BU_NO", AbpSession.ORG_NO)
.Contains("GL_NAME", model.goodsName)
.OrderBy("CREATE_DATE desc")
.GetPageList <MdmGoodsList>("mdm_goods_list", Context.Database.GetDbConnection(), model.iDisplayStart, model.iDisplayLength));
}
public ActionResult GetErpGoodsInfoList(GoodsInfoInputModel model)
{
try
{
var result = _mdmGoodsListService.GetGoodsInfoList(model);
return(Success("获取成功", result));
}
catch (Exception ex)
{
return(Fail("获取失败:" + ex.Message));
}
}
/// <summary>
/// 检查接口入参
/// </summary>
/// <param name="model"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public bool CheckParam(GoodsInfoInputModel model, out string errMsg)
{
bool flag = true;
errMsg = "";
int len;
if (model == null)
{
flag = false;
errMsg = "传入参数为空";
}
if (!int.TryParse(model.iDisplayStart + "", out len) || !int.TryParse(model.iDisplayLength + "", out len))
{
flag = false;
errMsg = "开始条数或分页长度类型不正确";
}
return(flag);
}
/// <summary>
/// 获取erp商品信息
/// </summary>
/// <param name="url"></param>
/// <param name="model"></param>
/// <returns></returns>
public string GetErpGoodsInfo(string url, GoodsInfoInputModel model)
{
var dic = new Dictionary <string, object>();
if (!string.IsNullOrEmpty(model.goodsName))
{
string[] arr = new string[] { "goodsName" };
dic.Add("fuzzyQueryFields", arr);
}
dic.Add("storeNo", model.storeNo);
dic.Add("iDisplayStart", model.iDisplayStart);
dic.Add("iDisplayLength", model.iDisplayLength);
dic.Add("goodsNo", model.goodsNo);
dic.Add("goodsName", model.goodsName);
dic.Add("goodsLargeClassCode", model.goodsLargeClassCode);
var json = JsonConvert.SerializeObject(dic);
return(HttpRequest.ErpRequestApi(json, "Goods/GetGoodsInfo", url, AbpSession.ORG_NO));
}
/// <summary>
/// 获取商品信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <GoodsInfoListModel> GetGoodsInfoList(GoodsInfoInputModel model)
{
if (!CheckParam(model, out string errMsg))
{
throw new Exception(errMsg);
}
//上架商品
if (model.goodStatus == "1")
{
List <GoodsInfoListModel> list = new List <GoodsInfoListModel>();
List <MdmGoodsList> goodsList = _mdmGoodsListRepository.GetPutAwayGoodsList(model).Data;
foreach (var good in goodsList)
{
list.Add(new GoodsInfoListModel()
{
GOODS_NO = good.GL_NO.ToString(),
GOODS_NAME = good.GL_NAME.ToString(),
GOODS_LARGECLASS_CODE = good.UDF3.ToString(),
GOODS_LARGECLASS_NAME = good.UDF4.ToString(),
GOODS_INCLASS_CODE = good.UDF5.ToString(),
GOODS_INCLASS_NAME = good.UDF6.ToString(),
GOODS_SMALLCLASS_CODE = good.UDF7.ToString(),
GOODS_SMALLCLASS_NAME = good.UDF8.ToString(),
UNIT = good.GL_UNIT + "",
RETAILPRICE = Convert.ToDecimal(string.IsNullOrEmpty(good.UDF9 + "") ? "0" : good.UDF9.ToString()),
MEMBERSHIP_PRICE = Convert.ToDecimal(string.IsNullOrEmpty(good.UDF10 + "") ? "0" : good.UDF10.ToString()),
Gl_Material = good.GL_MATERIAL + "",
Made_In = good.MADE_IN + "",
Gl_Rmk = good.GL_RMK + "",
Promotion_Info = good.PROMOTION_INFO + "",
Image_Url = string.IsNullOrEmpty(good.UDF2)?"":good.UDF2.ToString(),
Gl_Desc = good.GL_DESC,
Gl_Warranty_Desc = good.GL_WARRANTY_DESC,
Member_Price = Convert.ToDecimal(good.MEMBER_PRICE),
Member_Points = Convert.ToDecimal(good.MENBER_POINTS),
Enable_MP = Convert.ToDecimal(good.ENABLE_MP),
Goods_Sales = string.IsNullOrEmpty(good.GOODS_SALES + "") ? 0 : Convert.ToDecimal(good.GOODS_SALES),
GL_STATUS = Convert.ToDecimal(good.GL_STATUS),
GL_ID = good.Id.ToString()
});
}
return(list);
}
else
{
string url = "", msg = "";
if (!_wxHelper.GetErpApiUrl(AbpSession.BG_NO, ref url, ref msg, "new"))
{
throw new Exception(msg);
}
model.storeNo = AbpSession.ORG_NO;
string returnData = _mdmGoodsListRepository.GetErpGoodsInfo(url, model);
JObject jobj = (JObject)JsonConvert.DeserializeObject(returnData);
if (Convert.ToBoolean(jobj["IsSuccess"]))
{
string result = jobj["result"].ToString();
return(TransferGoodsModel(result));
}
else
{
throw new Exception("获取erp商品失败:" + jobj["msg"].ToString());
}
}
}
