public static void Delete(string constructionCode)
        {
            string sql = @"
                DELETE FROM OptionPickingItemsEx
                WHERE
                    ConstructionCode = '" + constructionCode + "'";

            var db = OptionPickingItem.GetDatabase();

            db.ExecuteNonQuery(sql);
        }
예제 #2
0
        public static void Update(List <OptionPickingItem> items, string constructionCode)
        {
            OptionPickingItem.Delete(constructionCode);

            var now = DateTime.Now;
            int seq = 1;

            foreach (var item in items)
            {
                item.Seq             = seq;
                item.UpdatedDateTime = now;

                item.Store();

                seq++;
            }
        }