Sql helper使用方法

    public List<FirmAttachmentModel> LoadFirmAttachmentByFirmId(int FirmId, int pageIndex, int pageSize)
        {
            List<FirmAttachmentModel> result = new List<FirmAttachmentModel>();
            SqlDataReader dataReader = null;
            try
            {
                dataReader = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.StoredProcedure, "sp_LoadFirmAttachmentByFirmId", new SqlParameter[] { new SqlParameter("@FirmId", FirmId), new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize) });
                while (dataReader.Read())
                {
                    FirmAttachmentModel model = new FirmAttachmentModel
                    {
                        AttachmentTypeId = Convert.ToInt32(dataReader["AttachmentTypeId"]),
                     };
                    result.Add(model);
                }
 &