Beispiel #1
0
        private bool insPosUL()
        {
            bool bl = false;

            try
            {
                var result = cmd.PV_POS_ULs.ToList();

                foreach (var item in result)
                {
                    POS_UL ul = new POS_UL();
                    ul.WH_ID    = item.WH_ID;
                    ul.ABBNO    = item.ABBNO;
                    ul.PTDATE   = item.PTDATE;
                    ul.WORKDATE = item.WORKDATE;
                    ul.TMCODE   = item.TMCODE;
                    ul.UFLAG    = "N";

                    sup.POS_ULs.InsertOnSubmit(ul);
                    sup.SubmitChanges();
                }
                bl = true;
            }
            catch (Exception ex)
            {
                bl = false;
                MessageBox.Show(ex.Message + "pro3");
            }
            return(bl);
        }
Beispiel #2
0
        private bool getABBNO()
        {
            bool bl = false;

            try
            {
                var result = cmd.PV_POS_ULs.ToList();

                foreach (var item in result)
                {
                    POS_UL ul = new POS_UL();
                    ul.WH_ID    = item.WH_ID;
                    ul.ABBNO    = item.ABBNO;
                    ul.PTDATE   = item.PTDATE;
                    ul.WORKDATE = item.WORKDATE;
                    ul.TMCODE   = item.TMCODE;
                    ul.UFLAG    = "N";

                    sup.POS_ULs.InsertOnSubmit(ul);
                    sup.SubmitChanges();
                }


                //var bill_rs = sup.POS_ULs.Where(s => s.UFLAG == "N" &&( s.ABBNO == "10789" ) ).ToList();
                //var bill_rs = sup.POS_ULs.Where(s => s.UFLAG == "N" ).Take(1).ToList();
                var bill_rs = sup.POS_ULs.Where(s => s.UFLAG == "N").ToList();

                foreach (var item in bill_rs)
                {
                    getList(item.WH_ID, item.TMCODE, item.WORKDATE, item.ABBNO);
                }


                bl = true;
            }
            catch (Exception ex)
            {
                sms = ex.Message + "TEST2";
                bl  = false;
            }

            return(bl);
        }
 partial void UpdatePOS_UL(POS_UL instance);
 partial void DeletePOS_UL(POS_UL instance);
 partial void InsertPOS_UL(POS_UL instance);