private void button1_Click(object sender, EventArgs e)
{
string sqlstring = "Select UserName from SysUser where UserID='" + textBox1.Text + "' and Pwd='" + textBox2.Text + "'";
try
{
object obj = SQLDbHelper.ExecuteScalar(sqlstring);
if (obj == null)
{
MessageBox.Show("用户名不存在或者密码错误！");
textBox1.Focus();
return;
}
else
{
//将计算机名称保存到数据库中
if (int.Parse(SQLDbHelper.ExecuteScalar("Select count(*) from VersionUser where Computer='" + Environment.MachineName + "'").ToString()) == 0)
{
SQLDbHelper.ExecuteSql("Insert into VersionUser(Computer,Ver)values('" + Environment.MachineName + "',0)");
}
else
{
int userver = int.Parse(SQLDbHelper.ExecuteScalar("Select ver from VersionUser where Computer='" + Environment.MachineName + "'").ToString());
int sysver = int.Parse(SQLDbHelper.ExecuteScalar("Select ver from VersionSys").ToString());
if (userver < sysver)
{
if (MessageBox.Show("软件有新的版本可以升级！你需要升级吗？", "软件升级", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
SQLDbHelper.ExecuteSql("Update VersionUser Set Ver=" + sysver + " where Computer='" + Environment.MachineName + "'");
System.Diagnostics.Process.Start(Application.StartupPath + @"\Update.exe");
Application.Exit();
}
}
}
ClsBLL.UserID = textBox1.Text;
ClsBLL.UserName = obj.ToString();
ClsBLL.UserGroup = ClsBLL.GetUserGroup(ClsBLL.UserName);
AppConfig.ConfigSetValue(Application.ExecutablePath, "LastUserID", textBox1.Text);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
catch (Exception Err)
{
MessageBox.Show(Err.Message);
}
}