public void setjobDetail() {
Cursor cursor =
DatabaseView.query(
"SELECT * FROM ServiceJob, Purchase, Product, Company WHERE jobNo ='"
+ selectedjobNo
+ "'"
+ " AND Purchase.prodNo = Product.prodNo AND Purchase.comNo = Company.comNo AND Purchase.serialNo = ServiceJob.serialNo");
cursor.moveToFirst();
String _jobProblem = cursor.getString(cursor.getColumnIndex("jobProblem"));
String _jobSerialNo = cursor.getString(cursor.getColumnIndex("serialNo"));
String _jobRequestDate = cursor.getString(cursor.getColumnIndex("requestDate"));
String _jobVisitDate = cursor.getString(cursor.getColumnIndex("visitDate"));
String _jobStartTime = cursor.getString(cursor.getColumnIndex("jobStartTime"));
String _jobEndTime = cursor.getString(cursor.getColumnIndex("jobEndTime"));
String _jobRemark = cursor.getString(cursor.getColumnIndex("remark"));
companyID = cursor.getString(cursor.getColumnIndex("comNo"));
prodctID = cursor.getString(cursor.getColumnIndex("prodNo"));
jobNo.setText(selectedjobNo);
jobProblem.setText(_jobProblem);
jobSerialNo.setText(_jobSerialNo);
jobRequestDate.setText(_jobRequestDate);
jobVisitDate.setText(_jobVisitDate);
jobStartTime.setText(_jobStartTime);
jobEndTime.setText(_jobEndTime);
jobRemark.setText(_jobRemark);
jobCompany.setText(cursor.getString(cursor.getColumnIndex("comName")));
jobCompany.setOnClickListener(this);
productName.setText(cursor.getString(cursor.getColumnIndex("prodName")));
productName.setOnClickListener(this);
for (int i = 0; i < jobStatusItem.length; i++)
if (jobStatusItem[i].equalsIgnoreCase(cursor.getString(cursor.getColumnIndex("jobStatus"))))
jobStatus.setSelection(i);
}
