我已经全部关闭了,我检查了好久了,
源程序是这样的
SqlConnection conn=new SqlConnection();
conn.ConnectionString=G.GetSqlConnectString(Page);
SqlCommand command=new SqlCommand();
command.Connection=conn;
conn.Open();SqlTransaction trans;
trans=conn.BeginTransaction();command.Transaction=trans;for (int i = 0; i < Controls.Count; i++)
{
if ((Controls[i] is Label) && (Controls[i + 3] is UnitChange) )
{
friedidandname = ((Label) Controls[i]).Text;
num = ((UnitChange) Controls[i + 3]).m_Interface.IGetNum();
opera = ((DropDownListEx) Controls[i + 7]).SelectedItem.Text;
serialno = ((DropDownListEx) Controls[i + 8]).SelectedItem.Text;
if (num > 0)
// 找商品编码
friedid = friedidandname.Substring(1,friedidandname.IndexOf("]") - 1);
id = this.GetIDFromFriendID(friedid); switch (opera)
{
case "=":
maxno = serialno;
minno = serialno;
command.CommandText="insert into TCustomerOrder (OrderID,CommodityID,StartSerialNo,EndSerialNo,Num) values ('"+this.OrderID+"','"+id+"','"+minno+"','"+maxno+"','"+num+"' )";
break;
case ">=":
minno = serialno;
command.CommandText="insert into TCustomerOrder (OrderID,CommodityID,StartSerialNo,Num) values ('"+this.OrderID+"','"+id+"','"+minno+"','"+num+"' )";
break;
}
success=command.ExecuteNonQuery();
i += 8;
}
}
}
trans.Commit();
conn.Close();
}
源程序是这样的
SqlConnection conn=new SqlConnection();
conn.ConnectionString=G.GetSqlConnectString(Page);
SqlCommand command=new SqlCommand();
command.Connection=conn;
conn.Open();SqlTransaction trans;
trans=conn.BeginTransaction();command.Transaction=trans;for (int i = 0; i < Controls.Count; i++)
{
if ((Controls[i] is Label) && (Controls[i + 3] is UnitChange) )
{
friedidandname = ((Label) Controls[i]).Text;
num = ((UnitChange) Controls[i + 3]).m_Interface.IGetNum();
opera = ((DropDownListEx) Controls[i + 7]).SelectedItem.Text;
serialno = ((DropDownListEx) Controls[i + 8]).SelectedItem.Text;
if (num > 0)
// 找商品编码
friedid = friedidandname.Substring(1,friedidandname.IndexOf("]") - 1);
id = this.GetIDFromFriendID(friedid); switch (opera)
{
case "=":
maxno = serialno;
minno = serialno;
command.CommandText="insert into TCustomerOrder (OrderID,CommodityID,StartSerialNo,EndSerialNo,Num) values ('"+this.OrderID+"','"+id+"','"+minno+"','"+maxno+"','"+num+"' )";
break;
case ">=":
minno = serialno;
command.CommandText="insert into TCustomerOrder (OrderID,CommodityID,StartSerialNo,Num) values ('"+this.OrderID+"','"+id+"','"+minno+"','"+num+"' )";
break;
}
success=command.ExecuteNonQuery();
i += 8;
}
}
}
trans.Commit();
conn.Close();
}
循环完之后,是结束了的。最后一句conn。close()