//查询未交费记录
AnsiString SQL1;
//if (Form1->CheckBox1->Checked==true)
//SQL1= "SELECT userno,begindate,show,use,money,prices,wokercode FROM d_test ";
//else
SQL1= "SELECT userno,begindate,show,use,money,prices,wokercode FROM detail ";
SQL1+="WHERE userno=:userno and flag=0 and money!=0 and begindate!="+StrToDate(fun_GetDateTime(1,3));
SQL1+="order by begindate ";
//查询用户档案信息
AnsiString SQL2="SELECT userno,username,addressname,room FROM view_user WHERE userno=:userno";
//try
//{
// savelog("数据查询开始");
// Query3->Open();
TQuery *Query1;
Query1 = new TQuery(NULL);
Query1->DatabaseName="gas";//"gas";
//Query1->Tem
TQuery *Query1;
Query1 = new TQuery(NULL);
Query1->DatabaseName="gas";;//fun_Ini("Server.INI","Dataserver","DatabaseName","",1);
Query1->Close();
Query1->SQL->Clear();
//if (Form1->CheckBox1->Checked==true)
// Query1->SQL->Add("update d_test set latefee=:latefee,inmoney=:inmoney,enddate=:enddate,operaterno=:operaterno,flag=2,summary=:summary ");
//else
Query1->SQL->Add("update detail set latefee=:latefee,inmoney=:inmoney,enddate=:enddate,operaterno=:operaterno,flag=2,summary=:summary ");
Query1->SQL->Add("WHERE userno=:userno and begindate=:begindate and money=:money and flag=0");
int e=13;
for (int t=1;t<=StrToInt(Dmc_s[7]);t++)
{
Query1->ParamByName("userno")->AsString=Dmc_s[2];
Query1->ParamByName("enddate")->AsString=fun_GetDateTime(1,3);
Query1->ParamByName("operaterno")->AsString=Dmc_s[3];
Query1->ParamByName("summary")->AsString=Dmc_s[4];