private bool CheckUse(MSTS01P001Model dto) { string strSQL = @" SELECT COUNT(*) FROM VSMS_ISSUE A JOIN VSMS_MANDAY S ON A.COM_CODE = S.COM_CODE AND A.DEFECT = S.ISSUE_TYPE WHERE A.COM_CODE = @COM_CODE AND A.DEFECT = @DEFECT"; var parameters = CreateParameter(); parameters.AddParameter("COM_CODE", dto.COM_CODE); //checked parameters.AddParameter("DEFECT", dto.ISSUE_TYPE); // var result = _DBMangerNoEF.ExecuteNonQuery(strSQL, parameters, CommandType.Text); var result = _DBMangerNoEF.ExecuteDataSet(strSQL, parameters, commandType: CommandType.Text); bool isUse; string AA = string.Empty; if (result.Status) { AA = result.OutputDataSet.Tables[0].Rows[0][0].AsString(); } if (AA == "0") { isUse = false; } else { isUse = true; } return(isUse); }
public MSTS01P001DTO() { Model = new MSTS01P001Model(); // new โมเดล }