Ejemplo n.º 1
0
        /// <summary>
        /// 插入用户
        /// </summary>
        /// <param name="userName"></param>
        /// <param name="passWord"></param>
        /// <returns></returns>
        public static bool InsertUser(LengNinUser user, All.Class.DataReadAndWrite conn)
        {
            string tmpUse = "";

            for (int i = 0; i < user.Use.Length; i++)
            {
                tmpUse = string.Format("{0},'{1}'", tmpUse, user.Use[i]);
            }
            return(conn.Write(string.Format("insert into SetUsersLengNin values('{0}','{1}','{2:yyyy-MM-dd HH:mm:ss}'{3})",
                                            user.Text, user.Word, DateTime.Now, tmpUse)) >= 1);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取用户名设置
        /// </summary>
        /// <returns></returns>
        public static List <LengNinUser> GetAllUser(All.Class.DataReadAndWrite conn)
        {
            List <LengNinUser> user = new List <LengNinUser>();
            LengNinUser        tmpUserSet;

            using (DataTable dt = conn.Read("select * from SetUsersLengNin order by InTime"))
            {
                if (dt != null && dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        tmpUserSet      = new LengNinUser();
                        tmpUserSet.Text = All.Class.Num.ToString(dt.Rows[i]["UserName"]);
                        tmpUserSet.Word = All.Class.Num.ToString(dt.Rows[i]["UserPassword"]);
                        for (int j = 0; j < cMain.AllLengNinQiCount; j++)
                        {
                            tmpUserSet.Use[j] = All.Class.Num.ToBool(dt.Rows[i][string.Format("use{0}", j)]);
                        }
                        user.Add(tmpUserSet);
                    }
                }
            }
            return(user);
        }
Ejemplo n.º 3
0
 /// <summary>
 /// 更新用户
 /// </summary>
 /// <param name="user"></param>
 /// <returns></returns>
 public static bool UpdateUser(LengNinUser user, All.Class.DataReadAndWrite conn)
 {
     DeleteUser(user.Text, conn);
     return(InsertUser(user, conn));
 }