public long DeleteRPoList(tblPoList item)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         database.Delete(item);
         return(item.id);
     }
 }
 public long UpdateConnectionURL(tblConnectionURL item)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         database.Update(item);
         return(item.id);
     }
 }
Example #3
0
 public static long UpdateBoxDetail(tblBoxDetail item)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         database.Update(item);
         return(item.id);
     }
 }
 public tblConnectionURL GetConnectionURL()
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblConnectionURL> ().SingleOrDefault());
     }
 }
Example #5
0
 public static long UserLogin(tblUser item)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         database.Update(item);
         return(item.id);
     }
 }
 public long UpdateRPoListDetail(tblPoListDetail item)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         database.Update(item);
         return(item.id);
     }
 }
 public tblPoListDetail[] ChkRPoListVariance(string receiver_num, string division_id)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblPoListDetail> ()
                .Where(t => t.receiver_num == receiver_num && t.division_id == division_id && t.oqty != t.rqty).ToArray());
     }
 }
 public tblPoListDetail[] UpdateRPoListDetail(string receiver_num, string division_id)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblPoListDetail> ()
                .Where(t => t.receiver_num == receiver_num && t.division_id == division_id).ToArray());
     }
 }
 public tblPoListDetail GetRPoUPC(string receiver_num, string division_id, string upc)
 {
     upc = upc.Substring(0, Convert.ToInt32(upc.Length - 1));
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblPoListDetail> ()
                .Where(t => t.receiver_num == receiver_num && t.division_id == division_id && t.upc == upc).SingleOrDefault());
     }
 }
Example #10
0
 public static tblPickingListDetail GetPTLUPC(string move_doc, string upc)
 {
     upc = upc.Substring(0, Convert.ToInt32(upc.Length - 1));
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblPickingListDetail> ()
                .Where(t => t.move_doc == move_doc && t.upc == upc).SingleOrDefault());
     }
 }
Example #11
0
 public static tblBox GetPBoxCode(string boxcode)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblBox> ()
                .Where(t => t.box_code == boxcode)
                .SingleOrDefault());
     }
 }
Example #12
0
 public static tblPoList ChkPoListExist(string receiver_num, string division)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblPoList> ()
                .Where(t => t.receiver_num == receiver_num && t.division == division)
                .SingleOrDefault());
     }
 }
Example #13
0
 public static tblBoxDetail ChkBoxDetailUPC(string box_code, string move_doc, string upc)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database
                .Table <tblBoxDetail> ()
                .Where(t => t.box_code == box_code && t.move_doc == move_doc && t.upc == upc)
                .SingleOrDefault());
     }
 }
Example #14
0
        public List <tblPickingList> GetPTLList(string po)
        {
            tblPickingList itemlist = new tblPickingList();

            using (var database = WMSDatabase.NewConnection())
            {
                return(database
                       .Table <tblPickingList>().ToList()
                       .Where(t => t.move_doc.Contains(po)).ToList());
            }
        }
Example #15
0
        public List <tblPoList> GetRPoList(string po)
        {
            tblPoList itemlist = new tblPoList();

            using (var database = WMSDatabase.NewConnection())
            {
                return(database
                       .Table <tblPoList>().ToList()
                       .Where(t => t.po_num.Contains(po)).ToList());
            }
        }
Example #16
0
        public static List <tblBox> GetBoxList()
        {
            tblBox itemlist = new tblBox();

            using (var database = WMSDatabase.NewConnection())
            {
                return(database
                       .Table <tblBox>()
                       .OrderByDescending(t => t.id)
                       .ToList());
            }
        }
Example #17
0
        public static List <tblPickingListDetail> GetPickingListDetail(string move_doc)
        {
            tblPickingListDetail itemlist = new tblPickingListDetail();

            using (var database = WMSDatabase.NewConnection())
            {
                return(database
                       .Table <tblPickingListDetail> ()
                       .Where(t => t.move_doc == move_doc)
                       .OrderBy(t => t.dept).ToList()
                       .OrderBy(t => t.status).ToList());
            }
        }
Example #18
0
        public List <tblPoListDetail> GetRPoListDetail(string receiver_num, string division_id)
        {
            tblPoListDetail itemlist = new tblPoListDetail();

            using (var database = WMSDatabase.NewConnection())
            {
                return(database
                       .Table <tblPoListDetail>().ToList()
                       .Where(t => t.receiver_num.Equals(receiver_num) && t.division_id.Equals(division_id)).ToList()
                       .OrderBy(t => t.upc).ToList()
                       .OrderByDescending(t => t.rqty).ToList()
                       .OrderBy(t => t.status).ToList());
            }
        }
Example #19
0
 public static long AddBoxDetail(string box_code, string move_doc, string upc, string rqty)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database.Insert
                    (new tblBoxDetail
         {
             box_code = box_code,
             move_doc = move_doc,
             upc = upc,
             rqty = rqty
         }
                    ));
     }
 }
Example #20
0
 public static long AddPBox(string box_code, string move_doc, string number, string total)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database.Insert
                    (new tblBox
         {
             box_code = box_code,
             move_doc = move_doc,
             number = number,
             total = total
         }
                    ));
     }
 }
Example #21
0
 public static long AddRPoList(string po_num, string receiver_num, string division_id, string division, string status)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database.Insert
                    (new tblPoList
         {
             po_num = po_num,
             receiver_num = receiver_num,
             division_id = division_id,
             division = division,
             slot_num = "",
             status = status
         }
                    ));
     }
 }
Example #22
0
 public static long AddRPoListDetail(string receiver_num, string division_id, string upc, string description, string oqty, string rqty, string status)
 {
     using (var database = WMSDatabase.NewConnection())
     {
         return(database.Insert
                    (new tblPoListDetail
         {
             receiver_num = receiver_num,
             division_id = division_id,
             upc = upc,
             description = description,
             oqty = oqty,
             rqty = rqty,
             status = status
         }
                    ));
     }
 }