public static List <WorkerLeaveModel> Select(string workerId) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @WorkerId = new SqlParameter("@WorkerId", workerId); return(db.ExecuteStoreQuery <WorkerLeaveModel>("EXEC spm_SelectWorkerLeaveByWorkerId @WorkerId", @WorkerId).ToList()); }
public static List <PersonalModel> Get(string department) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @Department = new SqlParameter("@Department", department); return(db.ExecuteStoreQuery <PersonalModel>("EXEC sp_c_SelectPersonalByDepartment @Department", @Department).ToList()); }
public static WorkTimeInfoModel Select(string worktimeCode) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @WorkTimeInfoCode = new SqlParameter("@WorkTimeInfoCode", worktimeCode); return(db.ExecuteStoreQuery <WorkTimeInfoModel>("EXEC spw_SelectWorkTimeInfo @WorkTimeInfoCode", @WorkTimeInfoCode).FirstOrDefault()); }
public static List <AssemblyIncentiveModel> Select(string PM) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @PatternNo = new SqlParameter("@PatternNo", PM); return(db.ExecuteStoreQuery <AssemblyIncentiveModel>("EXEC spm_SelectAssemblyIncentive @PatternNo", @PatternNo).ToList()); }
public static List <WorkerLoginModel> Select(DateTime createdTime) { var @CreatedTime = new SqlParameter("@CreatedTime", createdTime); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <WorkerLoginModel>("EXEC spm_SelectWorkerLoginByCreatedTime @CreatedTime", @CreatedTime).ToList()); }
public static List <LineModel> Select(string sectionId) { var @SectionId = new SqlParameter("@SectionId", sectionId); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <LineModel>("EXEC spm_SelectLineBySectionId @SectionId", @SectionId).ToList()); }
public static List <LinePerformanceDetailModel> SelectByWorkerLogin(string lineId, DateTime date) { var @LineId = new SqlParameter("@LineId", lineId); var @CreatedTime = new SqlParameter("@CreatedTime", date); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <LinePerformanceDetailModel>("EXEC spm_SelectLinePerformanceDetailByWorkerLoginByLineIdCreatedTime @LineId, @CreatedTime", @LineId, @CreatedTime).ToList()); }
public static LinePerformanceDetailModel SelectTop1(string cardId, DateTime date) { var @CardId = new SqlParameter("@CardId", cardId); var @Date = new SqlParameter("@Date", date); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <LinePerformanceDetailModel>("EXEC spm_SelectLinePerformanceDetailByCardIdDate @CardId, @Date", @CardId, @Date).FirstOrDefault()); }
public static List <SpecialTransferModel> Select(string lineId, DateTime date) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @DestinationLineId = new SqlParameter("@DestinationLineId", lineId); var @Date = new SqlParameter("@Date", date); return(db.ExecuteStoreQuery <SpecialTransferModel>("EXEC spm_SelectWorkerLeaveByLineIdDate @DestinationLineId, @Date", @DestinationLineId, @Date).ToList()); }
public static List <LinePerformanceDetailModel> SelectBySection(string sectionId, DateTime date) { var @SectionId = new SqlParameter("@SectionId", sectionId); var @Date = new SqlParameter("@Date", date); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <LinePerformanceDetailModel>("EXEC spm_SelectLinePerformanceDetailByDateLineBySectionId @Date, @SectionId", @Date, @SectionId).ToList()); }
public static List <HolidayModel> Select(int year, int month) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @Year = new SqlParameter("@Year", year); var @Month = new SqlParameter("@Month", month); return(db.ExecuteStoreQuery <HolidayModel>("EXEC spm_SelectHolidayByYearMonth @Year, @Month", @Year, @Month).ToList()); }
public static List <WorkerLoginModel> SelectByLine(string sectionId, DateTime createdTime) { var @CreatedTime = new SqlParameter("@CreatedTime", createdTime); var @SectionId = new SqlParameter("@SectionId", sectionId); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <WorkerLoginModel>("EXEC spm_SelectWorkerLoginByCreatedTimeLineBySectionId @CreatedTime, @SectionId", @CreatedTime, @SectionId).ToList()); }
public static LinePerformanceModel Select(string lineId, DateTime date) { var @LineId = new SqlParameter("@LineId", lineId); var @Date = new SqlParameter("@Date", date); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <LinePerformanceModel>("EXEC spm_SelectLinePerformanceByLineIdDate @LineId, @Date", @LineId, @Date).FirstOrDefault()); }
public static CieControlIncentiveModel Select(string lineId, DateTime requestTime) { var @LineId = new SqlParameter("@LineId", lineId); var @RequestTime = new SqlParameter("@RequestTime", requestTime); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <CieControlIncentiveModel>("EXEC spm_SelectCieControlIncentive @LineId,@RequestTime", @LineId, @RequestTime).FirstOrDefault()); }
public static List <SourceModel> Get(string line, DateTime date) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @Line = new SqlParameter("@Line", line); var @Date = new SqlParameter("@Date", date); return(db.ExecuteStoreQuery <SourceModel>("EXEC sp_c_SelectSourceByLineDate @Line, @Date", @Line, @Date).ToList()); }
public static WorkerLoginModel SelectTop1(string cardId, DateTime createdTime) { var @CardId = new SqlParameter("@CardId", cardId); var @CreatedTime = new SqlParameter("@CreatedTime", createdTime); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <WorkerLoginModel>("EXEC spm_SelectWorkerLoginByCardIdDate @CardId, @CreatedTime", @CardId, @CreatedTime).First()); }
public static List <WorkerLoginModel> Select(int year, int month) { //var @LineId = new SqlParameter("@LineId", lineId); var @Year = new SqlParameter("@Year", year); var @Month = new SqlParameter("@Month", month); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <WorkerLoginModel>("EXEC spm_SelectWorkerLoginByYearMonth @Year, @Month", @Year, @Month).ToList()); }
public static List <LinePerformanceModel> Select(string lineId, int month, int year) { var @LineId = new SqlParameter("@LineId", lineId); var @Month = new SqlParameter("@Month", month); var @Year = new SqlParameter("@Year", year); SaovietCheckInEntities db = new SaovietCheckInEntities(); return(db.ExecuteStoreQuery <LinePerformanceModel>("EXEC spm_SelectLinePerformanceByLineIdMonthYear @LineId, @Month, @Year", @LineId, @Month, @Year).ToList()); }
public static List <WorkerLeaveModel> Select(int year, int leaveType, string line) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @Year = new SqlParameter("@Year", year); var @LeaveType = new SqlParameter("@LeaveType", leaveType); var @Line = new SqlParameter("@Line", line); return(db.ExecuteStoreQuery <WorkerLeaveModel>("EXEC spm_SelectWorkerLeaveByYearLeaveTypeByPersonalByLine @Year,@LeaveType,@Line", @Year, @LeaveType, @Line).ToList()); }
public static WorkerShiftModel Select(string workerId, int year, int month) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @WorkerId = new SqlParameter("@WorkerId", workerId); var @Year = new SqlParameter("@Year", year); var @Month = new SqlParameter("@Month", month); return(db.ExecuteStoreQuery <WorkerShiftModel>("EXEC spw_SelectWorkerShift @WorkerId, @Year, @Month", @WorkerId, @Year, @Month).FirstOrDefault()); }
public static List <SourceModel> Select(string department, int year, int month) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @Line = new SqlParameter("@Line", department); var @Year = new SqlParameter("@Year", year); var @Month = new SqlParameter("@Month", month); return(db.ExecuteStoreQuery <SourceModel>("EXEC sp_c_SelectSourceByLineYearMonth @Line, @Year, @Month", @Line, @Year, @Month).ToList()); }
public static List <LinePerformanceDetailModel> SelectByPersonal(string line, int year, int month) { var @Line = new SqlParameter("@Line", line); var @Year = new SqlParameter("@Year", year); var @Month = new SqlParameter("@Month", month); SaovietCheckInEntities db = new SaovietCheckInEntities(); db.CommandTimeout = 180; return(db.ExecuteStoreQuery <LinePerformanceDetailModel>("EXEC spm_SelectLinePerformanceDetailByYearMonthByPersonalByLine @Year, @Month, @Line", @Year, @Month, @Line).ToList()); }
public static bool Delete(string patternNo) { var @PatternNo = new SqlParameter("@PatternNo", patternNo); SaovietCheckInEntities db = new SaovietCheckInEntities(); if (db.ExecuteStoreCommand("EXEC spm_DeleteAssemblyIncentive @PatternNo", @PatternNo) >= 1) { return(true); } return(false); }
//public static bool Update(WorkerLeaveModel model) //{ // SaovietCheckInEntities db = new SaovietCheckInEntities(); // var @WorkerLeaveId = new SqlParameter("@WorkerLeaveId", model.WorkerLeaveId); // var @WorkerId = new SqlParameter("@WorkerId", model.WorkerId); // var @StartDate = new SqlParameter("@StartDate", model.StartDate); // var @EndDate = new SqlParameter("@EndDate", model.EndDate); // var @LeaveType = new SqlParameter("@LeaveType", model.LeaveType); // if (db.ExecuteStoreCommand("EXEC spm_UpdateWorkerLeave_1 @WorkerLeaveId, @WorkerId, @StartDate, @EndDate, @LeaveType", @WorkerLeaveId, @WorkerId, @StartDate, @EndDate, @LeaveType) > 0) // { // return true; // } // return false; //} public static bool Delete(int id) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @SpecialTransferId = new SqlParameter("@SpecialTransferId", id); if (db.ExecuteStoreCommand("EXEC spm_DeleteSpecialTransfer @SpecialTransferId", @SpecialTransferId) > 0) { return(true); } return(false); }
public static bool Delete(int workerLeaveId) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @WorkerLeaveId = new SqlParameter("@WorkerLeaveId", workerLeaveId); if (db.ExecuteStoreCommand("EXEC spm_DeleteWorkerLeave @WorkerLeaveId", @WorkerLeaveId) > 0) { return(true); } return(false); }
public static List <PersonalModel> Select(string departments) { SaovietCheckInEntities db = new SaovietCheckInEntities(); List <PersonalModel> personalList = new List <PersonalModel>(); foreach (string department in departments.Split(',')) { var @Department = new SqlParameter("@Department", department); personalList.AddRange(db.ExecuteStoreQuery <PersonalModel>("EXEC sp_c_SelectPersonalByDepartment @Department", @Department).ToList()); } return(personalList); }
public static bool ChangeWorkerId(string workerId, string newWorkerId) { SaovietCheckInEntities db = new SaovietCheckInEntities(); var @WorkerId = new SqlParameter("@WorkerId", workerId); var @NewWorkerId = new SqlParameter("@NewWorkerId", newWorkerId); if (db.ExecuteStoreCommand("spm_UpdateWorkerId @WorkerId, @NewWorkerId", @WorkerId, @NewWorkerId) > 0) { return(true); } return(false); }
public static bool Insert(WorkerLoginModel model) { var @CardId = new SqlParameter("@CardId", model.CardId); var @WorkerId = new SqlParameter("@WorkerId", model.WorkerId); var @LineId = new SqlParameter("@LineId", model.LineId); SaovietCheckInEntities db = new SaovietCheckInEntities(); if (db.ExecuteStoreCommand("EXEC spm_InsertWorkerLogin @CardId,@WorkerId,@LineId", @CardId, @WorkerId, @LineId) >= 1) { return(true); } return(false); }
public static List <SourceModel> Select(string departments, DateTime date) { SaovietCheckInEntities db = new SaovietCheckInEntities(); List <SourceModel> sourceList = new List <SourceModel>(); foreach (string department in departments.Split(',')) { var @Line = new SqlParameter("@Line", department); var @Date = new SqlParameter("@Date", date); sourceList.AddRange(db.ExecuteStoreQuery <SourceModel>("EXEC sp_c_SelectSourceByLineDate @Line, @Date", @Line, @Date).ToList()); } return(sourceList); }
public static bool Update(string lineId, DateTime requestTime, DateTime acceptedTime) { var @LineId = new SqlParameter("@LineId", lineId); var @RequestTime = new SqlParameter("@RequestTime", requestTime); var @AcceptedTime = new SqlParameter("@AcceptedTime", acceptedTime); SaovietCheckInEntities db = new SaovietCheckInEntities(); if (db.ExecuteStoreCommand("EXEC spm_UpdateCieControlIncentive @LineId, @RequestTime,@AcceptedTime", @LineId, @RequestTime, @AcceptedTime) >= 1) { return(true); } return(false); }