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