private void button1_Click(object sender, System.EventArgs e)
{
string name =this.textBox1.Text;
string sex = "女";
if(this.radioButton1.Checked)
{
sex = "男";
}
object age = this.dateTimePicker1.Value;
string ages = this.dateTimePicker1.Text;
int year = int.Parse(ages.Substring(0,4));
if(year<1989&&name.Length>=2)
{

sqlcmd.CommandText = "AddUser";
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@UserName",name);
sqlcmd.Parameters.Add("@UserSex",sex);
sqlcmd.Parameters.Add("@UserAge",age);
sqlcmd.Parameters.Add("@BorrowMoney",this.label10.Text);
sqlcmd.Parameters.Add("@BorrowTime",this.label11.Text);
sqlcmd.Parameters.Add("@BorrowPassMoney",this.label12.Text);
sqlcmd.Parameters.Add("@BackMoney",this.label13.Text);
sqlcmd.Parameters.Add("@ConductMoney",this.label14.Text);
sqlcmd.Parameters.Add("@BorrowCounts",this.label15.Text);
SqlParameter param =
new SqlParameter("@UserCardID",SqlDbType.Int,4,
ParameterDirection.Output,false,0,0,"UserCardID",
DataRowVersion.Current,null);

sqlcmd.Parameters.Add(param);
try
{
sqlcon.Open();
sqlcmd.ExecuteNonQuery();
MessageBox.Show("添加成功","消息");
string id = sqlcmd.Parameters["@UserCardID"].Value.ToString();
this.label16.Text=id;
}
catch(Exception ey)
{
MessageBox.Show(ey.Message);
}
finally
{
sqlcon.Close();
}


}
else
{
MessageBox.Show("输入错误。从新输入!","消息");
}
}