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);
}
public static void Update(SekisanMaterial material)
{
var now = DateTime.Now;
SekisanMaterialDetail.Delete(material.ConstructionCode, material.PlanNo, material.ShiyoushoNo);
SekisanMaterial.Delete(material.ConstructionCode, material.PlanNo, material.ShiyoushoNo);
if (material.Details.Count == 0)
{
return;
}
material.UpdatedDate = now;
material.StoreSimple();
foreach (var detail in material.Details)
{
detail.UpdatedDate = now;
detail.StoreSimple();
}
}
