public static bool Insert(PORepackingModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @CreatedTime = new SqlParameter("@CreatedTime", model.CreatedTime);
if (db.ExecuteStoreCommand("EXEC spm_InsertPORepacking @ProductNo, @CreatedTime",
@ProductNo, @CreatedTime) >= 1)
{
return(true);
}
else
{
return(false);
}
}
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);
}
}
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);
}
}
