Esempio n. 1
0
        /// <summary>
        /// 新增用户
        /// </summary>
        /// <param name="model">用户实体</param>
        /// <returns></returns>
        public bool Insert(BK_Users model)
        {
            bool result = false;

            if (dal.Insert(model) > 0)
            {
                result = true;
            }
            return(result);
        }
Esempio n. 2
0
        public bool Update(BK_Users model)
        {
            bool result = false;
            var  s      = Sugar.db.Ado.UseTran(() =>
            {
                //更新用户信息,用户自增列不修改
                UserDB.AsUpdateable(model).Where(it => it.User_id == model.User_id).IgnoreColumns(it => it == "User_id").ExecuteCommand();
            });

            if (s.IsSuccess)
            {
                result = true;
            }
            else
            {
                Console.WriteLine(s.ErrorMessage);
            }

            return(result);
        }
Esempio n. 3
0
        /// <summary>
        /// 新增用户
        /// </summary>
        /// <param name="model">用户实体</param>
        /// <returns></returns>
        public int Insert(BK_Users model)
        {
            var s = 0;

            model.User_id = null;
            //启用事务
            var result = Sugar.db.Ado.UseTran(() =>
            {
                //执行不插入User_id列(数据库ID自增长)
                UserDB.AsInsertable(model).IgnoreColumns(it => it == "User_id").ExecuteReturnIdentity();
            });

            if (result.IsSuccess)
            {
                s = 1;
            }
            else
            {
                Console.WriteLine(result.ErrorMessage);
            }
            return(s);
        }
Esempio n. 4
0
 public bool Update(BK_Users model)
 {
     return(dal.Update(model));
 }
Esempio n. 5
0
 public bool Insert(BK_Users model)
 {
     return(bll.Insert(model));
 }