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