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