frmcsvconvertsetcolumn.cs

在设计程序时,需要经常计算一个字串的哈希值,得到加密文本,生成加密过的配置文件或都转换EXCEL文件到SQL数据库等等,根据自己习惯定制部分功能,由于时间关系,没有详细说明

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace LingangTools
{
    public partial class FrmCsvConvertSetColumn : Form
    {
        public FrmCsvConvertSetColumn()
        {
            InitializeComponent();
        }

        private DataSet dsColumnInfo;

        private DataSet dsData;

        public DataSet Data
        {
            set
            {
                if (value == null)
                    return;
                dsData = value;
                if (dsColumnInfo == null)
                    InitColumnInfo();
                dsColumnInfo.Tables["列名信息表"].Rows.Clear();
                foreach (DataColumn dc in value.Tables["原始数据表"].Columns)
                {
                    DataRow dr = dsColumnInfo.Tables["列名信息表"].NewRow();
                    dr["OriginalColumnName"] = dr["NewColumnName"] = dc.ColumnName;
                    dr["ColumnDataType"] = dc.DataType.ToString();
                    dr["AllowNull"] = dc.AllowDBNull;
                    dr["IsPrimaryKey"] = dc.Unique;
                    dsColumnInfo.Tables["列名信息表"].Rows.Add(dr);
                }
            }
            get
            {
                return null;
            }
        }

        private void InitColumnInfo()
        {
            dsColumnInfo = new DataSet();
            DataTable table = new DataTable("列名信息表");
            table.Columns.Add("OriginalColumnName", typeof(string));
            table.Columns.Add("NewColumnName", typeof(string));
            table.Columns.Add("ColumnDataType", typeof(string));
            table.Columns.Add("IsPrimaryKey", typeof(bool));
            table.Columns.Add("AllowNull", typeof(bool));
            dsColumnInfo.Tables.Add(table);
            dataGridView_ColumnsList.DataSource = dsColumnInfo;
            dataGridView_ColumnsList.DataMember = table.TableName;
            lbl_OriginalColumnName.DataBindings.Add("Text", dsColumnInfo, "列名信息表.OriginalColumnName");
            txt_ColumnName.DataBindings.Add("Text", dsColumnInfo, "列名信息表.NewColumnName");
            cmb_ColumnDataType.DataBindings.Add("SelectedItem", dsColumnInfo, "列名信息表.ColumnDataType");
            chk_AllowNull.DataBindings.Add("Checked", dsColumnInfo, "列名信息表.AllowNull");
            chk_SetAsPrimaryKey.DataBindings.Add("Checked", dsColumnInfo, "列名信息表.IsPrimaryKey");
        }

        private void FrmCsvConvertSetColumn_Load(object sender, EventArgs e)
        {
            cmb_ColumnDataType.Items.Add(typeof(string).ToString());
            cmb_ColumnDataType.Items.Add(typeof(float).ToString());
            cmb_ColumnDataType.Items.Add(typeof(decimal).ToString());
            cmb_ColumnDataType.Items.Add(typeof(bool).ToString());
            cmb_ColumnDataType.Items.Add(typeof(char).ToString());
            cmb_ColumnDataType.Items.Add(typeof(long).ToString());
            cmb_ColumnDataType.Items.Add(typeof(ulong).ToString());
            cmb_ColumnDataType.Items.Add(typeof(byte).ToString());
            cmb_ColumnDataType.Items.Add(typeof(sbyte).ToString());
            cmb_ColumnDataType.Items.Add(typeof(int).ToString());
            cmb_ColumnDataType.Items.Add(typeof(uint).ToString());
            cmb_ColumnDataType.Items.Add(typeof(short).ToString());
            cmb_ColumnDataType.Items.Add(typeof(ushort).ToString());
            cmb_ColumnDataType.Items.Add(typeof(Guid).ToString());

        }

        private void chk_SetAsPrimaryKey_CheckedChanged(object sender, EventArgs e)
        {
            if (chk_SetAsPrimaryKey.Checked)
            {
                chk_AllowNull.Checked = false;
                chk_AllowNull.Enabled = false;
            }
            else
            {
                chk_AllowNull.Enabled = true;
            }
        }
    }
}