private void PersonalCenter_Load(object sender, EventArgs e)
{
string sql = "select * from Client where ClientId='" + Program.username + "'";
DBTools bb = new DBTools();
SqlDataReader reder = bb.reader(sql);
while (reder.Read())
{
label2.Text = reder["ClientId"].ToString();
textBox1.Text = reder["name"].ToString();
textBox2.Text = reder["age"].ToString();
textBox3.Text = reder["ClientPwd"].ToString();
}
}
public bool ksdjhfg()//检验是否已注册
{
string asdd = "select count(*) from Client where ClientId='" + comboBox1.Text + "'";
DBTools bb = new DBTools();
int clienID = bb.Login(asdd);
if (clienID == 1)
{
return(true);
}
else
{
return(false);
}
}
private void 影片列表_Load(object sender, EventArgs e)
{
string sql = @"SELECT [TicketId]
,[MovieName]
,[HouseID]
,[StartTime]
,[EndTime]
,[TicketPrice]
,[number]
FROM [movieDB].[dbo].[Movie]";
DBTools dfg = new DBTools();
Moielist = dfg.QuerByAdapter(sql, "MovieList");
dataGridView1.DataSource = Moielist.Tables["MovieList"];
}
private void button1_Click(object sender, EventArgs e)
{
string sql = string.Format(@"update Client set ClientPwd='{0}',name='{1}',age={2} where ClientId='{3}'", textBox3.Text, textBox1.Text, textBox2.Text, Program.username);
DBTools bb = new DBTools();
int i = bb.DonIntsdf(sql);
if (i > 0)
{
MessageBox.Show("保存成功");
}
else
{
MessageBox.Show("保存失败");
}
}
private void tuidinToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dataGridView1.SelectedRows.Count == 0)
{
MessageBox.Show("请选择一列数据");
return;
}
int a = dataGridView1.SelectedRows[0].Index;
int OrderId = (int)dataGridView1.Rows[a].Cells["OrderId"].Value;
string sql = string.Format(@"update OrderInfo set State='{0}' where OrderId='{1}'", "已退订", OrderId);
DBTools bb = new DBTools();
int i = bb.DonIntsdf(sql);
if (i > 0)
{
MessageBox.Show("退订成功");
loadDate();
}
else
{
MessageBox.Show("退订失败");
}
}
private void button1_Click(object sender, EventArgs e)//注册
{
bool kdfg = ksdjhfg();
if (kdfg == false)
{
string ID = comboBox1.Text;
string PWD = textBox1.Text;
string quePWD = textBox2.Text;
if (ID != "" && PWD != "" && quePWD != "" && textBox3.Text != "")
{
if (ID.Length == 11)
{
bool asd = IsHandset(ID);
if (asd)
{
if (PWD.Length >= 6 && PWD.Length <= 12)
{
if (PWD == quePWD)
{
if (textBox3.Text == he.ToString())
{
string asdd = @"INSERT INTO [movieDB].[dbo].[Client]
([ClientId]
,[ClientPwd])
VALUES
('" + ID + "','" + PWD + "')";
DBTools bb = new DBTools();
int clienID = bb.DonIntsdf(asdd);
if (clienID == 1)
{
MessageBox.Show("注册成功,立即返回登录界面", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Close();
}
else
{
MessageBox.Show("注册失败");
}
}
else
{
MessageBox.Show("验证码不正确");
}
}
else
{
MessageBox.Show("密码不一致");
}
}
else
{
MessageBox.Show("密码长度限制在6-12位");
}
}
else
{
MessageBox.Show("手机号格式不正确");
}
}
else
{
MessageBox.Show("手机号长度不正确");
}
}
else
{
MessageBox.Show("请完善信息！");
}
}
else
{
MessageBox.Show("此用户已注册");
}
}
