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()); }; }