sqlcommand += m_information_code; sqlcommand += "','";

sqlcommand += m_service_type; sqlcommand += "','";

sqlcommand += m_name; sqlcommand += "','";

sqlcommand += m_address; sqlcommand += "','";

sqlcommand += m_phone; sqlcommand += "','";

sqlcommand += str_dating_time; sqlcommand += "','";

sqlcommand += m_brand; sqlcommand += "','";

sqlcommand += m_brand_type; sqlcommand += "','";

sqlcommand += m_sms_phone; sqlcommand += "','";

sqlcommand += str_send_time; sqlcommand += "','";

sqlcommand += m_send_operator; sqlcommand += "','";

sqlcommand += m_worker; sqlcommand += "','";

sqlcommand += m_need_charge; sqlcommand += "','";

sqlcommand += m_deliver; sqlcommand += "','";

sqlcommand += m_goods_source; sqlcommand += "','";

sqlcommand += m_store_type; sqlcommand += "','";

sqlcommand += m_bill_number; sqlcommand += "','";

sqlcommand += m_trans_man; sqlcommand += "','";

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

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

{

    AfxMessageBox("插入数据失败,请检查工单号是否重复");

    return;

}

CString str_now_time;

int status = 0;

str_now_time=CTime::GetCurrentTime().Format("%Y-%m-%d");

CString str_seq;

CString str_status;

str_seq.Format("%d",seq);

str_status.Format("%d",status);

sqlcommand =

        "insert into repair_relation(repair_id,seq,start_time,status)values('";

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

sqlcommand += str_seq;sqlcommand += ",'";