public static List <OptionPickingItemsEx> Get(string constructionCode) { string sql = @" SELECT * FROM OptionPickingItemsEx WHERE ConstructionCode = '" + constructionCode + "'"; var db = OptionPickingItemsEx.GetDatabase(); return(db.ExecuteQuery <OptionPickingItemsEx>(sql)); }
public static void Update(List <OptionPickingItemsEx> items, string constructionCode) { OptionPickingItemsEx.Delete(constructionCode); var now = DateTime.Now; int seq = 1; foreach (var item in items) { item.Seq = seq; item.UpdatedDateTime = now; item.Store(); seq++; } }