/// <summary>
/// 根据银行账号ID获取银行账号编码
/// </summary>
/// <param name="ctx"></param>
/// <param name="bankAccountId"></param>
/// <returns></returns>
public static string GetBankAccountNo(Context ctx, string bankAccountId)
{
if (!string.IsNullOrWhiteSpace(bankAccountId))
{
string sql = string.Format(@"/*dialect*/ select FNUMBER from T_CN_BANKACNT where FBANKACNTID = {0} and FUSEORGID = {1}", bankAccountId, ORGID);
return(string.IsNullOrWhiteSpace(JsonUtils.ConvertObjectToString(GetObject(ctx, sql, "FNUMBER"))) ? "" : JsonUtils.ConvertObjectToString(GetObject(ctx, sql, "FNUMBER")));
}
return("");
}
/// <summary>
/// 根据仓库ID获取仓库编码
/// </summary>
/// <param name="ctx"></param>
/// <param name="materialNo"></param>
/// <returns></returns>
public static string GetStockNo(Context ctx, int stockId)
{
string sql = string.Format(@"/*dialect*/select FNUMBER from T_BD_STOCK where FSTOCKID = {0}", stockId);
return(JsonUtils.ConvertObjectToString(GetObject(ctx, sql, "FNUMBER")));
}
/// <summary>
/// 根据组织ID获取组织编码
/// </summary>
/// <param name="ctx"></param>
/// <param name="orgId"></param>
/// <returns></returns>
public static string GetOrgNo(Context ctx, int orgId)
{
string sOrgId = string.Format(@"/*dialect*/ select FNUMBER From T_ORG_ORGANIZATIONS where FORGID= {0} ", orgId);
return(JsonUtils.ConvertObjectToString(GetObject(ctx, sOrgId, "FNUMBER")));
}
/// <summary>
/// 根据客户ID获取客户编码
/// </summary>
/// <param name="ctx"></param>
/// <param name="fieldValue"></param>
/// <returns></returns>
public static string GetCustomerNo(Context ctx, int fieldValue)
{
string sCustNo = string.Format(@"/*dialect*/ select FNUMBER from T_BD_CUSTOMER where FCUSTID = {0}", fieldValue);
return(JsonUtils.ConvertObjectToString(GetObject(ctx, sCustNo, "FNumber")));
}
