Esempio n. 1
0
 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);
     }
 }
Esempio n. 2
0
        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);
 }