public static void Delete(string constructionCode, string planNo, string revisionNo)
{
string sql = @"
DELETE FROM SekisanMaterials
WHERE
ConstructionCode = '" + constructionCode + @"' AND
PlanNo = '" + planNo + @"' AND
ShiyoushoNo = '" + revisionNo + @"' AND
SystemNo = " + SYSTEM_NO;
var db = SekisanMaterial.GetDatabase();
db.ExecuteNonQuery(sql);
}
public static List <SekisanMaterial> Get(string constructionCode, string planNo, string revisionNo)
{
var db = SekisanMaterial.GetDatabase();
var sql = @"
SELECT * FROM SekisanMaterials
WHERE
ConstructionCode = '" + constructionCode + @"' AND
PlanNo = '" + planNo + @"' AND
ShiyoushoNo = '" + revisionNo + @"' AND
SystemNo = " + SYSTEM_NO;
var materials = db.ExecuteQuery <SekisanMaterial>(sql);
return(materials);
}