Example #1
0
        private void btnAdd_Click(object sender, System.EventArgs e)
        {
            if (table == null)
            {
                ExMessageBox.Show(this, "请选择一个数据表再进行操作!");
                return;
            }
            if (data_profile == null)
            {
                data_profile            = DBInitDataProfile.fromXMLFile(data_file_path);
                data_profile.table_name = table.table_name;
            }
            DBInitData data = new DBInitData(table);

            data_profile.data_list.Add(data);
            data_profile.toXmlFile(root_path);
            int row = dgvData.Rows.Add();

            loadDataForRow(row, data);
        }
Example #2
0
        private DBInitData readDataFromRow(int row)
        {
            DBInitData data = new DBInitData();

            for (int i = 0; i < dgvData.Columns.Count; i++)
            {
                if (table.columns[i].data_type == DBDataType.Binary)
                {
                    continue;
                }
                string value = "";
                if (dgvData.Rows[row].Cells[i].Value != null)
                {
                    value = dgvData.Rows[row].Cells[i].Value.ToString();
                }
                DBInitDataItem di = new DBInitDataItem();
                di.column_name = dgvData.Columns[i].Name;
                di.data_type   = table.columns[i].data_type;
                di.StringValue = value;
                data.item_list.Add(di);
            }
            return(data);
        }
Example #3
0
 private void loadDataForRow(int row, DBInitData data)
 {
     loading_detail = true;
     for (int i = 0; i < dgvData.Columns.Count; i++)
     {
         if (table.columns[i].data_type == DBDataType.Bit)
         {
             object value = data.valueWithName(dgvData.Columns[i].Name);
             if (value == null)
             {
                 dgvData.Rows[row].Cells[i].Value = false;
             }
             else
             {
                 dgvData.Rows[row].Cells[i].Value = value;
             }
         }
         else
         {
             dgvData.Rows[row].Cells[i].Value = data.valueWithName(dgvData.Columns[i].Name);
         }
     }
     loading_detail = false;
 }