Deceptive type of reference .... Output to see what the results are.
queue<parainfo> strstranlist = new queue<parainfo> (); StringBuilder strSQL = new StringBuilder (); Strsql.append ("Update jia72_members Set"); Strsql.append ("[email protected],"); Strsql.append ("[email protected],"); Strsql.append ("[email protected],"); Strsql.append ("[email protected],"); Strsql.append ("[email protected],"); Strsql.append ("[email protected],"); Strsql.append ("[email protected],"); Strsql.append ("[email protected]"); Strsql.append ("Where [email protected]"); String strsqlm = Strsql.tostring (); sqlparameter[] Parameters = {New SqlParameter ("@Id", sqldbtype.int,4), New SqlParameter ("@UserName", sqldbtype.nvarchar,20), New SqlParameter ("@YTCardId", sqldbtype.int,4), New SqlParameter ("@CardNum", sqldbtype.nvarchar,20), New SqlParameter ("@Bank", Sqldbtype.nvarchar,50), New SqlParameter ("@BankNumber", sqldbtype.nvarchar,32), New SqlParameter ("@QQNumber", sqldbtype.nvarchar,50), New SqlParameter ("@RealName", sqldbtype.nvarchar,10), New SqlParameter ("@SavedOn", Sqldbtype.datetime)}; Parameters[0]. Value = model. Id; PARAMETERS[1]. Value = model. UserName; PARAMETERS[2]. Value = model. Ytcardid; PARAMETERS[3]. Value = model. Cardnum; PARAMETERS[4]. Value = model. Bank; PARAMETERS[5]. Value = model. Banknumber; PARAMETERS[6]. Value = model. Qqnumber; PARAMETERS[7]. Value = model. Realname; PARAMETERS[8]. Value = model. Savedon; Dbutility.parainfo dbcom = new Dbutility.parainfo (strsql.tostring (), parameters); Strstranlist.enqueue (dbcom);//BIND member information//Update card table Strsql.clear (); Strsql.append ("Update jia72_ytcard set"); Strsql.append ("ISbind=1, "); Strsql.append ("Savedon=getdate ()"); Strsql.append ("where id=" + model.) Ytcardid); Dbutility.parainfo dbcom1 = new Dbutility.parainfo (strsql.tostring (), NULL); Strstranlist.enqueue (DBCOM1);//BIND member information//Update card table bindings
while (Strstranlist.count > 0) { Parainfo Myde = Strstranlist.peek (); String cmdtext = MyDE.strSql.ToString (); Response.Write (Cmdtext.tostring ()); Response.Write ("<br/>"); if (myde.par! = null) { sqlparameter[] cmdparms = (sqlparameter[]) Myde.par; foreach (SqlParameter parm in cmdparms) { Response.Write (parm. Parametername.tostring () + "" + parm. Value.tostring () + ""); } Response.Write ("<br/>"); } Strstranlist.dequeue (); }
Queue output data