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