private void button1_Click(object sender, EventArgs e)
{
string zh = textBox1.Text;
string mm = textBox2.Text;
if (string.IsNullOrEmpty(zh))
{
MessageBox.Show("账号不能为空");
return;
}
if (string.IsNullOrEmpty(mm))
{
MessageBox.Show("密码不能为空");
return;
}
DataTable table = new SqlServerHelper().QuerySqlDataTable("select * from denglu where zh=N'" + zh + "' and mm=N'" + mm + "'");
if (table.Count() > 0)
{
MessageBox.Show("登录成功！");
this.Hide();
GlobalVar.denglu_zh = zh;
//打开主页面
FormMain main = new FormMain();
main.FormClosed += Main_FormClosed;
main.WindowState = FormWindowState.Maximized;
main.Show();
}
else
{
MessageBox.Show("用户名密码输入有误！");
}
}
public Form4(string yhzh)
{
InitializeComponent();
DataTable table = new SqlServerHelper().QuerySqlDataTable("select * from yhxx where yhzh='" + yhzh + "'");
if (table.Count() > 0)
{
DataRow dr = table.Rows[0];
textBox1.Text = dr["yhzh"].AsString();
textBox2.Text = dr["yhxm"].AsString();
textBox3.Text = dr["yhmm"].AsString();
textBox1.Enabled = false;
}
}
private void button1_Click(object sender, EventArgs e)
{
string mm_o = textBox1.Text;
string mm_n = textBox2.Text;
string mm_n1 = textBox3.Text;
if (string.IsNullOrEmpty(mm_o))
{
MessageBox.Show("原密码不能为空");
return;
}
if (string.IsNullOrEmpty(mm_n))
{
MessageBox.Show("新密码不能为空");
return;
}
if (string.IsNullOrEmpty(mm_n1))
{
MessageBox.Show("重复新密码不能为空");
return;
}
if (mm_n == mm_o)
{
MessageBox.Show("新密码不能与原密码相同");
return;
}
if (mm_n != mm_n1)
{
MessageBox.Show("两次密码输入一致");
return;
}
DataTable table = new SqlServerHelper().QuerySqlDataTable("select * from denglu where zh=N'" + GlobalVar.denglu_zh + "' and mm=N'" + mm_o + "'");
if (table.Count() > 0)
{
string sql = "update denglu set mm=N'" + mm_n + "' where zh=N'" + GlobalVar.denglu_zh + "'";
new SqlServerHelper().ExecuteSql(sql);
MessageBox.Show("密码修改成功");
this.Close();
}
else
{
MessageBox.Show("原密码输入不正确");
}
}
public Form6(int id)
{
InitializeComponent();
this.id = id;
string sql = "select * from sjsfgl where id=" + id.ToString();
DataTable table = new SqlServerHelper().QuerySqlDataTable(sql);
if (table.Count() > 0)
{
DataRow row = table.Rows[0];
textBox1.Text = row["mc"].AsString();
textBox2.Text = row["xh"].AsString();
textBox3.Text = row["sfy"].AsString();
dateTimePicker1.Value = row["sfrq"].AsDatetime();
numericUpDown1.Value = row["sl"].AsDecimal();
numericUpDown2.Value = row["dj"].AsDecimal();
}
}
private void button4_Click(object sender, EventArgs e)
{
string zh = textBox4.Text;
string sql = "select * from denglu where 1=1";
if (!string.IsNullOrEmpty(zh))
{
sql += " and zh like'%" + zh + "%'";
}
DataTable table = new SqlServerHelper().QuerySqlDataTable(sql);
dataGridView1.DataSource = null;
dataGridView1.DataSource = table;
if (table.Count() <= 0)
{
button1_Click(null, null);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//页面验证通过
if (Page.IsValid)
{
//获取账户
string yhzh = name.Text;
//获取密码
string yhmm = pwd.Text;
//获取类别
string yhlb = lb.Value;
//调用登录验证方法
string sql = string.Format("select * from yhxx where yhzh=N'{0}' and " +
"yhmm=N'{1}' and yhlb='{2}'", yhzh, yhmm, yhlb);
DataTable table = new SqlServerHelper().QuerySqlDataTable(sql);
//如果ret返回true，则验证通过，允许用户登录本系统。
//如果ret返回false，则验证不通过，不允许用户登录本系统
if (table.Count() > 0)
{
WebData.LoginUser = yhzh;
WebData.LoginUserName = table.Rows[0]["yhxm"].AsString();
WebData.LoginUserType = yhlb;
//将登录信息保存在会话里
Session[WebData.登录用户] = WebData.LoginUser;
Session[WebData.登录用户名] = WebData.LoginUserName;
Session[WebData.登录用户类别] = WebData.LoginUserType;
//提示用户登录成功，并跳转到主页面
Response.Write("<script>alert('用户登录成功');window.location.href='Default.aspx'</script>");
}
else
{
//提示用户账户密码错误
Response.Write("<script>alert('用户名密码错误，请重新输入');</script>");
}
}
}
private void button4_Click(object sender, EventArgs e)
{
string mc = textBox4.Text;
string xh = textBox5.Text;
string sql = "select * from shoujishoufei where 1=1";
if (!string.IsNullOrEmpty(mc))
{
sql += " and mc like'%" + mc + "%'";
}
if (!string.IsNullOrEmpty(xh))
{
sql += " and xh like'%" + xh + "%'";
}
DataTable table = new SqlServerHelper().QuerySqlDataTable(sql);
dataGridView1.DataSource = null;
dataGridView1.DataSource = table;
if (table.Count() <= 0)
{
button1_Click(null, null);
}
}