Exemplo n.º 1
0
        /// <summary>
        /// 添加记住用户
        /// </summary>
        /// <param name="model">The model.</param>
        /// <returns>System.Int32.</returns>
        public int AddLoginName(LoginNameModel model)
        {
            var    data   = GetLoginName(model.login_name);
            string strSql = string.Empty;

            if (data == null)
            {
                strSql = "INSERT INTO user_list(userid,login_name,login_password,is_save_pwd) values(@userid,@login_name,@login_password,@is_save_pwd);select last_insert_rowid();";
                var param = new[] {
                    new SQLiteParameter("@userid", model.userid),
                    new SQLiteParameter("@login_name", model.login_name),
                    new SQLiteParameter("@login_password", model.login_password),
                    new SQLiteParameter("@is_save_pwd", model.is_save_pwd)
                };
                return(DBSqliteHelper.ExecuteSqlLoginName(strSql, param));
            }
            else
            {
                strSql = "update user_list set is_save_pwd=@is_save_pwd where userid=@userid";
                var param = new[] {
                    new SQLiteParameter("@userid", model.userid),
                    new SQLiteParameter("@is_save_pwd", model.is_save_pwd)
                };
                return(DBSqliteHelper.ExecuteSqlLoginName(strSql, param));
            }
        }
Exemplo n.º 2
0
 /// <summary>
 /// 添加记住用户
 /// </summary>
 /// <param name="model">The model.</param>
 /// <returns>System.Int32.</returns>
 public int AddLoginName(LoginNameModel model)
 {
     return(lnDal.AddLoginName(model));
 }