## 【金蝶云星空】插件二开→通用工具类分享篇
### 根据单据类型及编号获取对应单据名称，代码即取即用：
```language c#
/// 根据单价类型及编号获取对应单据名称
/// billType 单据类型
/// billNo 单据编号
public static string GetBillTypeName(Context ctx, string billType, string billNo)
{
string erpBillTypeName = "";
string sql = string.Format($@"/*dialect*/
SELECT a.FNUMBER,a.FBILLFORMID,b.FNAME FROM
T_BAS_BILLTYPE a
INNER JOIN T_BAS_BILLTYPE_l b ON a.FBILLTYPEID= b.FBILLTYPEID
AND b.FLOCALEID = 2052
WHERE a.FBILLFORMID = '{billType}' and a.FNUMBER = '{billNo}'");
DynamicObjectCollection dynamicObjects = DBUtils.ExecuteDynamicObject(ctx, sql);
foreach (var item in dynamicObjects)
{
if (item["FNAME"] == null)
{
return erpBillTypeName;
}
erpBillTypeName = item["FNAME"].ToString();
}
return erpBillTypeName;
}
```
