public DataTable QueryMTDOutWaferInfo(Models.WIPWaferInOutInput InfoInput)
{
string sMTD = "'" + InfoInput.sMTD + "'";
string sql = string.Format(sMTDOut, sMTD, sMTD, sMTD);
return(base.QueryDataTable(sql, "Summary", InfoInput.GetManualParams()));
}
public DataTable QueryMonOutWaferInfo(Models.WIPWaferInOutInput InfoInput)
{
string sStart = "'" + InfoInput.sMonthStart + "'";
string sEnd = "'" + InfoInput.sMonthEnd + "'";
string sql = string.Format(sMonOut, sStart, sEnd);
return(base.QueryDataTable(sql, "Summary", InfoInput.GetManualParams()));
}
public DataTable QueryMonInWaferInfo(Models.WIPWaferInOutInput InfoInput)
{
//string sStart = "'"+ InfoInput.sMonthStart + "01 000001'";
//string sEnd = "'" + DateTime.ParseExact(InfoInput.sMonthEnd, "yyyyMM", System.Globalization.CultureInfo.CurrentCulture).AddMonths(1).AddDays(-1).ToString("yyyyMMdd") + " 235959'";
string sStart = "'" + InfoInput.sMonthStart + "'";
string sEnd = "'" + InfoInput.sMonthEnd + "'";
string sql = string.Format(sMonIn, sStart, sEnd);
return(base.QueryDataTable(sql, "Summary", InfoInput.GetManualParams()));
}
