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