public static void Delete(string constructionCode) { var sql = @"DELETE FROM RimokonNicheDetails WHERE ConstructionCode = '" + constructionCode + "'"; var db = RimokonNicheDetail.GetDatabase(); db.ExecuteNonQuery(sql); }
public static List <RimokonNicheDetail> Get(string constructionCode, int seqNo) { var sql = @" SELECT * FROM RimokonNicheDetails WHERE ConstructionCode = '" + constructionCode + @"' AND SeqNo = " + seqNo; var db = RimokonNicheDetail.GetDatabase(); return(db.ExecuteQuery <RimokonNicheDetail>(sql)); }