//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); } }
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"; } }
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); }