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;
}
}
}