public static void Delete(string constructionCode)
{
string sql = @"
DELETE FROM XGWSettingReportLogs
WHERE
ConstructionCode = '" + constructionCode + @"'";
var db = XGWSettingReportLog.GetDatabase();
db.ExecuteNonQuery(sql);
}
public static List <XGWSettingReportLog> GetBeforeConstructionCodesforDistinct(int year, int week, List <string> constructionCodes)
{
var s = string.Empty;
constructionCodes.ForEach(p => s += "'" + p + "',");
s = s.Substring(0, s.Length - 1);
string sql = @"
SELECT DISTINCT ConstructionCode
FROM XGWSettingReportLogs
WHERE (" + (year - 1) + @"<= Year AND " + week + @" <= Week) AND Year < '" + year + @"'
OR ( Year = '" + year + @"' AND Week < '" + week + @"')
AND ConstructionCode IN (" + s + @")";
var db = XGWSettingReportLog.GetDatabase();
return(db.ExecuteQuery <XGWSettingReportLog>(sql));
}