/// <summary> /// 同步远程产品信息 /// </summary> public static int SynErpProduct() { int reNo = 0; ProductsInfo pi = new ProductsInfo(); try { DataTable dt = Bdu9ErpDataEngineService.getProductList(""); foreach (DataRow dr in dt.Rows) { if (dr["P_NAME"].ToString().Trim() != "") { if (tbProductsInfo.ExistsProductsInfo(dr["P_NAME"].ToString().Trim()) == false) { pi.pStandard = ""; pi.pUnits = dr["p_rule_min"].ToString().Trim(); pi.pMaxUnits = dr["p_rule_max"].ToString().Trim(); pi.pToBoxNo = Utils.StrToInt(dr["p_rules"].ToString().Trim(), 0); pi.pState = 0; ProductClassInfo pci = DataClass.GetProductClassInfoModel(dr["typename"].ToString().Trim()); if (pci != null) { pi.ProductClassID = pci.ProductClassID; } pi.pBrand = dr["typename"].ToString().Trim(); pi.pPrice = decimal.Parse(Utils.StrToFloat(dr["a_price"].ToString().Trim(), 0).ToString()); pi.pCode = Utils.GetRanDomCode(); pi.pBarcode = dr["p_code"].ToString().Trim(); pi.pName = dr["p_name"].ToString().Trim(); pi.pAppendTime = DateTime.Now; tbProductsInfo.AddProductsInfo(pi); reNo++; } } } } finally { pi = null; } return(reNo); }
/// <summary> /// 获取erp中客户列表 /// </summary> public static DataTable GetStoresList() { return(Bdu9ErpDataEngineService.GetStoresList()); }
/// <summary> /// 获取产品单据列表 /// </summary> public static DataTable getERPProductOrderList(int ProduceID, int OrderType, DateTime bDate, DateTime eDate) { return(Bdu9ErpDataEngineService.getProductOrderList(ProduceID, OrderType, bDate, eDate)); }
/// <summary> /// 获取订单单据列表 /// </summary> public static DataTable GetOrderList(string OrderStr) { return(Bdu9ErpDataEngineService.GetOrderList(OrderStr)); }
/// <summary> /// 获取产品列表 /// </summary> public static DataTable getERPProductList(string tSQL) { return(Bdu9ErpDataEngineService.getProductList(tSQL)); }