private void Save() { if (dataGridView1.Rows.Count < 1) { if (MessageBox.Show("数据为空,是否保存?", "温馨提示") == DialogResult.No) { return; } } try { for (int i = 0; i < dataGridView1.Rows.Count; i++) { var row = dataGridView1.Rows[i]; sdglsys.Entity.T_Dorm dorm = new sdglsys.Entity.T_Dorm { Dorm_id = int.Parse(row.Cells[0].Value.ToString()), Dorm_nickname = row.Cells[1].Value.ToString(), Dorm_type = row.Cells[2].Value.ToString().Equals("男"), Dorm_is_active = (bool)row.Cells[3].Value }; client.Insertable(dorm).ExecuteCommand(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void Btn_login_Click(object sender, EventArgs e) { Toast.MakeText(this, "开始登录吧!", ToastLength.Short).Show(); SqlSugar.SqlSugarClient db = Common.SqliteHelp.GetInstance(); var insertObj = new Models.UserInfo { UserName = "******", Pwd = "123" }; int dd = db.Insertable(insertObj).ExecuteCommand(); }
public long Add(LiveChatRoomMember model) { long rc = 0; try { if (model != null) { rc = db.Insertable(model).ExecuteReturnBigIdentity(); } } catch (Exception ex) { log.Error("Add", ex); } return(rc); }
public int Add(Advertisement model) { var i = db.Insertable(model).ExecuteReturnBigIdentity(); return(i.ObjToInt()); }
public bool SendMail(Sys_Email sys_Email) { return(db.Insertable <Sys_Email>(sys_Email).ExecuteReturnIdentity() > 0); }