private void Button1_Click(object sender, EventArgs e)
{
if (!pathexcel.Equals(""))
{
excelProcess = new ExcelProcess(pathexcel);
dataFexcel = new List <ThuaDat>();
dataFexcel = excelProcess.ImportAllData();
dB.InsertDatas("tblLandInf", lst_col_ins, dataFexcel);
}
string condition = GenStringQuery();
string tmp = $"select {lst_col} from tblLandInf where {condition}";
if (flag)
{
mGetMerge?.Invoke(dB.ToList(tmp));
}
else
{
if (MessageBox.Show("Không chọn lọc, xuất tất cả các dữ liệu!", "Chú ý!", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
mGetMerge?.Invoke(dB.ToList($"select {lst_col} from tblLandInf"));
}
this.Close();
}
private void LoadGrid()
{
dataAllBoth = dB.ToList($"select {lst_col} from tblLandInf");
HeapSort hs = new HeapSort(dataAllBoth);
dataAllBoth = hs.GetListSorted();
label4.Text = dataAllBoth.Count + " kết quả !";
dataGridView1.Rows.Clear();
int i = 1;
foreach (var item in dataAllBoth)
{
dataGridView1.Rows.Add(item.ToArray(i));
i++;
}
}
private void Frm_insert_Load(object sender, EventArgs e)
{
Create_connect();
type = new List <ThuaDat>();
aim = new List <ThuaDat>();
type = dB.ToList("select [ID],[Name] from tblType");
aim = dB.ToList("select [ID],[Name] from tblAim");
foreach (var item in type)
{
comboBox1.Items.Add(item["Name"]);
}
foreach (var item in aim)
{
comboBox2.Items.Add(item["Name"]);
}
comboBox1.SelectedIndex = comboBox2.SelectedIndex = 0;
}
