void __fastcall TfrmManage::TreeView1Change(TObject *Sender,
TTreeNode *Node)
{
AnsiString S1,S2,S3;
S1="%;";
S2=S_User_no;
S3=":%";
if(Node->Text=="收件箱"){
dmManage->qrySendInformation->Close();
dmManage->qrySendInformation->SQL->Clear();
dmManage->qrySendInformation->SQL->Add("select * from sendinformation where R_no=:user_no and reader_list not like :String and ban_reader_list not like :String and junk_reader_list not like :String");
dmManage->qrySendInformation->ParamByName("String")->AsString=StrCat(S1.c_str(),StrCat(S2.c_str(),S3.c_str()));
dmManage->qrySendInformation->ParamByName("user_no")->AsString=S_User_no;
dmManage->qrySendInformation->Prepare();
dmManage->qrySendInformation->Open();
pmuInsert->Enabled=false;
pmuDelete->Enabled=true;
pmuThrow->Enabled=true;
box=0;
}
else if(Node->Text=="发件箱"){
dmManage->qrySendInformation->Close();
dmManage->qrySendInformation->SQL->Clear();
dmManage->qrySendInformation->SQL->Add("select * from sendinformation where S_no=:user_no and ban_reader_list not like :String and junk_reader_list not like :String");
dmManage->qrySendInformation->ParamByName("String")->AsString=StrCat(S1.c_str(),StrCat(S2.c_str(),S3.c_str()));
dmManage->qrySendInformation->ParamByName("user_no")->AsString=S_User_no;
dmManage->qrySendInformation->Prepare();
dmManage->qrySendInformation->Open();
pmuInsert->Enabled=true;
pmuDelete->Enabled=false;
pmuThrow->Enabled=false;
box=1;
dmManage->dtsSendInformation->Enabled=true;
}
else if(Node->Text=="垃圾箱"){
dmManage->qrySendInformation->Close();
dmManage->qrySendInformation->SQL->Clear();
dmManage->qrySendInformation->SQL->Add("select * from sendinformation where (S_no=:user_no or R_no=:user_no) and junk_reader_list like :String");
dmManage->qrySendInformation->ParamByName("String")->AsString=StrCat(S1.c_str(),StrCat(S2.c_str(),S3.c_str()));
dmManage->qrySendInformation->ParamByName("user_no")->AsString=S_User_no;
dmManage->qrySendInformation->Prepare();
dmManage->qrySendInformation->Open();
pmuInsert->Enabled=false;
pmuDelete->Enabled=true;
pmuThrow->Enabled=false;
box=2;
dmManage->dtsSendInformation->Enabled=true;
}
else if(Node->Text=="收发信息"){
dmManage->qrySendInformation->Close();
dmManage->dtsSendInformation->Enabled=false;
dmManage->qrySendInformation->Prepare();
dmManage->qrySendInformation->Open();
}
}
//---------------------------------------------------------------------------