private MISS01P003DTO ConfirmStatus(MISS01P003DTO dto) { var parameters = CreateParameter(); parameters.AddParameter("error_code", null, ParameterDirection.Output); parameters.AddParameter("ISE_KEY", dto.Model.ISE_KEY); parameters.AddParameter("COM_CODE", dto.Model.COM_CODE); parameters.AddParameter("FALG", dto.Model.FALG); parameters.AddParameter("NO", dto.Model.ISE_NO); parameters.AddParameter("CRET_BY", dto.Model.CRET_BY); parameters.AddParameter("CRET_DATE", dto.Model.CRET_DATE); var result = _DBMangerNoEF.ExecuteDataSet("[bond].[SP_VSMS_ISSTATOPSS_003]", parameters); if (!result.Status) { dto.Result.IsResult = false; dto.Result.ResultMsg = result.ErrorMessage; dto.Model.FALG = "F"; } else { if (result.OutputData["error_code"].ToString().Trim() != "0") { dto.Result.IsResult = false; dto.Result.ResultMsg = result.OutputData["error_code"].ToString().Trim(); } else { dto.Model.FALG = "T"; } } return(dto); }
private MISS01P003DTO SolutionResult(MISS01P003DTO dto) { string strSQL = @" SELECT a.COM_CODE AS APP_CODE ,aa.COM_NAME_E ,aa.COM_NAME_T ,a.ISSUE_DATE ,a.SOLUTION ,a.NO AS ISE_NO ,a.RESPONSE_BY FROM VSMS_ISSUE a INNER JOIN VSMS_COMPANY aa ON a.COM_CODE = aa.COM_CODE WHERE a.COM_CODE = @COM_CODE AND a.NO = @NO"; var parameters = CreateParameter(); parameters.AddParameter("COM_CODE", dto.Model.COM_CODE); parameters.AddParameter("NO", dto.Model.ISE_NO); //cheked var result = _DBMangerNoEF.ExecuteDataSet(strSQL, parameters, commandType: CommandType.Text); if (result.Success(dto)) { dto.Model = result.OutputDataSet.Tables[0].ToObject <MISS01P003Model>(); } return(dto); }
private MISS01P003DTO GetAll2(MISS01P003DTO dto) { string strSQL = string.Empty; strSQL = @" SELECT t.COM_CODE ,t.ISE_NO ,t.RESPONSE_BY ,t.ISE_DATE_OPENING ,t.ASSIGN_STATUS ,tt.COM_NAME_E ,t.ISE_KEY FROM VSMS_COMPANY tt INNER JOIN ( SELECT t.COM_CODE ,t.ISE_NO ,tt.RESPONSE_BY ,t.ISE_DATE_OPENING ,t.ASSIGN_STATUS ,t.ISE_KEY FROM VSMS_ISSTATOPSS t INNER JOIN VSMS_ISSUE tt ON t.COM_CODE = tt.COM_CODE AND t.ISE_NO = tt.no WHERE t.USER_ID = @USER_ID ) t ON t.COM_CODE = tt.COM_CODE AND t.ASSIGN_STATUS = 'W' "; var parameters = CreateParameter(); parameters.AddParameter("USER_ID", dto.Model.CRET_BY); if (!dto.Model.APP_CODE.IsNullOrEmpty()) { strSQL += " AND t.COM_CODE = @APP_CODE"; parameters.AddParameter("APP_CODE", dto.Model.APP_CODE); } //if (!dto.Model.STATUS.IsNullOrEmpty()) //{ // strSQL += " AND t.ASSIGN_STATUS = @STATUS"; // parameters.AddParameter("STATUS", dto.Model.STATUS); //} //else if (dto.Model.STATUS.IsNullOrEmpty()) //{ // strSQL += " AND t.ASSIGN_STATUS != 'W'"; //} var result = _DBMangerNoEF.ExecuteDataSet(strSQL, parameters, commandType: CommandType.Text); if (result.Success(dto)) { dto.Models = result.OutputDataSet.Tables[0].ToList <MISS01P003Model>(); } return(dto); }
private MISS01P003DTO UpdateSolutionResult(MISS01P003DTO dto) { string strSQL = @" update VSMS_ISSUE set SOLUTION = @SOLUTION where COM_CODE = @COM_CODE and NO = @NO"; var parameters = CreateParameter(); parameters.AddParameter("SOLUTION", dto.Model.SOLUTION); parameters.AddParameter("NO", dto.Model.ISE_NO); parameters.AddParameter("COM_CODE", dto.Model.COM_CODE); var result = _DBMangerNoEF.ExecuteDataSet(strSQL, parameters, commandType: CommandType.Text); if (!result.Status) { dto.Result.IsResult = false; dto.Result.ResultMsg = result.ErrorMessage; } return(dto); }
private MISS01P003DTO Insert(MISS01P003DTO dto) { return(dto); }
private MISS01P003DTO GetFilePacket(MISS01P003DTO dto) { return(dto); }
public MISS01P003DA() { DTO = new MISS01P003DTO(); }