public static bool Insert(InsockRawMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @InsockSupplierId = new SqlParameter("@InsockSupplierId", model.InsockSupplierId);
var @ETD = new SqlParameter("@ETD", model.ETD);
if (db.ExecuteStoreCommand("EXEC spm_InsertInsockRawMaterial @ProductNo, @InsockSupplierId, @ETD", @ProductNo, @InsockSupplierId, @ETD) > 0)
{
return(true);
}
return(false);
}
public static bool Insert(UpperComponentRawMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @UpperComponentID = new SqlParameter("@UpperComponentID", model.UpperComponentID);
var @ETD = new SqlParameter("@ETD", model.ETD);
if (db.ExecuteStoreCommand("EXEC spm_InsertUpperComponentRawMaterial @ProductNo, @UpperComponentID, @ETD", @ProductNo, @UpperComponentID, @ETD) > 0)
{
return(true);
}
return(false);
}
public static bool Insert(OutsoleMaterialRackPositionModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @RackNumber = new SqlParameter("@RackNumber", model.RackNumber);
var @CartonNumber = new SqlParameter("@CartonNumber", model.CartonNumber);
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialRackPosition @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber", @ProductNo, @OutsoleSupplierId, @RackNumber, @CartonNumber) >= 1)
{
return(true);
}
return(false);
}
public static bool Insert(OutsoleWHFGModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @CreatedDate = new SqlParameter("@CreatedDate", model.CreatedDate);
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleWHFG @ProductNo, @SizeNo, @Quantity, @CreatedDate", @ProductNo, @SizeNo, @Quantity, @CreatedDate) >= 1)
{
return(true);
}
return(false);
}
public static bool Insert(UpperComponentMaterialModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @UpperComponentID = new SqlParameter("@UpperComponentID", model.UpperComponentID);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @QuantityReject = new SqlParameter("@QuantityReject", model.QuantityReject);
if (db.ExecuteStoreCommand("EXEC spm_InsertUpperComponentMaterial_2 @ProductNo,@UpperComponentID,@SizeNo,@Quantity,@QuantityReject", @ProductNo, @UpperComponentID, @SizeNo, @Quantity, @QuantityReject) >= 1)
{
return(true);
}
return(false);
}
/// <summary>
/// Upadate Outsole Material
/// </summary>
/// <param name="model">Material Update</param>
/// <param name="updateReject">Update Reject?</param>
/// <param name="updateQuantity">Update Quantity?</param>
/// <param name="updateRejectAssembly">Update Reject Assembly?</param>
/// <returns></returns>
public static bool Update(OutsoleMaterialModel model, bool updateReject, bool updateQuantity, bool updateRejectAssembly, bool updateRejectStockfit)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @QuantityReject = new SqlParameter("@QuantityReject", model.QuantityReject);
var @RejectAssembly = new SqlParameter("@RejectAssembly", model.RejectAssembly);
var @RejectStockfit = new SqlParameter("@RejectStockfit", model.RejectStockfit);
var @UpdateQuantity = new SqlParameter("@UpdateQuantity", updateQuantity);
var @UpdateReject = new SqlParameter("@UpdateReject", updateReject);
var @UpdateRejectAssembly = new SqlParameter("@UpdateRejectAssembly", updateRejectAssembly);
var @UpdateRejectStockfit = new SqlParameter("@UpdateRejectStockfit", updateRejectStockfit);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_UpdateOutsoleMaterial_2 @ProductNo, @OutsoleSupplierId, @SizeNo, @Quantity, @QuantityReject, @RejectAssembly, @RejectStockfit, @UpdateReject, @UpdateQuantity, @UpdateRejectAssembly, @UpdateRejectStockfit",
@ProductNo, @OutsoleSupplierId, @SizeNo, @Quantity, @QuantityReject, @RejectAssembly, @RejectStockfit, @UpdateReject, @UpdateQuantity, @UpdateRejectAssembly, @UpdateRejectStockfit) >= 1)
{
return(true);
}
return(false);
}
}
public static bool Insert(OutsoleMaterialCheckingModel model)
{
var @WorkerId = new SqlParameter("@WorkerId", model.WorkerId);
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @CheckingDate = new SqlParameter("@CheckingDate", model.CheckingDate);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @Reject = new SqlParameter("@Reject", model.Reject);
var @ErrorId = new SqlParameter("@ErrorId", model.ErrorId);
var @Excess = new SqlParameter("@Excess", model.Excess);
var @WorkingCard = new SqlParameter("@WorkingCard", model.WorkingCard);
var @ReturnReject = new SqlParameter("@ReturnReject", model.ReturnReject);
var @ReturnRemark = new SqlParameter("@ReturnRemark", model.ReturnRemark);
//var @SizeNoUpper = new SqlParameter("@SizeNoUpper", model.SizeNoUpper);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialChecking_4 @WorkerId, @ProductNo, @CheckingDate, @OutsoleSupplierId, @SizeNo, @Quantity, @Reject, @ErrorId, @Excess, @WorkingCard, @ReturnReject, @ReturnRemark",
@WorkerId, @ProductNo, @CheckingDate, @OutsoleSupplierId, @SizeNo, @Quantity, @Reject, @ErrorId, @Excess, @WorkingCard, @ReturnReject, @ReturnRemark) > 0)
{
return(true);
}
return(false);
};
}
public static bool Insert(MaterialInspectModel model, bool insertQty, bool insertReject, bool deleteReject)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @SupplierId = new SqlParameter("@SupplierId", model.SupplierId);
var @DeliveryDate = new SqlParameter("@DeliveryDate", model.DeliveryDate);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @Reject = new SqlParameter("@Reject", model.Reject);
var @RejectId = new SqlParameter("@RejectId", model.RejectId);
var @Reviser = new SqlParameter("@Reviser", model.Reviser);
var @InsertQuantity = new SqlParameter("@InsertQuantity", insertQty);
var @InsertReject = new SqlParameter("@InsertReject", insertReject);
var @DeleteReject = new SqlParameter("@DeleteReject", deleteReject);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_InsertMaterialDelivery @ProductNo, @SupplierId, @DeliveryDate, @SizeNo, @Quantity, @Reject, @RejectId, @Reviser, @InsertQuantity, @InsertReject, @DeleteReject",
@ProductNo, @SupplierId, @DeliveryDate, @SizeNo, @Quantity, @Reject, @RejectId, @Reviser, @InsertQuantity, @InsertReject, @DeleteReject) > 0)
{
return(true);
}
return(false);
}
}
//
public static bool Insert(LaminationMaterialModel model)
{
var @OrderNoId = new SqlParameter("@OrderNoId", model.OrderNoId);
var @OrderNo = new SqlParameter("@OrderNo", model.OrderNo);
var @ArticleNo = new SqlParameter("@ArticleNo", model.ArticleNo);
var @ShoeName = new SqlParameter("@ShoeName", model.ShoeName);
var @PatternNo = new SqlParameter("@PatternNo", model.PatternNo);
var @ProductNoList = new SqlParameter("@ProductNoList", model.ProductNoList);
var @Position = new SqlParameter("@Position", model.Position);
var @MaterialPart = new SqlParameter("@MaterialPart", model.MaterialPart);
var @MaterialName = new SqlParameter("@MaterialName", model.MaterialName);
var @Unit = new SqlParameter("@Unit", model.Unit);
var @POQuantity = new SqlParameter("@POQuantity", model.POQuantity);
var @SendQuantity = new SqlParameter("@SendQuantity", model.SendQuantity);
var @DeliveryDate = new SqlParameter("@DeliveryDate", model.DeliveryDate);
var @PurchaseDate = new SqlParameter("@PurchaseDate", model.PurchaseDate);
var @SupplierName = new SqlParameter("@SupplierName", model.SupplierName);
var @Remarks = new SqlParameter("@Remarks", model.Remarks);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_InsertLaminationMaterial @OrderNoId, @OrderNo, @ArticleNo, @ShoeName, @PatternNo, @ProductNoList, @Position, @MaterialPart, @MaterialName, @Unit, @POQuantity, @SendQuantity, @DeliveryDate, @PurchaseDate, @SupplierName, @Remarks",
@OrderNoId, @OrderNo, @ArticleNo, @ShoeName, @PatternNo, @ProductNoList, @Position, @MaterialPart, @MaterialName, @Unit, @POQuantity, @SendQuantity, @DeliveryDate, @PurchaseDate, @SupplierName, @Remarks) > 0)
{
return true;
}
return false;
}
}
public static bool Update(OrdersModel model)
{
string computerName = "";
try { computerName = System.Environment.MachineName; }
catch { computerName = ""; }
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @GTNPONo = new SqlParameter("@GTNPONo", model.GTNPONo);
var @UCustomerCode = new SqlParameter("@UCustomerCode", model.UCustomerCode);
var @ETD = new SqlParameter("@ETD", model.ETD);
var @ArticleNo = new SqlParameter("@ArticleNo", model.ArticleNo);
var @ShoeName = new SqlParameter("@ShoeName", model.ShoeName);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @PatternNo = new SqlParameter("@PatternNo", model.PatternNo);
var @MidsoleCode = new SqlParameter("@MidsoleCode", model.MidsoleCode);
var @OutsoleCode = new SqlParameter("@OutsoleCode", model.OutsoleCode);
var @LastCode = new SqlParameter("@LastCode", model.LastCode);
var @Country = new SqlParameter("@Country", model.Country);
var @IsEnable = new SqlParameter("@IsEnable", model.IsEnable);
var @TypeOfShoes = new SqlParameter("@TypeOfShoes", model.TypeOfShoes);
var @Reviser = new SqlParameter("@Reviser", String.Format("{0}-{1}", model.Reviser, computerName));
var @ShipDate = new SqlParameter("@ShipDate", model.ShipDate);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_UpdateOrders_4 @ProductNo, @GTNPONo, @UCustomerCode, @ETD, @ArticleNo, @ShoeName, @Quantity, @PatternNo, @MidsoleCode, @OutsoleCode, @LastCode, @Country, @IsEnable, @Reviser, @TypeOfShoes, @ShipDate",
@ProductNo, @GTNPONo, @UCustomerCode, @ETD, @ArticleNo, @ShoeName, @Quantity, @PatternNo, @MidsoleCode, @OutsoleCode, @LastCode, @Country, @IsEnable, @Reviser, @TypeOfShoes, @ShipDate) > 0)
{
return(true);
}
return(false);
}
}
public static bool Insert(SewingMasterModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @SewingLine = new SqlParameter("@SewingLine", model.SewingLine);
var @SewingQuota = new SqlParameter("@SewingQuota", model.SewingQuota);
var @SewingActualStartDate = new SqlParameter("@SewingActualStartDate", model.SewingActualStartDate);
var @SewingActualFinishDate = new SqlParameter("@SewingActualFinishDate", model.SewingActualFinishDate);
var @SewingBalance = new SqlParameter("@SewingBalance", model.SewingBalance);
var @CutAQuota = new SqlParameter("@CutAQuota", model.CutAQuota);
var @CutAActualStartDate = new SqlParameter("@CutAActualStartDate", model.CutAActualStartDate);
var @CutAActualFinishDate = new SqlParameter("@CutAActualFinishDate", model.CutAActualFinishDate);
var @CutABalance = new SqlParameter("@CutABalance", model.CutABalance);
var @PrintingBalance = new SqlParameter("@PrintingBalance", model.PrintingBalance);
var @H_FBalance = new SqlParameter("@H_FBalance", model.H_FBalance);
var @EmbroideryBalance = new SqlParameter("@EmbroideryBalance", model.EmbroideryBalance);
var @CutBBalance = new SqlParameter("@CutBBalance", model.CutBBalance);
var @AutoCut = new SqlParameter("@AutoCut", model.AutoCut);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertSewingMaster @ProductNo,@Sequence,@SewingLine,@SewingQuota,@SewingActualStartDate,@SewingActualFinishDate,@SewingBalance,@CutAQuota,@CutAActualStartDate,@CutAActualFinishDate,@CutABalance,@PrintingBalance,@H_FBalance,@EmbroideryBalance,@CutBBalance,@AutoCut", @ProductNo, @Sequence, @SewingLine, @SewingQuota, @SewingActualStartDate, @SewingActualFinishDate, @SewingBalance, @CutAQuota, @CutAActualStartDate, @CutAActualFinishDate, @CutABalance, @PrintingBalance, @H_FBalance, @EmbroideryBalance, @CutBBalance, @AutoCut) > 0)
{
return(true);
}
return(false);
}
public static bool Update(ProductionMemoModel model)
{
var @MemoId = new SqlParameter("@MemoId", model.MemoId);
var @ProductionNumbers = new SqlParameter("@ProductionNumbers", model.ProductionNumbers);
var @Picture = new SqlParameter("@Picture", SqlDbType.Image);
@Picture.Value = DBNull.Value;
if (model.Picture != null)
{
@Picture.Value = model.Picture;
}
var @Picture1 = new SqlParameter("@Picture1", SqlDbType.Image);
@Picture1.Value = DBNull.Value;
if (model.Picture1 != null)
{
@Picture1.Value = model.Picture1;
}
var @Picture2 = new SqlParameter("@Picture2", SqlDbType.Image);
@Picture2.Value = DBNull.Value;
if (model.Picture2 != null)
{
@Picture2.Value = model.Picture2;
}
var @Picture3 = new SqlParameter("@Picture3", SqlDbType.Image);
@Picture3.Value = DBNull.Value;
if (model.Picture3 != null)
{
@Picture3.Value = model.Picture3;
}
var @Picture4 = new SqlParameter("@Picture4", SqlDbType.Image);
@Picture4.Value = DBNull.Value;
if (model.Picture4 != null)
{
@Picture4.Value = model.Picture4;
}
return(db.ExecuteStoreCommand("spm_UpdateProductionMemo_1 @MemoId, @ProductionNumbers, @Picture, @Picture1, @Picture2, @Picture3, @Picture4", @MemoId, @ProductionNumbers, @Picture, @Picture1, @Picture2, @Picture3, @Picture4) > 0);
}
public static bool Insert(OutsoleMaterialRejectDetailModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @OutsoleMaterialRejectIssuesId = new SqlParameter("@OutsoleMaterialRejectIssuesId", model.OutsoleMaterialRejectIssuesId);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @QuantityReject = new SqlParameter("@QuantityReject", model.QuantityReject);
var @CreatedBy = new SqlParameter("@CreatedBy", model.CreatedBy);
var @IndexNo = new SqlParameter("@IndexNo", model.IndexNo);
var @Round = new SqlParameter("@Round", model.Round);
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialRejectDetail @ProductNo, @OutsoleSupplierId, @OutsoleMaterialRejectIssuesId, @SizeNo, @QuantityReject, @CreatedBy, @IndexNo, @Round", @ProductNo, @OutsoleSupplierId, @OutsoleMaterialRejectIssuesId, @SizeNo, @QuantityReject, @CreatedBy, @IndexNo, @Round) > 0)
{
return(true);
}
return(false);
}
public static bool Insert(OutsoleMaterialDetailModel model, AccountModel account)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", model.OutsoleSupplierId);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
var @Reject = new SqlParameter("@Reject", model.Reject);
var @QuantityExcess = new SqlParameter("@QuantityExcess", model.QuantityExcess);
var @CreatedBy = new SqlParameter("@CreatedBy", account.UserName);
var @IndexNo = new SqlParameter("@IndexNo", model.IndexNo);
var @Round = new SqlParameter("@Round", model.Round);
if (db.ExecuteStoreCommand("EXEC spm_InsertOutsoleMaterialDetail @ProductNo, @OutsoleSupplierId, @SizeNo, @Quantity, @Reject, @QuantityExcess,@CreatedBy,@IndexNo,@Round", @ProductNo, @OutsoleSupplierId, @SizeNo, @Quantity, @Reject, @QuantityExcess, @CreatedBy, @IndexNo, @Round) >= 1)
{
return(true);
}
return(false);
}
public static bool Insert_2(OutsoleMasterModel model)
{
DateTime dtDefault = new DateTime(2000, 01, 01);
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @OutsoleLine = new SqlParameter("@OutsoleLine", model.OutsoleLine);
var @OutsoleStartDate = new SqlParameter("@OutsoleStartDate", model.OutsoleStartDate);
var @OutsoleFinishDate = new SqlParameter("@OutsoleFinishDate", model.OutsoleFinishDate);
var @OutsoleQuota = new SqlParameter("@OutsoleQuota", model.OutsoleQuota);
var @OutsoleActualStartDate = new SqlParameter("@OutsoleActualStartDate", model.OutsoleActualStartDate);
var @OutsoleActualFinishDate = new SqlParameter("@OutsoleActualFinishDate", model.OutsoleActualFinishDate);
DateTime outsoleActualStartDateAutoDt = TimeHelper.Convert(model.OutsoleActualStartDateAuto);
DateTime outsoleActualFinishDateAutoDt = TimeHelper.Convert(model.OutsoleActualFinishDateAuto);
string outsoleActualStartDateAutoString = "";
if (outsoleActualStartDateAutoDt != dtDefault)
{
outsoleActualStartDateAutoString = String.Format("{0:MM/dd/yyyy}", outsoleActualStartDateAutoDt);
}
string outsoleActualFinishDateAutoString = "";
if (outsoleActualFinishDateAutoDt != dtDefault)
{
outsoleActualFinishDateAutoString = String.Format("{0:MM/dd/yyyy}", outsoleActualFinishDateAutoDt);
}
var @OutsoleActualStartDateAuto = new SqlParameter("@OutsoleActualStartDateAuto", outsoleActualStartDateAutoString);
var @OutsoleActualFinishDateAuto = new SqlParameter("@OutsoleActualFinishDateAuto", outsoleActualFinishDateAutoString);
var @OutsoleBalance = new SqlParameter("@OutsoleBalance", model.OutsoleBalance);
var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate);
var @IsOutsoleLineUpdate = new SqlParameter("@IsOutsoleLineUpdate", model.IsOutsoleLineUpdate);
var @IsOutsoleStartDateUpdate = new SqlParameter("@IsOutsoleStartDateUpdate", model.IsOutsoleStartDateUpdate);
var @IsOutsoleFinishDateUpdate = new SqlParameter("@IsOutsoleFinishDateUpdate", model.IsOutsoleFinishDateUpdate);
var @IsOutsoleQuotaUpdate = new SqlParameter("@IsOutsoleQuotaUpdate", model.IsOutsoleQuotaUpdate);
var @IsOutsoleActualStartDateUpdate = new SqlParameter("@IsOutsoleActualStartDateUpdate", model.IsOutsoleActualStartDateUpdate);
var @IsOutsoleActualFinishDateUpdate = new SqlParameter("@IsOutsoleActualFinishDateUpdate", model.IsOutsoleActualFinishDateUpdate);
var @IsOutsoleActualStartDateAutoUpdate = new SqlParameter("@IsOutsoleActualStartDateAutoUpdate", model.IsOutsoleActualStartDateAutoUpdate);
var @IsOutsoleActualFinishDateAutoUpdate = new SqlParameter("@IsOutsoleActualFinishDateAutoUpdate", model.IsOutsoleActualFinishDateAutoUpdate);
var @IsOutsoleBalanceUpdate = new SqlParameter("@IsOutsoleBalanceUpdate", model.IsOutsoleBalanceUpdate);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand(@"EXEC spm_InsertOutsoleMaster_3 @ProductNo, @Sequence, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleActualStartDateAuto, @OutsoleActualFinishDateAuto, @OutsoleBalance, @IsSequenceUpdate, @IsOutsoleLineUpdate, @IsOutsoleStartDateUpdate, @IsOutsoleFinishDateUpdate, @IsOutsoleQuotaUpdate, @IsOutsoleActualStartDateUpdate, @IsOutsoleActualFinishDateUpdate, @IsOutsoleActualStartDateAutoUpdate, @IsOutsoleActualFinishDateAutoUpdate, @IsOutsoleBalanceUpdate",
@ProductNo, @Sequence, @OutsoleLine, @OutsoleStartDate, @OutsoleFinishDate, @OutsoleQuota, @OutsoleActualStartDate, @OutsoleActualFinishDate, @OutsoleActualStartDateAuto, @OutsoleActualFinishDateAuto, @OutsoleBalance, @IsSequenceUpdate, @IsOutsoleLineUpdate, @IsOutsoleStartDateUpdate, @IsOutsoleFinishDateUpdate, @IsOutsoleQuotaUpdate, @IsOutsoleActualStartDateUpdate, @IsOutsoleActualFinishDateUpdate, @IsOutsoleActualStartDateAutoUpdate, @IsOutsoleActualFinishDateAutoUpdate, @IsOutsoleBalanceUpdate) > 0)
{
return(true);
}
return(false);
}
public static bool Delete(string IdAvailableMachine)
{
var @Id = new SqlParameter("@Id", IdAvailableMachine);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_DeleteAvailableMachine @Id", @Id) > 0)
{
return(true);
}
return(false);
}
public static bool Delete(string productNo)
{
var @ProductNo = new SqlParameter("@ProductNo", productNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_DeleteOrders @ProductNo", @ProductNo) > 0)
{
return(true);
}
return(false);
}
public static bool Delete(DateTime date)
{
var @Date = new SqlParameter("@Date", date);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_DeleteOffDay @Date", @Date) > 0)
{
return(true);
}
return(false);
}
public static bool Insert(OrderExtraModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @LoadingDate = new SqlParameter("@LoadingDate", model.LoadingDate);
if (db.ExecuteStoreCommand("EXEC spm_InsertOrderExtra @ProductNo,@LoadingDate", @ProductNo, @LoadingDate) > 0)
{
return(true);
}
return(false);
}
public static bool Delete(string articleNo)
{
var @ArticleNo = new SqlParameter("@ArticleNo", articleNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_DeleteMachineRequirement @ArticleNo", @ArticleNo) > 0)
{
return(true);
}
return(false);
}
public static bool Update(string productNo, bool isEnable)
{
var @ProductNo = new SqlParameter("@ProductNo", productNo);
var @IsEnable = new SqlParameter("@IsEnable", isEnable);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_UpdateOrdersOfIsEnable @ProductNo, @IsEnable", @ProductNo, @IsEnable) > 0)
{
return(true);
}
return(false);
}
public static bool Insert(OffDayModel model)
{
var @Date = new SqlParameter("@Date", model.Date);
var @Remarks = new SqlParameter("@Remarks", model.Remarks);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertOffDay @Date, @Remarks", @Date, @Remarks) > 0)
{
return(true);
}
return(false);
}
//
public static bool Delete(int machineID)
{
var @MachineID = new SqlParameter("@MachineID", machineID);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_DeleteMachine @MachineID", @MachineID) > 0)
{
return(true);
}
return(false);
}
}
public static bool Delete(string productNo, int outsoleSupplierId)
{
var @ProductNo = new SqlParameter("@ProductNo", productNo);
var @OutsoleSupplierId = new SqlParameter("@OutsoleSupplierId", outsoleSupplierId);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_DeleteOutsoleRawMaterial @ProductNo, @OutsoleSupplierId", @ProductNo, @OutsoleSupplierId) > 0)
{
return(true);
}
return(false);
}
public static bool Delete(string reportId, string productNo)
{
var @ReportId = new SqlParameter("@ReportId", reportId);
var @ProductNo = new SqlParameter("@ProductNo", productNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_DeleteAssemblyReleaseByReportIdProductNo @ReportId, @ProductNo", @ReportId, @ProductNo) >= 1)
{
return(true);
}
return(false);
}
public static bool Insert(ProductNoReviseModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @ReviseDate = new SqlParameter("@ReviseDate", model.ReviseDate);
var @SectionId = new SqlParameter("@SectionId", model.SectionId);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_InsertProductNoRevise @ProductNo, @ReviseDate, @SectionId", @ProductNo, @ReviseDate, @SectionId) > 0)
{
return(true);
}
return(false);
}
public static bool DeleteByOrderNoId(string orderNoId)
{
var @OrderNoId = new SqlParameter("@OrderNoId", orderNoId);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_DeleteLaminationMaterialByOrderNoId @OrderNoId",
@OrderNoId) > 0)
{
return true;
}
return false;
}
}
public static bool Insert_2(SockliningMasterModel model)
{
DateTime dtDefault = new DateTime(2000, 01, 01);
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @Sequence = new SqlParameter("@Sequence", model.Sequence);
var @SockliningLine = new SqlParameter("@SockliningLine", model.SockliningLine);
var @SockliningStartDate = new SqlParameter("@SockliningStartDate", model.SockliningStartDate);
var @SockliningFinishDate = new SqlParameter("@SockliningFinishDate", model.SockliningFinishDate);
var @SockliningQuota = new SqlParameter("@SockliningQuota", model.SockliningQuota);
DateTime sockliningActualStartDateDt = TimeHelper.Convert(model.SockliningActualStartDate);
DateTime sockliningActualFinishDateDt = TimeHelper.Convert(model.SockliningActualFinishDate);
string sockliningActualStartDateString = "";
if (sockliningActualStartDateDt != dtDefault)
{
sockliningActualStartDateString = String.Format("{0:MM/dd/yyyy}", sockliningActualStartDateDt);
}
string sockliningActualFinishDateString = "";
if (sockliningActualFinishDateDt != dtDefault)
{
sockliningActualFinishDateString = String.Format("{0:MM/dd/yyyy}", sockliningActualFinishDateDt);
}
var @SockliningActualStartDate = new SqlParameter("@SockliningActualStartDate", sockliningActualStartDateString);
var @SockliningActualFinishDate = new SqlParameter("@SockliningActualFinishDate", sockliningActualFinishDateString);
var @InsoleBalance = new SqlParameter("@InsoleBalance", model.InsoleBalance);
var @InsockBalance = new SqlParameter("@InsockBalance", model.InsockBalance);
var @IsSequenceUpdate = new SqlParameter("@IsSequenceUpdate", model.IsSequenceUpdate);
var @IsSockliningLineUpdate = new SqlParameter("@IsSockliningLineUpdate", model.IsSockliningLineUpdate);
var @IsSockliningStartDateUpdate = new SqlParameter("@IsSockliningStartDateUpdate", model.IsSockliningStartDateUpdate);
var @IsSockliningFinishDateUpdate = new SqlParameter("@IsSockliningFinishDateUpdate", model.IsSockliningFinishDateUpdate);
var @IsSockliningQuotaUpdate = new SqlParameter("@IsSockliningQuotaUpdate", model.IsSockliningQuotaUpdate);
var @IsSockliningActualStartDateUpdate = new SqlParameter("@IsSockliningActualStartDateUpdate", model.IsSockliningActualStartDateUpdate);
var @IsSockliningActualFinishDateUpdate = new SqlParameter("@IsSockliningActualFinishDateUpdate", model.IsSockliningActualFinishDateUpdate);
var @IsInsoleBalanceUpdate = new SqlParameter("@IsInsoleBalanceUpdate", model.IsInsoleBalanceUpdate);
var @IsInsockBalanceUpdate = new SqlParameter("@IsInsockBalanceUpdate", model.IsInsockBalanceUpdate);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_InsertSockliningMaster_3 @ProductNo, @Sequence, @SockliningLine, @SockliningStartDate, @SockliningFinishDate, @SockliningQuota, @SockliningActualStartDate, @SockliningActualFinishDate, @InsoleBalance, @InsockBalance, @IsSequenceUpdate, @IsSockliningLineUpdate, @IsSockliningStartDateUpdate, @IsSockliningFinishDateUpdate, @IsSockliningQuotaUpdate, @IsSockliningActualStartDateUpdate, @IsSockliningActualFinishDateUpdate, @IsInsoleBalanceUpdate, @IsInsockBalanceUpdate ",
@ProductNo, @Sequence, @SockliningLine, @SockliningStartDate, @SockliningFinishDate, @SockliningQuota, @SockliningActualStartDate, @SockliningActualFinishDate, @InsoleBalance, @InsockBalance, @IsSequenceUpdate, @IsSockliningLineUpdate, @IsSockliningStartDateUpdate, @IsSockliningFinishDateUpdate, @IsSockliningQuotaUpdate, @IsSockliningActualStartDateUpdate, @IsSockliningActualFinishDateUpdate, @IsInsoleBalanceUpdate, @IsInsockBalanceUpdate) > 0)
{
return(true);
}
return(false);
}
}
public static bool Delete(string reportId, string productNo)
{
var @ReportId = new SqlParameter("@ReportId", reportId);
var @ProductNo = new SqlParameter("@ProductNo", productNo);
using (var db = new SaovietMasterScheduleEntities())
{
if (db.ExecuteStoreCommand("EXEC spm_DeleteOutsoleReleaseMaterialToWHInspectionByReportIdProductNo @ReportId, @ProductNo", @ReportId, @ProductNo) >= 1)
{
return(true);
}
return(false);
}
}
public static bool Update(SizeRunModel model)
{
var @ProductNo = new SqlParameter("@ProductNo", model.ProductNo);
var @SizeNo = new SqlParameter("@SizeNo", model.SizeNo);
var @Quantity = new SqlParameter("@Quantity", model.Quantity);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
if (db.ExecuteStoreCommand("EXEC spm_UpdateSizeRun @ProductNo,@SizeNo,@Quantity", @ProductNo, @SizeNo, @Quantity) > 0)
{
return(true);
}
return(false);
}