Ejemplo n.º 1
0
        //Add User For PMS
        public static bool AddUser(PmsUserClass user, string dbname, string ipaddress)
        {
            string constr = "Data Source=" + ipaddress + ";uid=sa;pwd=yzhh2007;database=" + dbname + ";Connection Timeout=15";
            string cmd    = @"if EXISTS(select * from logon where userid=@username)
			                  BEGIN 
			                  update dbo.logon set expire_date=@expiredate,password=@password,Ulevel=@level where userID=@username                                                        
			                  END
	                       else 
		                      BEGIN
                              INSERT INTO [dbo].[logon](userID,password,ULevel,expire_date)
		                      VALUES(@username,@password,@level,@expiredate)		 
                              END";

            SqlParameter[] UserPara = new SqlParameter[]
            {
                new SqlParameter("@username", user.Name),
                new SqlParameter("@password", user.Password),
                new SqlParameter("@expiredate", user.ExpiredDate),
                new SqlParameter("@level", user.Level)
            };

            try
            {
                SqlHelper.ExecuteNonQuery(constr, CommandType.Text, cmd, UserPara);
                LogClass.WirteLine("Add user ok");
                return(true);
            }
            catch (SqlException sqle)
            {
                LogClass.WirteLine(dbname + " Sql error when add user:" + sqle.ToString());
                return(false);
            }
        }
Ejemplo n.º 2
0
        private void button1_Click_1(object sender, EventArgs e)
        {
            pBar1.Minimum = 1;
            pBar1.Maximum = carpark.Count;
            pBar1.Value   = 1;
            pBar1.Step    = 1;

            if (button1.Text == "Start")
            {
                PmsUserClass user = new PmsUserClass();

                if (ToolsUtility.CheckValue(nameTxt.Text.Trim(), rnameTxt.Text.Trim()) && ToolsUtility.CheckValue(pwdTxt.Text.Trim(), rpwdTxt.Text.Trim()))
                {
                    user.Name        = nameTxt.Text.Trim();
                    user.Password    = pwdTxt.Text.Trim();
                    user.Level       = levelCombox.Text.Trim();
                    user.ExpiredDate = dateTimePicker1.Value.ToString("yyyy-MM-dd ") + "00:00:00";
                }
                else
                {
                    MessageBox.Show("Please check your username,password");
                    return;
                }
                //      MessageBox.Show(user.Name);
                thr = new Thread(() => ThreadAdd(user));
                thr.Start();
                button1.Text = "Stop";
            }
            else if (button1.Text == "Stop")
            {
                if (thr != null)
                {
                    if (thr.IsAlive)
                    {
                        thr.Abort();
                    }
                }
                button1.Text = "Start";
            }
        }
Ejemplo n.º 3
0
        private void ThreadAdd(PmsUserClass user)
        {
            BtnDelegate    btn    = new BtnDelegate(BtnTxt);
            LabelDelegate  label  = new LabelDelegate(LabelTxt);
            PrograDelegate Progra = new PrograDelegate(PrograStepup);

            int i = 1;

            foreach (KeyValuePair <string, string> kv in carpark)
            {
                this.Invoke(label, kv.Key, 1);
                this.Invoke(label, i.ToString() + "/" + carpark.Count.ToString(), 2);
                //  LogClass.wirteLine("Carpark"+kv.Key+",IP:"+kv.Value);
                if (ToolsUtility.Ping(kv.Value.ToString()))
                {
                    DBUtility.AddUser(user, kv.Key, kv.Value);
                }
                this.Invoke(Progra);
                i++;
            }
            this.Invoke(btn);
        }