int load_over()
{
string sql,ebaIds,touch_purpose,touch_ids,touch_id,eba_name,office_no,mobile_no;
int count,i;
count=grid_row_num("MG");
touch_ids="";
for(i=1;i<count;i++){
if(touch_ids==""){
touch_ids=grid_get_v("MG","touch_id",i);
}else{
touch_ids=touch_ids+","+grid_get_v("MG","touch_id",i);
}
}
if(touch_ids==""){
return 1;
}
sql="select a.touch_id,b.eba_name,b.office_no,b.mobile_no from crm_touch a,crm_clew b where a.eba_id=CAST(b.clew_id AS varchar(16)) and a.touch_purpose='B' and a.touch_id in("+touch_ids+")";
db_run(sql);
count=db_row_count();
if(count==0){
return 1;
}
touch_ids="";
for(i=0;i<count;i++){
db_go_row(i);
touch_id=db_res(0);
eba_name=db_res(1);
office_no=db_res(2);
mobile_no=db_res(3);
user_para_set(touch_id+"_eba_name",eba_name);
user_para_set(touch_id+"_office_no",office_no);
user_para_set(touch_id+"_mobile_no",mobile_no);
if(touch_ids==""){
touch_ids=touch_id;
}else{
touch_ids=touch_ids+","+touch_id;
}
}
count=grid_row_num("MG");
for(i=1;i<count;i++){
touch_id=grid_get_v("MG","touch_id",i);
if(str_pos(","+touch_ids+",",","+touch_id+",")>=0){
grid_set_v("MG","eba_id",i,user_para_get(touch_id+"_eba_name"));
grid_set_v("MG","office_no",i,user_para_get(touch_id+"_office_no"));
grid_set_v("MG","mobile_no",i,user_para_get(touch_id+"_mobile_no"));
}
}
return 1;
}; |
