/**
* Query Q&A<br>
* Query all questions or query by asker. Questions include answered questions and not answered,
* show not answered by default
*
* @param balanceQAForm BalanceQAForm Q&A form,include query conditions input by user
* @return ArrayList Return query results
*/
public ArrayList list(BalanceQAForm balanceQAForm) {
List dataList = new ArrayList();
ArrayList alData = new ArrayList();
String answer = balanceQAForm.getAnswerTag();
if (answer == null || answer.equals("")) {
answer = "N";
balanceQAForm.setAnswerTag(answer);
} else if (answer.equals("00")) {
balanceQAForm.setAnswerTag("");
}
ASCQAQuery uq = new ASCQAQuery(balanceQAForm);
int count = 0;
try {
dataList = uq.doListQuery(balanceQAForm.getFromPage(), balanceQAForm.getToPage());
count = uq.doCountQuery();
BalanceQAForm uf = new BalanceQAForm();
RoleForm rf = null;
// System.out.println("dataList.size is : "+dataList.size());
for (int i = 0; i < dataList.size(); i++) {
String[] data = new String[12];
uf = (BalanceQAForm) dataList.get(i);
// System.out.println("uf.answerTag is :"+uf.getAnswerTag());
data[0] = uf.getServiceSheetNo() == null ? "" : uf.getServiceSheetNo();
data[1] = uf.getModelCode() == null ? "" : uf.getModelCode();
data[2] = uf.getSerialNo() == null ? "" : uf.getSerialNo();
data[3] = uf.getWarrantyCardNo() == null ? "" : uf.getWarrantyCardNo();
data[4] = uf.getInvoiceNo() == null ? "" : uf.getInvoiceNo();
data[5] = CommonSearch.getSystemName("QUESTION_ER", uf.getQuestionRoleBy().toString());
data[6] = uf.getQuestionContent() == null ? "" : uf.getQuestionContent();
data[7] = uf.getQuestionId() == null ? "" : uf.getQuestionId().toString();
data[8] = uf.getQuestionRoleBy() == null ? "" : uf.getQuestionRoleBy().toString();
data[9] = CommonSearch.getSystemName("QUESTION_ER", uf.getQuestionTarget().toString());
data[10] = uf.getCreateDate() == null ? "" : uf.getCreateDate().toString();
data[11] =
CommonSearch.getSystemName(
"QUESTION_ER", uf.getCopyRoleBy() == null ? "" : uf.getCopyRoleBy().toString());
/*Iterator it = uf.getQuestContent().iterator();
while (it.hasNext()) {
data[0] = uf.getServiceSheetNo()==null?"":uf.getServiceSheetNo();
data[1] = uf.getModelCode()==null?"":uf.getModelCode();
data[2] = uf.getSerialNo()==null?"":uf.getSerialNo();
data[3] = uf.getWarrantyCardNo()==null?"":uf.getWarrantyCardNo();
data[4] = uf.getInvoiceNo()==null?"":uf.getInvoiceNo();
//if(uf.getQuestionRoleBy()!=null){
TdQuestForm element =(TdQuestForm) it.next();
RoleBo rb=new RoleBo();
// if(element.getFormType().equals("B")){
rf=rb.find(element.getQuestionRoleBy().toString());
data[5] = rf.getRoleName()==null?"":rf.getRoleName();
// modified by xt System.out.println("roleName questionRoleById====="+element.getQuestionRoleBy());
data[6] = element.getQuestionContent()==null?"":element.getQuestionContent();
//}
//}
data[7] = element.getQuestionId()==null?"":element.getQuestionId().toString();
//data[8] =uf.getQuestionRoleBy()==null?"":uf.getQuestionRoleBy().toString();
alData.add(data);
} */
alData.add(data);
}
// System.out.println("answer type is :"+answer);
alData.add(0, count + "");
} catch (Exception e) {
e.printStackTrace();
} finally {
}
return alData;
}
