/// <summary> /// 获取B2B客户DropShipOrderPrefix订单前缀 /// </summary> /// <param name="ctx"></param> /// <returns></returns> public static string GetAUB2BDropShipOrderPrefix(Context ctx) { string sql = string.Format(@"/*dialect*/ select F_HS_DROPSHIPORDERPREFIX from T_BD_CUSTOMER where FNUMBER = '{0}' and FUSEORGID = 100035" , DataBaseConst.Param_AUB2B_customerID); return(JsonUtils.ConvertObjectToString(SQLUtils.GetObject(ctx, sql, "F_HS_DROPSHIPORDERPREFIX"))); }
/// <summary> /// 获取信用余额 /// </summary> /// <param name="ctx"></param> /// <param name="custNo"></param> /// <returns></returns> public static decimal GetCustCreditLine(Context ctx, string custNo, string fieldName) { if (!string.IsNullOrWhiteSpace(custNo) && !string.IsNullOrWhiteSpace(fieldName)) { string sql = string.Format(@"/*dialect*/ select {0} from T_BD_CUSTOMER a inner join T_ORG_ORGANIZATIONS b on a.FUSEORGID = b.FORGID where a.FNUMBER = '{1}' and b.FNUMBER = '100.01'", fieldName, custNo); decimal credit = Convert.ToDecimal(JsonUtils.ConvertObjectToString(SQLUtils.GetObject(ctx, sql, fieldName))); return(Math.Round(credit, 2)); } return(0); }
/// <summary> /// 获取客户结余 /// </summary> /// <param name="ctx"></param> /// <param name="custNo"></param> /// <param name="orgNo"></param> /// <returns></returns> public static decimal GetCustBalance(Context ctx, string custNo, string orgNo) { if (!string.IsNullOrWhiteSpace(custNo) && !string.IsNullOrWhiteSpace(orgNo)) { string sql = string.Format(@"/*dialect*/ select {0} from T_BD_CUSTOMER a inner join T_ORG_ORGANIZATIONS b on a.FUSEORGID = b.FORGID where a.FNUMBER = '{1}' and b.FNUMBER = '{2}'", orgNo.CompareTo("100.03") == 0 ? "F_HS_CNYBalance" : "F_HS_USDBalance", custNo, orgNo); decimal balance = Convert.ToDecimal(JsonUtils.ConvertObjectToString(SQLUtils.GetObject(ctx, sql, string.Format("{0}", orgNo.CompareTo("100.03") == 0 ? "F_HS_CNYBalance" : "F_HS_USDBalance")))); return(Math.Round(balance, 2)); } return(0); }
/// <summary> /// 获取客户Dropship平台 /// </summary> /// <param name="ctx"></param> /// <param name="custNo"></param> /// <returns></returns> public static string GetDropshipPlatform(Context ctx, string custNo) { if (!string.IsNullOrWhiteSpace(custNo)) { string sql = string.Format(@"/*dialect*/ select c.FNUMBER from T_BD_CUSTOMER a inner join T_BAS_ASSISTANTDATAENTRY_L b on a.F_HS_DropshipPlatform = b.FENTRYID inner join T_BAS_ASSISTANTDATAENTRY c on c.FENTRYID = b.FENTRYID where a.FNUMBER = '{0}' and a.FUSEORGID = 100035" , custNo); return(JsonUtils.ConvertObjectToString(SQLUtils.GetObject(ctx, sql, "FNUMBER"))); } return(string.Empty); }
/// <summary> /// 根据仓库编码获取仓库HS名称 /// </summary> /// <param name="ctx"></param> /// <param name="stockNo"></param> /// <returns></returns> private static string GetStockName(Context ctx, string stockNo) { string stockName = string.Empty; if (!string.IsNullOrWhiteSpace(stockNo)) { string sql = string.Format(@"/*dialect*/ select F_HS_STOCKHSNAME from T_BD_STOCK a inner join HS_t_Cust_EntryMaterial b on a.FSTOCKID = b.F_HS_DROPSHIPSTOCKID inner join T_BD_CUSTOMER c on c.FCUSTID = b.FCUSTID where a.FNUMBER='{0}'" , stockNo); stockName = JsonUtils.ConvertObjectToString(SQLUtils.GetObject(ctx, sql, "F_HS_STOCKHSNAME")); } return(stockName); }
/// <summary> /// 根据仓库地理仓编码获取仓库的编码 /// </summary> /// <param name="ctx"></param> /// <param name="stockCode">仓库编码或地理仓编码</param> /// <param name="flag">true:查询仓库编码,false:查询仓库地理仓编码</param> /// <returns></returns> public static string GetStockNo(Context ctx, string stockCode, bool flag = true) { string stockNo = string.Empty; if (!string.IsNullOrWhiteSpace(stockCode)) { string sql = string.Format(@"/*dialect*/ select {0} from T_BD_STOCK a inner join HS_t_DropShipStockEntity b on a.FSTOCKID = b.F_HS_DROPSHIPSTOCK inner join T_BD_CUSTOMER c on c.FCUSTID = b.FCUSTID inner join T_BAS_ASSISTANTDATAENTRY_L d on a.F_HS_DLC = d.FENTRYID inner join T_BAS_ASSISTANTDATAENTRY e on d.FENTRYID = e.FENTRYID where {1}='{2}' and c.FUSEORGID = 100035", flag ? "a.FNUMBER" : "e.FNUMBER", flag ? "e.FNUMBER" : "a.FNUMBER", stockCode); stockNo = JsonUtils.ConvertObjectToString(SQLUtils.GetObject(ctx, sql, "FNUMBER")); } return(stockNo); }