public DataTable GetTable(string yearMonth, SelectType selectType)
{
string strSql = " select a.挂账年月, a.供应商简码, b.ProviderName as 供应商名称, a.状态 as 单据状态 " +
" from (select a.YearMonth as 挂账年月, a.Provider as 供应商简码, " +
" case when a.AuditTime is null then '待审核' " +
" when a.RecheckTime is null then '待复核' " +
" when a.LastPrintTime is not null then '已打印' " +
" else '可打印' end as '状态' from Bus_PurchasingMG_Account as a " +
" where GoodsID = (select MIN(GoodsID) from Bus_PurchasingMG_Account as b " +
" where a.Provider = b.Provider and a.YearMonth = b.YearMonth and b.YGCount <> 0)) as a " +
" inner join Provider as b on a.供应商简码 = b.ProviderCode where a.挂账年月 = '" + yearMonth + "'";
if (selectType != SelectType.全部)
{
strSql += " and a.状态 = '" + selectType.ToString() + "'";
}
return(GlobalObject.DatabaseServer.QueryInfo(strSql));
}
public override string ToString()
{
return($"{ToolType.ToString()}|{CaliperNum}&{Polarity.ToString()}&{SelectType.ToString()}&{Contrast}&{ModelName}|{HalconData}");
}
internal static XAttribute Type(SelectType type)
{
return(new XAttribute("type", type.ToString()));
}
