public static ControlIssuesAccountModel FindSecurityCode(int securityCode)
        {
            var @SecurityCode        = new SqlParameter("@SecurityCode", securityCode);
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <ControlIssuesAccountModel>("EXEC spm_CheckControlIssuesAccount @SecurityCode", @SecurityCode).FirstOrDefault());
        }
예제 #2
0
        public static bool Insert(OutputingModel model)
        {
            var @ProductNo         = new SqlParameter("@ProductNo", model.ProductNo);
            var @Barcode           = new SqlParameter("@Barcode", model.Barcode);
            var @SizeNo            = new SqlParameter("@SizeNo", model.SizeNo);
            var @CartonNo          = new SqlParameter("@CartonNo", model.CartonNo);
            var @GrossWeight       = new SqlParameter("@GrossWeight", model.GrossWeight);
            var @ActualWeight      = new SqlParameter("@ActualWeight", model.ActualWeight);
            var @DifferencePercent = new SqlParameter("@DifferencePercent", model.DifferencePercent);
            var @IsPass            = new SqlParameter("@IsPass", model.IsPass);
            var @WorkerId          = new SqlParameter("@WorkerId", model.WorkerId);
            var @IssuesId          = new SqlParameter("@IssuesId", model.IssuesId);

            StoringSystemEntities db = new StoringSystemEntities();

            if (db.ExecuteStoreCommand("EXEC spm_InsertOutputing @ProductNo, @Barcode, @SizeNo, @CartonNo, @GrossWeight, @ActualWeight, @DifferencePercent, @IsPass, @WorkerId, @IssuesId",
                                       @ProductNo, @Barcode, @SizeNo, @CartonNo, @GrossWeight, @ActualWeight, @DifferencePercent, @IsPass, @WorkerId, @IssuesId) >= 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #3
0
        public static List <OutputingModel> SelectPerPO(string productNo)
        {
            var @ProductNo           = new SqlParameter("@ProductNo", productNo);
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <OutputingModel>("EXEC spm_SelectOutputingPerPO @ProductNo", @ProductNo).ToList());
        }
예제 #4
0
        public static StoringModel SelectByBarcode(string barcode)
        {
            var @Barcode             = new SqlParameter("@Barcode", barcode);
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <StoringModel>("EXEC spm_SelectStoringPerBarcode @Barcode", @Barcode).FirstOrDefault());
        }
예제 #5
0
        public static AccountModel Select(string userName, string password)
        {
            var @UserName            = new SqlParameter("@UserName", userName);
            var @Password            = new SqlParameter("@Password", password);
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <AccountModel>("EXEC spm_CheckAccount @UserName,@Password", @UserName, @Password).FirstOrDefault());
        }
예제 #6
0
        public static bool Exist()
        {
            StoringSystemEntities db = new StoringSystemEntities();

            if (db.DatabaseExists() == true)
            {
                return(true);
            }
            return(false);
        }
예제 #7
0
        public static List <StoringModel> SelectByDate(DateTime today, string workerId)
        {
            var @Day                 = new SqlParameter("@Day", today.Day);
            var @Month               = new SqlParameter("@Month", today.Month);
            var @Year                = new SqlParameter("@Year", today.Year);
            var @WorkerId            = new SqlParameter("@WorkerId", workerId);
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <StoringModel>("EXEC spm_SelectStoringByDate @Day, @Month, @Year, @WorkerID", @Day, @Month, @Year, @WorkerId).ToList());
        }
        public static bool Insert(IssuesDetailModel model)
        {
            var @ProductNo           = new SqlParameter("@ProductNo", model.ProductNo);
            var @Barcode             = new SqlParameter("@Barcode", model.Barcode);
            var @CartonNo            = new SqlParameter("@CartonNo", model.CartonNo);
            var @SizeNo              = new SqlParameter("@SizeNo", model.SizeNo);
            var @IssuesId            = new SqlParameter("@IssuesId", model.IssuesId);
            var @GrossWeight         = new SqlParameter("@GrossWeight", model.GrossWeight);
            var @ActualWeight        = new SqlParameter("@ActualWeight", model.ActualWeight);
            var @DifferencePercent   = new SqlParameter("@DifferencePercent", model.DifferencePercent);
            var @Process             = new SqlParameter("@Process", model.Process);
            var @CheckBy             = new SqlParameter("@CheckBy", model.CheckBy);
            var @Location            = new SqlParameter("@Location", model.Location);
            StoringSystemEntities db = new StoringSystemEntities();

            if (db.ExecuteStoreCommand("EXEC spm_InsertIssuesDetail @ProductNo, @Barcode, @CartonNo, @SizeNo, @IssuesId, @GrossWeight, @ActualWeight, @DifferencePercent, @Process, @CheckBy,@Location", @ProductNo, @Barcode, @CartonNo, @SizeNo, @IssuesId, @GrossWeight, @ActualWeight, @DifferencePercent, @Process, @CheckBy, @Location) >= 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
예제 #9
0
        public static List <IssuesModel> Select()
        {
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <IssuesModel>("EXEC spm_SelectIssues").ToList());
        }
예제 #10
0
        public static List <AccountModel> Get()
        {
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <AccountModel>("EXEC spm_GetAccount").ToList());
        }
예제 #11
0
        public static List <OutputingModel> SelectIsNotLoad()
        {
            StoringSystemEntities db = new StoringSystemEntities();

            return(db.ExecuteStoreQuery <OutputingModel>("EXEC spm_SelectOutputingIsNotLoad").ToList());
        }