1、建立List用于存放多条语句
/// <summary>
/// 保存表单
/// </summary>
/// <param name="context"></param>
protected void save()
{
List<string> list = new List<string>();
list.Add(string.Format("insert into picsone(model,idser,idflg,lmuser,lmdate,lmtime) values('{0}','{1}','{2}','{3}',{4},{5})", "T1002", "Y", "N", "U001", 20161103, 140025));
list.Add(string.Format("insert into picstwo(model,idser,idflg,lmuser,lmdate,lmtime) values('{0}','{1}','{2}','{3}',{4},{5})", "T1002", "Y", "N", "U001", 20161103, 140025));
bool bol = ExecuteTransaction(list);
if (bol)
{
MessageBox.Show("保存成功！");
}
else
{
MessageBox.Show("保存失败！");
}
}
2、调用ExecuteTransaction方法，并返回返回值true为成功，false为失败，语句并回滚
/// <summary>
/// 执行语句
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
private bool ExecuteTransaction(List<string> list)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["LocalConnectionString"].ToString()))
{
SqlCommand command = new SqlCommand();
SqlTransaction transaction = null;
try
{
connection.Open();
transaction = connection.BeginTransaction();
command.Connection = connection;
command.Transaction = transaction; for (int i = 0; i < list.Count; i++)
{
command.CommandText = list[i];
command.ExecuteNonQuery();
} transaction.Commit();
connection.Close();
return true;
}
catch
{
transaction.Rollback();
connection.Close();
return false;
}
}
}