private void InitDatabase()
{
//初始化数据库
using (var database = new MysqlDb()) //新增
{
database.Database.EnsureDeleted();
database.Database.EnsureCreated();
}
var services = new ServiceCollection();
services.AddSummerBoot();
var connectionString = MyConfiguration.GetConfiguration("mysqlDbConnectionString");
if (string.IsNullOrWhiteSpace(connectionString))
{
throw new ArgumentNullException("mysql connectionString must not be null");
}
services.AddSummerBootRepository(it =>
{
it.DbConnectionType = typeof(MySqlConnection);
it.ConnectionString = connectionString;
});
serviceProvider = services.BuildServiceProvider();
serviceProvider = serviceProvider.CreateScope().ServiceProvider;
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
private async Task <List <TDemoTable> > GetList()
{
using (var db = new MysqlDb())
{
var data = await db.TDemoTable.Where(item => true).ToListAsync();
return(data);
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public async Task <ActionResult> Edit(int id)
{
using (var db = new MysqlDb())
{
var model = await db.TDemoTable.FindAsync(id);
return(View("Create", model));
}
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public async Task <JsonResult> Remove(int id)
{
using (var db = new MysqlDb())
{
await db.TDemoTable.RemoveById(id);
await db.SaveChangesAsync();
return(Json(new { state = true, value = "删除成功" }));
}
}
/// <summary>
/// 保存数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
private async Task Add(TDemoTable model)
{
using (var db = new MysqlDb())
{
db.TDemoTable.Add(model);
await db.SaveChangesAsync();
MessageBox.Show(JsonSerializer.Serialize(model));
await InitializeData();
}
}
public async Task <JsonResult> Create(TDemoTable model)
{
model.F_Guid = Guid.NewGuid().ToString();
using (var db = new MysqlDb())
{
db.TDemoTable.Add(model);
await db.SaveChangesAsync();
return(Json(new { state = true, value = "操作成功" }));
}
}
public bool login()
{
AdminMapper adminmapper = new AdminMapper(MysqlDb.GetInstance());
if (adminmapper.CheckLogin("admin", passwordBox1.Password))
{
return(true);
}
else
{
MessageBox.Show("Wachtwoord is onjuist.");
return(false);
}
}
public async Task <JsonResult> Edit(TDemoTable model)
{
if (!this.TryValidateModel(model))
{
return(Json(new { state = false, value = this.ModelState.FirstModelErrorMessage() }));
}
using (var db = new MysqlDb())
{
db.Entry(model).State = EntityState.Modified;
await db.SaveChangesAsync();
return(Json(new { state = true, value = "编辑成功" }));
}
}
/// <summary>
/// 菜单删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void DeleteToolStripMenuItem_Click(object sender, EventArgs e)
{
int a = dataGridView1.CurrentRow.Index;
var f_id = dataGridView1.Rows[a].Cells["Id"].Value;
var id = int.Parse(f_id.ToString());
using (var db = new MysqlDb())
{
await db.TDemoTable.RemoveById(id);
await db.SaveChangesAsync();
}
MessageBox.Show("删除id:" + id + "成功.");
await InitializeData();
}
protected Pair ProcessRow(Pair pair, MySqlDataReader Reader)
{
pair.ID = Reader.GetInt32(0);
pair.Number_of_guests = Reader.GetInt32(1);
StudentMapper studentmapper = new StudentMapper(MysqlDb.GetInstance());
pair.Student1_id = Reader.GetInt32(2);
try
{
pair.Student2_id = Reader.GetInt32(3);
}
catch (Exception e)
{
pair.Student2_id = 0;
}
return(pair);
}
// GET: Mysql
public async Task <ActionResult> Index(int?pageindex)
{
var page = pageindex ?? 1;
var pageSize = 10;
var order = " Id desc";
using (var db = new MysqlDb())
{
var where = Where.True <TDemoTable>();
var F_String = Request["F_String"];
if (F_String != null && !F_String.ToString().IsNullOrEmpty())
{
where = where.And(item => item.F_String.Contains(F_String.ToString()));
}
var data = await db.TDemoTable.Where(where).ToPageAsync(order, page, pageSize);
return(View(data));
}
}
public void Init(MainWindow mainWindow)
{
this.PDFexporter = new PDFExporter(mainWindow.GridOverzichtList);
this.DB = MysqlDb.GetInstance();
this.BlockedTimeslotMapper = new BlockedTimeslotMapper(this.DB);
this.SessionMapper = new SessionMapper(this.DB);
this.UserMapper = new UserMapper(this.DB);
this.ClassroomMapper = new ClassroomMapper(this.DB);
this.StudentMapper = new StudentMapper(this.DB);
this.DaytimeMapper = new DaytimeMapper(this.DB);
this.TeacherMapper = new TeacherMapper(this.DB);
this.ExpertMapper = new ExpertMapper(this.DB);
this.PairMapper = new PairMapper(this.DB);
this.EmailTemplateMapper = new EmailTemplateMapper(this.DB);
this.LetterTemplateMapper = new LetterTemplateMapper(this.DB);
this.TimeslotMapper = new TimeslotMapper(this.DB);
this.Timeslots = this.TimeslotMapper.FindAll();
this.toPlanWindow = new UnPlannedPairs();
this.MainWindow = mainWindow;
}
public PairMapper(MysqlDb db)
: base(db)
{
}
public LetterTemplateMapper(MysqlDb db)
: base(db)
{
}
public EmailTemplateMapper(MysqlDb db) : base(db)
{
}
public BlockedTimeslotMapper(MysqlDb db) : base(db)
{
}
public TimeslotMapper(MysqlDb db)
: base(db)
{
}
