private MSTS01P001DTO GetAll(MSTS01P001DTO dto)
{
string strSQL = @" SELECT *
FROM [dbo].[VSMS_MANDAY]
WHERE (1=1) ";
var parameters = CreateParameter();
if (!dto.Model.APP_CODE.IsNullOrEmpty()) //checked
{
strSQL += " AND COM_CODE = @COM_CODE";
parameters.AddParameter("COM_CODE", dto.Model.APP_CODE);
}
if (!dto.Model.ISSUE_TYPE.IsNullOrEmpty())
{
strSQL += " AND ISSUE_TYPE = @ISSUE_TYPE";
parameters.AddParameter("ISSUE_TYPE", dto.Model.ISSUE_TYPE);
}
if (!dto.Model.TYPE_RATE.IsNullOrEmpty())
{
strSQL += " AND TYPE_RATE = @TYPE_RATE";
parameters.AddParameter("TYPE_RATE", dto.Model.TYPE_RATE);
}
var result = _DBMangerNoEF.ExecuteDataSet(strSQL, parameters, commandType: CommandType.Text);
if (result.Success(dto))
{
dto.Models = result.OutputDataSet.Tables[0].ToList <MSTS01P001Model>();
}
return(dto);
}
private MSTS01P001DTO GetByID(MSTS01P001DTO dto)
{
string strSQL = @" SELECT *
FROM [dbo].[VSMS_MANDAY]
WHERE (1=1) AND COM_CODE = @COM_CODE
AND TYPE_RATE = @TYPE_RATE
AND ISSUE_TYPE = @ISSUE_TYPE";
var parameters = CreateParameter();
parameters.AddParameter("TYPE_RATE", dto.Model.TYPE_RATE);
parameters.AddParameter("ISSUE_TYPE", dto.Model.ISSUE_TYPE);
parameters.AddParameter("COM_CODE", dto.Model.COM_CODE); //checked
var result = _DBMangerNoEF.ExecuteDataSet(strSQL, parameters, commandType: CommandType.Text);
if (result.Success(dto))
{
dto.Model = result.OutputDataSet.Tables[0].ToObject <MSTS01P001Model>();
dto.Model.APP_CODE = dto.Model.COM_CODE; //checked
}
return(dto);
}
public MSTS01P001DA()
{
DTO = new MSTS01P001DTO();
}
