public List <ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence> InsertMove(ASSETKKF_MODEL.Request.Mcis.MtMoveOrderSequenceReq d)
{
// EmployeeId,WorkOrderId,WorkStationGrpCd_TO,MoveDate,MoveTime,User_Id,AppvCauseId,RemarkCause,CauseStatus
DynamicParameters param = new DynamicParameters();
param.Add("@_EmployeeId", d.EmployeeId);
param.Add("@_WorkOrderId", d.WorkOrderId);
param.Add("@_WorkStationGrpCd_TO", d.WorkStationGrpCd_TO);
param.Add("@_MoveDate", d.MoveDate);
param.Add("@_EndTime", d.EndTime);
param.Add("@_User_Id", d.User_Id);
param.Add("@_AppvCauseId", d.AppvCauseId);
param.Add("@_RemarkCause", d.RemarkCause);
param.Add("@_CauseStatus", d.CauseStatus);
string cmd = "EXEC[dbo].[MtMoveOrderSequenceInsert]" +
$" @EmployeeId = @_EmployeeId " +
$",@WorkOrderID = @_WorkOrderID " +
$",@WorkStationGrpCd_TO = @_WorkStationGrpCd_TO" +
$",@CauseStatus = @_CauseStatus" +
$",@RemarkCause = @_RemarkCause" +
$",@AppvCauseId = @_AppvCauseId" +
$",@User_Id = @_User_Id" +
$",@EndTime = @_EndTime" +
$",@MoveDate = @_MoveDate" +
$"" +
$"";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence>(cmd, param).ToList();
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence> Search(ASSETKKF_MODEL.Request.Mcis.MtMoveOrderSequenceReq d)
{
DynamicParameters param = new DynamicParameters();
/*
* param.Add("@SequenceIsNull", d.Sequence.ListNull());
* param.Add("@MoveDateIsNull", d.MoveDate.ListNull());
* param.Add("@MoveTimeIsNull", d.MoveTime.ListNull());
* param.Add("@EmployeeIdIsNull", d.EmployeeId.ListNull());
* param.Add("@WorkOrderIdIsNull", d.WorkOrderId.ListNull());
* param.Add("@DrawingCdIsNull", d.DrawingCd.ListNull());
* param.Add("@WorkStationGrpCd_FRIsNull", d.WorkStationGrpCd_FR.ListNull());
* param.Add("@WorkStationGrpCd_STDIsNull", d.WorkStationGrpCd_STD.ListNull());
* param.Add("@WorkStationGrpCd_TOIsNull", d.WorkStationGrpCd_TO.ListNull());
* param.Add("@SeqNo_NEXTIsNull", d.SeqNo_NEXT.ListNull());
* param.Add("@EndTimeIsNull", d.EndTime.ListNull());
* param.Add("@CauseStatusIsNull", d.CauseStatus.ListNull());
* param.Add("@RemarkCauseIsNull", d.RemarkCause.ListNull());
* param.Add("@AppvCauseIdIsNull", d.AppvCauseId.ListNull());
* param.Add("@AppvCauseDtIsNull", d.AppvCauseDt.ListNull());
* param.Add("@Process_FlagIsNull", d.Process_Flag.ListNull());
* param.Add("@User_IdIsNull", d.User_Id.ListNull());
* param.Add("@User_dateIsNull", d.User_date.ListNull());
* param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "";
/*
* string cmd = "SELECT * FROM mcis.dbo.MtMoveOrderSequence " +
* $"WHERE (@SequenceIsNull IS NULL OR Sequence IN ('{ d.Sequence.Join("','") }')) " +
* $"AND (@MoveDateIsNull IS NULL OR MoveDate IN ('{ d.MoveDate.Join("','") }')) " +
* $"AND (@MoveTimeIsNull IS NULL OR MoveTime IN ('{ d.MoveTime.Join("','") }')) " +
* $"AND (@EmployeeIdIsNull IS NULL OR EmployeeId IN ('{ d.EmployeeId.Join("','") }')) " +
* $"AND (@WorkOrderIdIsNull IS NULL OR WorkOrderId IN ('{ d.WorkOrderId.Join("','") }')) " +
* $"AND (@DrawingCdIsNull IS NULL OR DrawingCd IN ('{ d.DrawingCd.Join("','") }')) " +
* $"AND (@WorkStationGrpCd_FRIsNull IS NULL OR WorkStationGrpCd_FR IN ('{ d.WorkStationGrpCd_FR.Join("','") }')) " +
* $"AND (@WorkStationGrpCd_STDIsNull IS NULL OR WorkStationGrpCd_STD IN ('{ d.WorkStationGrpCd_STD.Join("','") }')) " +
* $"AND (@WorkStationGrpCd_TOIsNull IS NULL OR WorkStationGrpCd_TO IN ('{ d.WorkStationGrpCd_TO.Join("','") }')) " +
* $"AND (@SeqNo_NEXTIsNull IS NULL OR SeqNo_NEXT IN ('{ d.SeqNo_NEXT.Join("','") }')) " +
* $"AND (@EndTimeIsNull IS NULL OR EndTime IN ('{ d.EndTime.Join("','") }')) " +
* $"AND (@CauseStatusIsNull IS NULL OR CauseStatus IN ('{ d.CauseStatus.Join("','") }')) " +
* $"AND (@RemarkCauseIsNull IS NULL OR RemarkCause IN ('{ d.RemarkCause.Join("','") }')) " +
* $"AND (@AppvCauseIdIsNull IS NULL OR AppvCauseId IN ('{ d.AppvCauseId.Join("','") }')) " +
* $"AND (@AppvCauseDtIsNull IS NULL OR AppvCauseDt IN ('{ d.AppvCauseDt.Join("','") }')) " +
* $"AND (@Process_FlagIsNull IS NULL OR Process_Flag IN ('{ d.Process_Flag.Join("','") }')) " +
* $"AND (@User_IdIsNull IS NULL OR User_Id IN ('{ d.User_Id.Join("','") }')) " +
* $"AND (@User_dateIsNull IS NULL OR User_date IN ('{ d.User_date.Join("','") }')) " +
* $"AND (Sequence LIKE @txtSearch OR Sequence LIKE @txtSearch) " +
* //"ORDER BY ;";
*/
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence>(cmd, param).ToList();
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence> GetData(ASSETKKF_MODEL.Request.Mcis.MtMoveOrderSequenceReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@Sequence", d.Sequence);
param.Add("@EmployeeId", d.EmployeeId);
param.Add("@WorkOrderId", d.WorkOrderId);
param.Add("@DrawingCd", d.DrawingCd);
param.Add("@WorkStationGrpCd_FR", d.WorkStationGrpCd_FR);
param.Add("@WorkStationGrpCd_STD", d.WorkStationGrpCd_STD);
param.Add("@WorkStationGrpCd_TO", d.WorkStationGrpCd_TO);
/*
* param.Add("@MoveDate", d.MoveDate);
* param.Add("@MoveTime", d.MoveTime);
*
* param.Add("@SeqNo_NEXT", d.SeqNo_NEXT);
* param.Add("@EndTime", d.EndTime);
* param.Add("@CauseStatus", d.CauseStatus);
* param.Add("@RemarkCause", d.RemarkCause);
* param.Add("@AppvCauseId", d.AppvCauseId);
* param.Add("@AppvCauseDt", d.AppvCauseDt);
* param.Add("@Process_Flag", d.Process_Flag);
* param.Add("@User_Id", d.User_Id);
* param.Add("@User_date", d.User_date);
* //param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "SELECT * FROM mcis.dbo.MtMoveOrderSequence " +
$"WHERE (@Sequence IS NULL OR Sequence = @Sequence) " +
$" AND (@EmployeeId IS NULL OR EmployeeId = @EmployeeId) " +
$" AND (@WorkOrderId IS NULL OR WorkOrderId = @WorkOrderId) " +
$" AND (@DrawingCd IS NULL OR DrawingCd = @DrawingCd) " +
$" AND (@WorkStationGrpCd_FR IS NULL OR WorkStationGrpCd_FR = @WorkStationGrpCd_FR) " +
$" AND (@WorkStationGrpCd_STD IS NULL OR WorkStationGrpCd_STD = @WorkStationGrpCd_STD) " +
$" AND (@WorkStationGrpCd_TO IS NULL OR WorkStationGrpCd_TO = @WorkStationGrpCd_TO) " +
/*
* $" AND (@MoveDate IS NULL OR MoveDate = @MoveDate) " +
* $" AND (@MoveTime IS NULL OR MoveTime = @MoveTime) " +
*
* $" AND (@SeqNo_NEXT IS NULL OR SeqNo_NEXT = @SeqNo_NEXT) " +
* $" AND (@EndTime IS NULL OR EndTime = @EndTime) " +
* $" AND (@CauseStatus IS NULL OR CauseStatus = @CauseStatus) " +
* $" AND (@RemarkCause IS NULL OR RemarkCause = @RemarkCause) " +
* $" AND (@AppvCauseId IS NULL OR AppvCauseId = @AppvCauseId) " +
* $" AND (@AppvCauseDt IS NULL OR AppvCauseDt = @AppvCauseDt) " +
* $" AND (@Process_Flag IS NULL OR Process_Flag = @Process_Flag) " +
* $" AND (@User_Id IS NULL OR User_Id = @User_Id) " +
* $" AND (@User_date IS NULL OR User_date = @User_date) " +*/
//$"AND (Sequence LIKE @txtSearch OR Sequence LIKE @txtSearch) " +
$"ORDER BY Sequence;";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence>(cmd, param).ToList();
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.GetNextWorkStationGrp> GetNextWorkStationGrp(ASSETKKF_MODEL.Request.Mcis.MtMoveOrderSequenceReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@WorkOrderId_move", d.WorkOrderId);
//param.Add("@Process_Flag", d.Process_Flag);
string cmd = "EXEC [dbo].[GetNextWorkStationGrp] " +
$" @WorkOrderId = @WorkOrderId_move ";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.GetNextWorkStationGrp>(cmd, param).ToList();
return(res);
}
