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) { }