コード例 #1
0
        public Int32 postSupplier()
        {
            try
            {
                Data.MstSupplier newSupplier = new Data.MstSupplier();
                newSupplier.Supplier        = "n/a";
                newSupplier.Address         = "n/a";
                newSupplier.TelephoneNumber = "n/a";
                newSupplier.CellphoneNumber = "n/a";
                newSupplier.FaxNumber       = "n/a";
                newSupplier.TermId          = TermId();
                newSupplier.TIN             = "n/a";
                newSupplier.AccountId       = AccountId();
                newSupplier.EntryUserId     = UserId();
                newSupplier.EntryDateTime   = DateTime.Today;
                newSupplier.UpdateUserId    = UserId();
                newSupplier.UpdateDateTime  = DateTime.Today;
                newSupplier.IsLocked        = false;
                db.MstSuppliers.InsertOnSubmit(newSupplier);
                db.SubmitChanges();

                return(newSupplier.Id);
            }
            catch (Exception e)
            {
                return(0);
            }
        }
コード例 #2
0
        public Int32 postSupplier(Entities.MstSupplier supplier)
        {
            try
            {
                var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id;

                var accounts = from d in db.MstAccounts
                               select d;

                var term = from d in db.MstTerms
                           select d;
                //var tax = from d in db.MstTaxes
                //          select d;

                //var unit = from d in db.MstUnits
                //           select d;

                //var supplier = from d in db.MstSuppliers
                //               select d;


                Data.MstSupplier newSupplier = new Data.MstSupplier();
                newSupplier.Supplier        = "n/a";
                newSupplier.Address         = "n/a";
                newSupplier.TelephoneNumber = "n/a";
                newSupplier.CellphoneNumber = "n/a";
                newSupplier.FaxNumber       = "n/a";
                newSupplier.TermId          = term.Select(m => m.Id).FirstOrDefault();
                newSupplier.TIN             = "n/a";
                newSupplier.AccountId       = accounts.Select(m => m.Id).FirstOrDefault();
                newSupplier.EntryUserId     = userId;
                newSupplier.EntryDateTime   = DateTime.Today;
                newSupplier.UpdateUserId    = userId;
                newSupplier.UpdateDateTime  = DateTime.Today;
                newSupplier.IsLocked        = false;
                db.MstSuppliers.InsertOnSubmit(newSupplier);
                db.SubmitChanges();

                return(newSupplier.Id);
            }
            catch (Exception e)
            {
                Debug.WriteLine(e);
                return(0);
            }
        }