C#存储过程加事务

 

public DataSet GettPerformance(string AgentID, string StartDate, string EndDate)
        {

            try
            {
                Regex regex = new Regex(@"^\d+W");
                DataSet datas = null;
                int ID = 0;

                if (AgentID != "" && AgentID != null)
                {
                    if (!regex.IsMatch(AgentID))
                    {
                        ID = Convert.ToInt32(AgentID);
                    }
                }
                else
                {

                    ID = 0;
                }
                SqlParameter[] param = new SqlParameter[]{new SqlParameter("@StartDate",StartDate),
                new SqlParameter("@EndDate",EndDate),
                new SqlPa