复制代码 代码如下:
///
/// 批量执行SQL语句
///
///SQL语句数组
///SQL参数对象数组
///
public static Int32 ExecuteSqls(String[] Sqlstr, Listparam)
{
String ConnStr = GetSqlConnection();
using (SqlConnection conn = new SqlConnection(ConnStr))
{
SqlCommand cmd = new SqlCommand();
SqlTransaction tran = null;
saction = tran;
try
{
();
tran = nTransaction();
ection = conn;
saction = tran;
Int32 count = th;
for (Int32 i = 0; i < count; i++)
{
andText = Sqlstr[i];
ange(param[i]);
uteNonQuery();
}
it();
return 1;
}
catch
{
back();
return 0;
}
finally
{
ose();
e();
}
}
}