C#資料層添加事務功能

標籤：des   style   blog   color   strong   資料   

例子        public bool Save(ProjectModel project)        {            int Result = 0;            SqlConnection Conn = new SqlConnection(SqlHelper.connectionString);          Conn.Open();          SqlTransaction Trans;          Trans = Conn.BeginTransaction();          try            {                SqlParameter[] sqlParameter1 = new SqlParameter[]{                    new SqlParameter{ ParameterName="@EmployeeID",Value= project.EmployeeID}                               };                                int projectID = Convert.ToInt16(SqlHelper.ExecuteScalar(Trans, CommandType.StoredProcedure, "SaveProject", sqlParameter1));                if (projectID != 0)                {                                        if (project.LinkManinfoList.Count > 0)                    {                        string sqlText = "";                        for (int i = 0; i < project.LinkManinfoList.Count; i++)                        {                            sqlText = "Insert into Customer(ProjectID)values(‘" + projectID + "‘)";                            Result += SqlHelper.ExecuteSql(sqlText);                        }                    }                                   if (!string.IsNullOrEmpty(project.ProjectStage))                    {                        string sqlText2 = "insert into ProjectStageCondition ()";                        SqlParameter[] sqlParameter3 = new SqlParameter[]{                            new SqlParameter{ ParameterName="@ProjectStageDesc",Value= project.ProjectStage}                                                  Result += SqlHelper.ExecuteSql(sqlText2, sqlParameter3);                    }                    else { Result++; }                }                         Trans.Commit();            }            catch (Exception ex)            {               Trans.Rollback();            }            finally            {               Conn.Close();            }            return Result == project.LinkManinfoList.Count;        }