public static List <ShipmentRequest> Get(int requestYear, int requestWeek, string code) { var db = ShipmentRequest.GetDatabase(); string sql = @" SELECT * FROM ShipmentRequests S WHERE S.ConstructionMaterialCode = '" + code + @"' AND S.ConstructionMaterialDetailCode = 1 AND S.Floor = 0 AND S.RequestYear = " + requestYear + @" AND S.RequestWeek = " + requestWeek; return(db.ExecuteQuery <ShipmentRequest>(sql)); }
public static List <ShipmentRequest> GetHEMS(int requestYear, int requestWeek) { //めんどくせえからCodeべたうちで。他にも必要になったら、Code指定できるメソッドつくれば? var db = ShipmentRequest.GetDatabase(); string sql = @" SELECT * FROM ShipmentRequests S WHERE S.ConstructionMaterialCode = 'HH' AND S.ConstructionMaterialDetailCode = 1 AND S.Floor = 0 AND S.RequestYear = " + requestYear + @" AND S.RequestWeek = " + requestWeek; return(db.ExecuteQuery <ShipmentRequest>(sql)); }
public static int?GetMaxWeek(int requestYear) { var db = ShipmentRequest.GetDatabase(); string sql = @" SELECT MAX(RequestWeek) FROM ShipmentRequests WHERE RequestYear = " + requestYear; var result = db.ExecuteScalar(sql); if (result == null) { return(null); } return(Convert.ToInt32(result)); }
public static List <ShipmentRequest> Get(int requestYear, int requestWeek, List <string> codes) { var s = string.Empty; codes.ForEach(p => s += "'" + p + "',"); s = s.Substring(0, s.Length - 1); var db = ShipmentRequest.GetDatabase(); string sql = @" SELECT * FROM ShipmentRequests S WHERE S.ConstructionMaterialCode IN (" + s + @") AND S.ConstructionMaterialDetailCode = 1 AND S.Floor = 0 AND S.RequestYear = " + requestYear + @" AND S.RequestWeek = " + requestWeek; return(db.ExecuteQuery <ShipmentRequest>(sql)); }
public static ShipmentRequest Get(string constructionCode, string requestCode) { var code = constructionCode.Replace("'", "''"); string sql = @" SELECT * FROM ShipmentRequests S WHERE S.ConstructionCode = '" + code + @"' AND S.ConstructionMaterialCode = '" + requestCode + @"' AND S.ConstructionMaterialDetailCode = 1 AND S.Floor = 0"; var db = ShipmentRequest.GetDatabase(); var requests = db.ExecuteQuery <ShipmentRequest>(sql); if (requests.Count == 0) { return(null); } return(requests[0]); }