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