a.information_source ,a.sms_phone ,a.worker ,a.goods_source ,b.manager_charge ,b.fac_settle_time ,\

b.type ,b.fac_settle_charge ,b.assign_charge ,b.first_man_charge ,b.second_man_charge ,b.accept_charge ,\

b.remark  from prerepair a,postrepair b where a.repair_id = b.repair_id and a.sms_phone='";

sqlcommand +=m_username;

sqlcommand +="'";

}

else if(m_type==1)/*工单*/

{

    if(m_jobseq =="")

    {

        AfxMessageBox("工单号不允许为空");

        return;

    }

 }

else

{

    AfxMessageBox(m_type);

    AfxMessageBox("请选择查询类型");

    return;

}