public static List <ReportOSMaterialCheckDetailModel> SelectOSMaterialCheckByOSCode(string outsoleCode) { var @OutsoleCode = new SqlParameter("@OutsoleCode", outsoleCode); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <ReportOSMaterialCheckDetailModel>("EXEC reporter_SelectOutsoleMaterialCheckingByOutsoleCode @OutsoleCode", @OutsoleCode).ToList()); }; }
public static List <ReportUpperAccessoriesDetailBySupplierModel> GetUpperAccessoriesMaterialDeliveryBySupplier(int supplierId) { var @SupplierId = new SqlParameter("@SupplierId", supplierId); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <ReportUpperAccessoriesDetailBySupplierModel>("reporter_AccessoriesDeliveryBySupplier @SupplierId", @SupplierId).ToList()); } }
public static List <MaterialPlanModel> GetMaterialPlanByPO(string productNo) { var @ProductNo = new SqlParameter("@ProductNo", productNo); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <MaterialPlanModel>("spm_SelectMaterialPlanByPO @ProductNo", @ProductNo).ToList()); } }
public static List <ReportOSMWHCheckingModel> SelectOSMWHCheckingByPO(String poSearch) { var @ProductNo = new SqlParameter("@ProductNo", poSearch); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <ReportOSMWHCheckingModel>("EXEC reporter_SelectOSMWHCheckingListByPO @ProductNo", @ProductNo).ToList()); }; }
// public static List <OutsoleMaterialModel> SelectByOSCode(string osCode) { var @OutsoleCode = new SqlParameter("@OutsoleCode", osCode); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OutsoleMaterialModel>("EXEC spm_SelectOutsoleMaterialByOutsoleCode @OutsoleCode", @OutsoleCode).ToList()); } }
public static List <OutsoleMaterialModel> SelectByOutsoleReleaseMaterialToWHInspection(string reportId) { var @ReportId = new SqlParameter("@ReportId", reportId); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OutsoleMaterialModel>("EXEC spm_SelectOutsoleMaterialByOutsoleReleaseMaterialToWHInspectionByReportId @ReportId", @ReportId).ToList()); } }
public static List <OutsoleMaterialModel> Select(string productNo) { var @ProductNo = new SqlParameter("@ProductNo", productNo); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OutsoleMaterialModel>("EXEC spm_SelectOutsoleMaterialByProductNo @ProductNo", @ProductNo).ToList()); } }
/// <summary> /// /// </summary> /// <param name="indexNo"></param> /// <returns></returns> public static List <OutsoleMaterialConfirmWorkingCartModel> GetOSConfirmByIndexNo(int indexNo) { var @WorkingCart = new SqlParameter("@WorkingCart", indexNo); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OutsoleMaterialConfirmWorkingCartModel>("EXEC spm_SelectOutsoleMaterialConfirmByWorkingCart @WorkingCart", @WorkingCart).ToList()); } }
public static List <OutsoleMaterialCheckingModel> SelectByPOSumBySize(string POSearch) { var @ProductNo = new SqlParameter("@ProductNo", POSearch); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OutsoleMaterialCheckingModel>("EXEC spm_SelectOutsoleMaterialCheckingByPOSumBySize @ProductNo", @ProductNo).ToList()); }; }
public static List <SewingOutputModel> SelectByAssemblyRelease(string reportId) { var @ReportId = new SqlParameter("@ReportId", reportId); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <SewingOutputModel>("EXEC spm_SelectSewingOutputByAssemblyReleaseByReportId @ReportId", @ReportId).ToList()); } }
public static List <AvailableWorker> SelectWorker(int _year, int _month, int _day) { var @Year = new SqlParameter("@Year", _year); var @Month = new SqlParameter("@Month", _month); var @Day = new SqlParameter("@Day", _day); SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <AvailableWorker>("EXEC spm_SelectWorkerByDate @Year, @Month, @Day", @Year, @Month, @Day).ToList()); }
public static List <ReportOSMWHCheckingModel> SelectOSWHMCheckingFromTo(DateTime dateFrom, DateTime dateTo) { var @DateFrom = new SqlParameter("@DateFrom", dateFrom); var @DateTo = new SqlParameter("@DateTo", dateTo); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <ReportOSMWHCheckingModel>("EXEC reporter_SelectOSMWHCheckingListFromTo_1 @DateFrom, @DateTo", @DateFrom, @DateTo).ToList()); }; }
public static List <ReportOutsoleMaterialDeliveryFromToModel> GetOutsoleDeliveryFromTo(DateTime dateFrom, DateTime dateTo) { var @DateFrom = new SqlParameter("@DateFrom", dateFrom); var @DateTo = new SqlParameter("@DateTo", dateTo); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <ReportOutsoleMaterialDeliveryFromToModel>("EXEC reporter_SelectOutsoleDeliveryFromTo @DateFrom, @DateTo", @DateFrom, @DateTo).ToList()); }; }
public static List <ReportMaterialArrivalModel> GetOutsoleMatsArrivalFromTo_1(DateTime dateFrom, DateTime dateTo) { var @DateFrom = new SqlParameter("@DateFrom", dateFrom); var @DateTo = new SqlParameter("@DateTo", dateTo); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <ReportMaterialArrivalModel>("reporter_OutsoleMaterialArrivalFromTo_1 @DateFrom, @DateTo", @DateFrom, @DateTo).ToList()); } }
// IsEnable = 1 || 0 public static List <SewingMasterModel> SelectFull(DateTime etdStart, DateTime etdEnd) { var @ETDStart = new SqlParameter("@ETDStart", etdStart); var @ETDEnd = new SqlParameter("@ETDEnd", etdEnd); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <SewingMasterModel>("EXEC spm_SelectSewingMasterFull @ETDStart, @ETDEnd", ETDStart, ETDEnd).ToList()); }; }
// IsEnable = 1 || 0 public static List <OrdersModel> SelectByOutsoleRawMaterialFull(DateTime etdStart, DateTime etdEnd) { var @ETDStart = new SqlParameter("@ETDStart", etdStart); var @ETDEnd = new SqlParameter("@ETDEnd", etdEnd); using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OrdersModel>("EXEC spm_SelectOrdersByOutsoleRawMaterialFull @ETDStart, @ETDEnd", @ETDStart, @ETDEnd).ToList()); }; }
public static List <UpperComponentModel> Select() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <UpperComponentModel>("EXEC spm_SelectUpperComponents").ToList()); }
public static List <OutsoleMasterModel> Select() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <OutsoleMasterModel>("EXEC spm_SelectOutsoleMaster").ToList()); }
public static List <OrdersModel> Select() { using (var db = new SaovietMasterScheduleEntities()) { return(db.ExecuteStoreQuery <OrdersModel>("EXEC spm_SelectOrders").ToList()); }; }
public static List <InsockMaterialModel> Select() { return(db.ExecuteStoreQuery <InsockMaterialModel>("EXEC spm_SelectInsockMaterial").ToList()); }
public static List <AssemblyReleaseModel> SelectReportId() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <AssemblyReleaseModel>("EXEC spm_SelectAssemblyReleaseReportId_2").ToList()); }
public static List <MachineRequirementModel_OLD> Select() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <MachineRequirementModel_OLD>("EXEC spm_SelectMachineRequirement").ToList()); }
public static List <MaterialTypeModel> Select() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <MaterialTypeModel>("EXEC spm_SelectMaterialType").ToList()); }
public static List <SizeRunModel> SelectByInsockRawMaterial() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <SizeRunModel>("EXEC spm_SelectSizeRunByInsockRawMaterial").ToList()); }
public static List <MachineRequirementAssemblyViewModel> SelectAssembly() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <MachineRequirementAssemblyViewModel>("EXEC spm_SelectMachineRequirementAssembly").ToList()); }
//spm_SelectSizeRunIsnable public static List <SizeRunModel> SelectIsEnable() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <SizeRunModel>("EXEC spm_SelectSizeRunIsnable").ToList()); }
public static List <UpperComponentRawMaterialModel> Select(string productNo) { var @ProductNo = new SqlParameter("@ProductNo", productNo); return(db.ExecuteStoreQuery <UpperComponentRawMaterialModel>("EXEC spm_SelectUpperComponentRawMaterialByProductNo @ProductNo", @ProductNo).ToList()); }
public static List <UpperComponentMaterialModel> Select() { return(db.ExecuteStoreQuery <UpperComponentMaterialModel>("EXEC spm_SelectUpperComponentMaterial").ToList()); }
public static List <OutsoleReleaseMaterialModel> SelectReportId() { SaovietMasterScheduleEntities db = new SaovietMasterScheduleEntities(); return(db.ExecuteStoreQuery <OutsoleReleaseMaterialModel>("EXEC spm_SelectOutsoleReleaseMaterialReportId_2").ToList()); }
public static List <OutsoleMaterialRejectIssuesModel> Select() { return(db.ExecuteStoreQuery <OutsoleMaterialRejectIssuesModel>("EXEC spm_SelectOutsoleMaterialRejectIssues").ToList()); }