sqlcommand="insert into postrepair(repair_id,finish_time,accept_man,manager_charge,fac_settle_time,type,inner_type,outter_type,fac_settle_charge,assign_charge,first_man_charge,second_man_charge,accept_charge,charge_reason,charge_num,remark)values(";

sqlcommand += "'";

sqlcommand += m_id; sqlcommand += "','";

sqlcommand += str_finish_time; sqlcommand += "','";

sqlcommand += m_accept_man; sqlcommand += "','";

sqlcommand += m_manager_charge; sqlcommand += "','";

sqlcommand += str_fac_settle_time; sqlcommand += "','";

sqlcommand += m_type; sqlcommand += "','";

sqlcommand += m_inner_type; sqlcommand += "','";

sqlcommand += m_outter_type; sqlcommand += "','";

sqlcommand += m_fac_settle_charge; sqlcommand += "','";

sqlcommand += m_assign_charge; sqlcommand += "','";

sqlcommand += m_first_man_charge; sqlcommand += "','";

sqlcommand += m_second_man_charge; sqlcommand += "','";

sqlcommand += m_accept_charge; sqlcommand += "','";

sqlcommand += m_charge_reason; sqlcommand += "','";

sqlcommand += m_charge_num; sqlcommand += "','";

sqlcommand += m_memo; sqlcommand += "')";

if(!((CRepairServiceApp*)AfxGetApp())->g_pDb->Execute(sqlcommand))

{

    AfxMessageBox("不能重复结算!");

    return;

}

sqlcommand = " update repair_relation set status = 1 where repair_id =  '";

sqlcommand += m_id;

sqlcommand += "'";