menu
more_vert

1 .net 用事物提交执行存储过程

作者:dayu

 public static void delModelReturn(string performanceId,DateTime? effectiveDate=null)
        {

            using (SqlConnection con = GetEditorConnection())
            {
                con.Open();
                using (SqlCommand command = con.CreateCommand())
                {
                    SqlTransaction st = con.BeginTransaction();
                    command.Transaction = st;
                    try
                    {
                        command.CommandText = "delModelReturn";
                        command.CommandType = CommandType.StoredProcedure;
                        command.Parameters.Add(new SqlParameter("@p_PerformanceId", performanceId));
                        if (!effectiveDate.HasValue)
                        {
                            command.Parameters.Add(new SqlParameter("@p_EffectiveDate", DBNull.Value));
                        }
                        else
                        {
                            command.Parameters.Add(new SqlParameter("@p_EffectiveDate",effectiveDate));
                        }
                        command.ExecuteNonQuery();
                        st.Commit();
                    }
                    catch (Exception ex)
                    {
                        st.Rollback();
                        throw new Exception(ex.Message);
                    }


                }
                con.Close();

            }
        }

1 .net 用事物提交执行存储过程

原文地址:http://www.cnblogs.com/mibing/p/7521573.html



Processed Time:0.22739100456238

_REQUEST:
Array
(
    [0] => read
    [1] => 86107
)
_SESSION:
Array
(
    [fid] => 4
)