public static List <ReportOSMaterialCheckWHInventoryModel> SelectOSMaterialWHInventory()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <ReportOSMaterialCheckWHInventoryModel>("EXEC reporter_SelectOSMaterialWHInventory").ToList());
};
}
public static List <SizeRunModel> SelectByInsockRawMaterial()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <SizeRunModel>("EXEC spm_SelectSizeRunByInsockRawMaterial").ToList());
}
}
public static List <OutsoleReleaseMaterialModel> SelectOutsoleReleaseToWHInspectionByOutsoleMaster()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <OutsoleReleaseMaterialModel>("EXEC spm_SelectOutsoleReleaseMaterialToWHInspectionByOutsoleMaster").ToList());
}
}
public static List <OutsoleMaterialModel> Select(string productNo)
{
var @ProductNo = new SqlParameter("@ProductNo", productNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <OutsoleMaterialModel>("EXEC spm_SelectOutsoleMaterialByProductNo @ProductNo", @ProductNo).ToList());
}
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 List <SizeRunModel> SelectPerArticle(string articleNo)
{
var @ArticleNo = new SqlParameter("@ArticleNo", articleNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <SizeRunModel>("EXEC spm_SelectSizeRunByArticle @ArticleNo", @ArticleNo).ToList());
}
public static MachineRequirementModel_OLD SelectTop1(string articleNo)
{
var @ArticleNo = new SqlParameter("@ArticleNo", articleNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <MachineRequirementModel_OLD>("EXEC spm_SelectMachineRequirementTop1 @ArticleNo", @ArticleNo).FirstOrDefault());
}
public static List <SewingMasterViewModelNew> GetSewingSummaryReport()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <SewingMasterViewModelNew>("EXEC reporter_ReportSewingSummary").ToList());
};
}
public static List <ReportOutsoleMaterialDeliverySummary> GetOSDeliverySummary()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <ReportOutsoleMaterialDeliverySummary>("EXEC reporter_OutsoleMaterialDeliverySummary").ToList());
};
}
public static List <OutsoleMaterialBalanceReportModel> GetOutsoleMaterialHasReject()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <OutsoleMaterialBalanceReportModel>("EXEC reporter_OutsoleMaterialReject").ToList());
};
}
public static List <OutsoleWHDeliveryReportModel> GetOutsoleWHDeliveryReport()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <OutsoleWHDeliveryReportModel>("EXEC ").ToList());
};
}
//
public static List <ReportOSMPaintShopModel> GetPaintShop()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <ReportOSMPaintShopModel>("reporter_OSMPaintShop").ToList());
}
}
//
public static List <ReportUpperAccessoriesModel> GetUpperAccessories()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <ReportUpperAccessoriesModel>("reporter_ReportUpperAccessories").ToList());
}
}
public static List <ReportUpperAccessoriesSummaryModel> SelectUpperAccessoriesDeliverySummary()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <ReportUpperAccessoriesSummaryModel>("EXEC reporter_AccessoriesDeliverySummary").ToList());
};
}
public static List <PhaseModel> Select()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <PhaseModel>("EXEC spm_SelectPhase").ToList());
}
}
public static PrivateDefineModel GetDefine()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <PrivateDefineModel>("EXEC spm_SelectPrivateDefine").FirstOrDefault());
}
}
public static List <OutsoleReleaseMaterialModel> SelectReportId()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <OutsoleReleaseMaterialModel>("EXEC spm_SelectOutsoleReleaseMaterialReportId_2").ToList());
}
}
public static List <RawMaterialSummarizeModel> SelectSummarize()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <RawMaterialSummarizeModel>("EXEC spm_SelectRawMaterialSumarize").ToList());
}
}
public static List <SizeRunModel> SelectPerOutsoleCode(string outsoleCode)
{
var @OutsoleCode = new SqlParameter("@OutsoleCode", outsoleCode);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <SizeRunModel>("EXEC spm_SelectSizeRunByOutsoleCode @OutsoleCode", @OutsoleCode).ToList());
}
public static OrdersModel SelectByArticleNo6(string articleNo)
{
var @ArticleNo = new SqlParameter("@ArticleNo", articleNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <OrdersModel>("EXEC spm_SelectOrdersByArticle6Char @ArticleNo", @ArticleNo).FirstOrDefault());
}
public static List <RejectModel> GetRejectUpperAccessories()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <RejectModel>("spm_SelectRejectUpperAccessories").ToList());
}
}
public static OrdersModel SelectTop1(string productNo)
{
var @ProductNo = new SqlParameter("@ProductNo", productNo);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <OrdersModel>("EXEC spm_SelectOrdersByProductNo @ProductNo", @ProductNo).FirstOrDefault());
}
public static List <OutsoleMaterialModel> SelectByOutsoleReleaseMaterial(string reportId)
{
var @ReportId = new SqlParameter("@ReportId", reportId);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <OutsoleMaterialModel>("EXEC spm_SelectOutsoleMaterialByOutsoleReleaseMaterialByReportId @ReportId", @ReportId).ToList());
}
public static AvailableMachineModel SelectTop1(string IdMachineAvailable)
{
var @Id = new SqlParameter("@Id", IdMachineAvailable);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <AvailableMachineModel>("EXEC spm_SelectAvailableMachineTop1 @Id", @Id).FirstOrDefault());
}
//spm_SelectSizeRunIsnable
public static List <SizeRunModel> SelectIsEnable()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <SizeRunModel>("EXEC spm_SelectSizeRunIsnable").ToList());
}
}
public static List <SupplierModel> GetSuppliersAccessories()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <SupplierModel>("spm_SelectSuppliersAccessories").ToList());
}
}
public static List <AssemblyReleaseModel> Select(string reportId, string productNo)
{
var @ReportId = new SqlParameter("@ReportId", reportId);
SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities();
return(db.ExecuteStoreQuery <AssemblyReleaseModel>("EXEC spm_SelectAssemblyReleaseByReportId @ReportId", @ReportId).ToList());
}
public static List <OutsoleOutputModel> SelectByIsEnable()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <OutsoleOutputModel>("EXEC spm_SelectOutsoleOutputIsEnable").ToList());
}
}
public static List <SockliningInputModel> SelectByAssemblyMaster()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <SockliningInputModel>("EXEC spm_SelectSockliningInputByAssemblyMaster").ToList());
};
}
public static List <ReportOutsoleInventoryModel> InventoryByOutsoleLine()
{
using (var db = new SaovietMasterScheduleEntities())
{
return(db.ExecuteStoreQuery <ReportOutsoleInventoryModel>("EXEC reporter_OutsoleInventoryByOSLine").ToList());
};
}
