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