protected override void Query()
{
var ormInstance = new orm();
sql sqlInstance = new sql();
sqlInstance.Select(@"
id,
name,
phone,
certificate_num,
service_area,
ID_card,
army,
r_and_p,
address,
Hukou,
contact_way,
political_status,
part_of_company,
serviceunit,
h_and_w,
sex,
soldier,
approve_time,
date_of_birth,
major_skill,
training_record,
base64FromImage" ).From("guard");
guardList = ormInstance.Fetch <MODEL.guard>(sqlInstance);
dataGridView1.DataSource = guardList;
base.Query();
}
protected override void Query()
{
var ormInstance = new orm();
sql sqlInstance = new sql();
sqlInstance.Select("*").From("company");
companyList = ormInstance.Fetch <MODEL.company>(sqlInstance);
dataGridView1.DataSource = companyList;
base.Query();
}
public IActionResult Index(int number = -1)
{
orm o = new orm();
o.i = _db.WitchOrm.First().i;
if (number != -1)
{
_db.WitchOrm.First().i = number;
_db.SaveChanges();
ViewBag.changed = true;
ViewBag.text = number == 1 ? "Queries" : "EntityFramework";
TempData["orm"] = number;
return(RedirectToAction(nameof(Index), "Home", new { @Area = "Customer" }));
}
return(View(o));
}
protected override void Import()
{
List <MODEL.guard> insertingList = MODEL.function.ReadFromCsvFile <MODEL.guard>();
if (insertingList == null || insertingList.Count == 0)
{
MessageBox.Show("解析文件失败，请确认文件格式正确，并以UTF-8编码保存");
}
orm ormInstance = new orm();
int result = 0;
foreach (MODEL.guard g in insertingList)
{
if (ormInstance.Insert(g) > 0)
{
result++;
}
}
MessageBox.Show(string.Format("成功插入{0}行", result));
}
protected override void Delete()
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("未选择删除数据");
}
else
{
if (MessageBox.Show("是否删除当前行", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information)
== DialogResult.OK)
{
var ormInstance = new orm();
dataGridView1.DataSource = ormInstance.Delete((dataGridView1.DataSource as List <MODEL.company>)[dataGridView1.SelectedRows[0].Index]);
Query();
}
else
{
MessageBox.Show("取消删除了");
}
}
}
