示例#1
0
        /// <summary>
        /// 添加记录信息行 有事务
        /// </summary>
        /// <param name="id">标识列的值(条件列,可扩展)</param>
        /// <param name="columns">需要的列数组</param>
        /// <param name="changetype">操作的类型(删除或修改)</param>
        public void AddRecordtran(SqlTransaction tran, string id, string[] columns, ChangeType changetype)
        {
            StringBuilder sqlbuilder = new StringBuilder();

            sqlbuilder.Append("select ");
            if (columns.Length > 0)
            {
                for (int i = 0; i <= columns.Length - 2; i++)
                {
                    sqlbuilder.Append(columns[i]);
                    sqlbuilder.Append(",");
                }
                // 最后不要加逗点
                sqlbuilder.Append(columns[columns.Length - 1]);
            }
            else
            {
                sqlbuilder.Append(" * ");
            }

            sqlbuilder.Append(" from ");
            sqlbuilder.Append(_tablename);
            sqlbuilder.Append(" where ");
            sqlbuilder.Append(_identity);
            sqlbuilder.Append(" = ");
            sqlbuilder.Append("'");
            sqlbuilder.Append(id);
            sqlbuilder.Append("'");

            SqlCommand cmd = new SqlCommand(sqlbuilder.ToString(), tran.Connection);

            cmd.Transaction = tran;
            SqlDataReader reader = cmd.ExecuteReader();
            //SqlDataReader reader = DBHelper.ExecuteReader(sqlbuilder.ToString());

            string ss = sqlbuilder.ToString();

            ss = "";

            bool   isVisible  = false;
            string columnName = string.Empty;

            while (reader.Read())
            {
                // 添加列信息
                if (this.State == RemarkState.StartHeader)
                {
                    _remarkbuilder.Append("<tr align='center'>");

                    // 操作类型标题列
                    _remarkbuilder.Append("<th style='white-space:nowrap'>操作类型</th>");

                    for (int i = 0; i <= reader.FieldCount - 1; i++)
                    {
                        columnName = GetColumnName(reader.GetName(i));
                        //columnName = DsSystem.TableMap.Columns.GetColumnName(reader.GetName(i), out  isVisible);
                        //	if (!isVisible)
                        //	{
                        //		hashNoVisible .Add (i , i);
                        //		continue ;
                        //	}
                        // 添加字段名称记录信息
                        _remarkbuilder.Append("<th style='white-space:nowrap'>");
                        _remarkbuilder.Append(columnName); // 字段名称
                        _remarkbuilder.Append("</th>");
                    }
                    _remarkbuilder.Append("</tr>");

                    this.State = RemarkState.StartItem; // 改变状态
                }

                if (this.State == RemarkState.StartItem)
                {
                    // 添加记录行信息
                    _remarkbuilder.Append("<tr align='center'>");

                    // 操作类型列
                    _remarkbuilder.Append("<td style='white-space:nowrap'>");
                    _remarkbuilder.Append(Enum.GetName(changetype.GetType(), changetype)); // 字段名称
                    _remarkbuilder.Append("</td>");

                    for (int i = 0; i <= reader.FieldCount - 1; i++)
                    {
                        if (hashNoVisible.Contains(i))
                        {
                            continue;
                        }

                        _remarkbuilder.Append("<td style='white-space:nowrap'>");
                        if (hashDP.Contains(i))
                        {
                            _remarkbuilder.Append(reader[i] == null ? " &nbsp;" : decipher(reader[i].ToString().Trim(), hashDP[i].ToString().ToLower())); // 字段名称
                        }
                        else
                        {
                            _remarkbuilder.Append(reader[i] == null ? " &nbsp;" : reader[i].ToString().Trim()); // 字段名称
                        }
                        _remarkbuilder.Append("</td>");
                    }
                    _remarkbuilder.Append("</tr>");

                    this._item++; // 记录行加加
                }
            }

            reader.Close();
        }