private void btnTableSchema_Click(object sender, EventArgs e)
{
DbfContext db_context = new DbfContext(this.textBox1.Text);
var table_schema = db_context.GetTableSchemaInfoList("artrn");
this.dataGridView1.DataSource = table_schema;
}
private void btnQuery_Click(object sender, EventArgs e)
{
DbfContext db_context = new DbfContext(this.textBox1.Text);
//this.dataGridView1.DataSource = db_context.GetDataBySql(this.txtSql.Text).CastTo<stcrd>(db_context.GetTableSchemaInfoList("stcrd"));
this.dataGridView1.DataSource = db_context.GetDataBySql <stcrd>(this.txtSql.Text, "stcrd");
this.lblTotalRow.Text = this.dataGridView1.Rows.Count.ToString();
}
private void btnDynamicCast_Click(object sender, EventArgs e)
{
//DbfContext dbf_context = new DbfContext(this.textBox1.Text);
//OleDbCommand cmd = dbf_context.Connection.CreateCommand();
//cmd.CommandText = "Select * from stcrd";
//DataTable dt = new DataTable();
//dbf_context.Connection.Open();
//using (OleDbDataAdapter da = new OleDbDataAdapter(cmd))
//{
// da.Fill(dt);
//}
//dbf_context.Connection.Close();
//var x = dt.CastTo<stcrd>(dbf_context.GetTableSchemaInfoList("stcrd"));
//this.dataGridView1.DataSource = x;
DbfContext dbf_context = new DbfContext(this.textBox1.Text);
artrnrm x = new artrnrm
{
//docnum = "IV1234567",
//seqnum = "xxx",
//remark = "ทดสอบ add remark from outside"
};
dbf_context.AddRecord("artrnrm", x);
armas ar = new armas
{
//cuscod = "สบจ",
//cusnam = "สะเบยเจย",
//paytrm = 120,
//lasivc = DateTime.Now,
//credat = DateTime.Now.AddMonths(-2),
//chgdat = DateTime.Now.AddMonths(-1).AddDays(+4),
//inactdat = DateTime.Now.AddDays(3)
};
dbf_context.AddRecord("armas", ar);
MessageBox.Show("Add data completed.");
}
private void button2_Click(object sender, EventArgs e)
{
FolderBrowserDialog fd = new FolderBrowserDialog();
if (fd.ShowDialog() == DialogResult.OK)
{
this.textBox1.Text = fd.SelectedPath;
DbfContext dbf_context = new DbfContext(this.textBox1.Text);
var filename_list = dbf_context.GetDbfFileName();
this.checkedListBox1.Items.Clear();
this.checkedListBox1.Items.Add(new ComboboxItem("*All*", "_all"));
filename_list.ForEach(f =>
{
this.checkedListBox1.Items.Add(new ComboboxItem(f, f));
});
for (int i = 0; i < this.checkedListBox1.Items.Count; i++)
{
//this.checkedListBox1.SetItemChecked(i, true);
}
}
}
private void btnGenClass_Click(object sender, EventArgs e)
{
if (this.txtNameSpace.Text.Trim().Length == 0 || this.txtNameSpace.Text.Trim().Contains(" "))
{
MessageBox.Show("Please specify Name Space correctly!", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
this.checkedListBox1.CheckedItems.Cast <ComboboxItem>().ToList().ForEach(i =>
{
try
{
string class_name = ((string)i.Value).ToLower();
DbfContext db_context = new DbfContext(this.textBox1.Text);
var data = db_context.GetTableSchemaInfoList(class_name).ToList();
//this.dataGridView1.DataSource = data;
StreamWriter sw = File.CreateText(@"Gen_Class\" + class_name + ".cs");
sw.WriteLine("using System;");
sw.WriteLine("using System.Collections.Generic;");
sw.WriteLine("using System.Linq;");
sw.WriteLine("using System.Text;" + Environment.NewLine);
sw.WriteLine("namespace " + this.txtNameSpace.Text.Trim() + Environment.NewLine + "{");
sw.WriteLine("\tpublic class " + class_name + " {");
data.ForEach(d =>
{
string data_type = "string";
switch (d.DATA_TYPE)
{
case 5:
data_type = "double";
break;
case 11:
data_type = "bool";
break;
case 129:
data_type = "string";
break;
case 131:
data_type = "decimal";
break;
case 133:
data_type = "DateTime?";
break;
default:
data_type = "string";
break;
}
sw.WriteLine("\t\tpublic " + data_type + " " + d.COLUMN_NAME + " { get; set;}");
});
sw.WriteLine("\t}");
sw.WriteLine("}");
sw.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
});
}
