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