当前位置: 代码迷 >> ASP.NET >> 事务添加返回值的有关问题
  详细解决方案

事务添加返回值的有关问题

热度:2972   发布时间:2013-02-25 00:00:00.0
事务添加返回值的问题。

StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Photo(");
            strSql.Append("FocusImg)");
            strSql.Append(" values (");
            strSql.Append("@FocusImg)");
            strSql.Append(";set @ReturnValue= @@IDENTITY");
            SqlParameter[] parameters = {
new SqlParameter("@FocusImg", SqlDbType.NVarChar,250),                                        
                    new SqlParameter("@ReturnValue",SqlDbType.Int,4)
                                        };
            parameters[0].Value = model.FocusImg;
            parameters[1].Direction = ParameterDirection.Output;

 List<CommandInfo> sqllist = new List<CommandInfo>();
            CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
            sqllist.Add(cmd);

            if (model.PhotoAlbumS != null)
            {
                StringBuilder strSql2;
                foreach (Model.PhotoAlbum models in model.PhotoAlbumS)
                {
                    strSql2 = new StringBuilder();

                    strSql2.Append("insert into PhotoAlbum(");
                    strSql2.Append("PhotoID,BigImg)");
                    strSql2.Append(" values (");
                    strSql2.Append("@PhotoID,@BigImg)");
                    SqlParameter[] parameters2 = {
new SqlParameter("@PhotoID", SqlDbType.Int,4),
new SqlParameter("@BigImg", SqlDbType.NVarChar,255)};
                    parameters2[0].Value = ParameterDirection.InputOutput;
  相关解决方案