private void button1_Click(object sender, EventArgs e)
{
Person p = new Person(Convert.ToInt32(textBox4.Text), textBox1.Text,
Convert.ToInt32(textBox2.Text),textBox3.Text);
new PersonAction().add(p);
Form myForm = new Form3();
myForm.ShowDialog();
}
public void add(Person p)
{
MySqlConnection conn = DBSource.getConn();
String sqlInsert = "insert into person(id,name,age,descs) values("+p.Id+",'"+p.Name+"',"+p.Age+",'"+p.Desc+"')";
MySqlCommand mysqlinsert = new MySqlCommand(sqlInsert,conn);
conn.Open();
mysqlinsert.ExecuteNonQuery();
conn.Close();
}
public fAltersvorsorgerechner()
{
InitializeComponent();
Personen[0] = new Person();
Personen[0].Farbe = Color.GreenYellow;
Personen[1] = new Person();
Personen[1].Farbe = Color.Goldenrod;
pSichtblende.Location = new Point(6, 160);
pSichtblende.BringToFront();
nudGAInRenteGehenImJahr.Minimum = DateTime.Today.Year;
nudGAInRenteGehenImJahr.Maximum = DateTime.Today.Year + 50;
nudGaZPInRenteGehenImJahr.Minimum = DateTime.Today.Year;
nudGaZPInRenteGehenImJahr.Maximum = DateTime.Today.Year + 50;
}
private void button1_Click(object sender, EventArgs e)
{
//传递给update()
Person p = new Person();
p.Id = Convert.ToInt32(richTextBox1.Text);
p.Medicine = richTextBox2.Text;
new PersonAction().update(p);
Person p1 = new PersonAction().queryOne(Convert.ToInt32(richTextBox1.Text));
String str = "挂号业务ID：" + p1.Id + "\n"
+ "姓名：" + p1.Name + "\n"
+ "年龄：" + p1.Age + "\n"
+ "症状：" + p1.Desc + "\n"
+ "诊疗方法和建议: " + p1.Medicine + "\n";
Form5 myForm = new Form5(str);
myForm.ShowDialog();
}
public List<Person> query()
{
MySqlConnection conn = DBSource.getConn();
String sqlSearch = "select * from person";
MySqlCommand mysqlcommand = new MySqlCommand(sqlSearch, conn);
conn.Open();
MySqlDataReader reader = mysqlcommand.ExecuteReader();
List<Person> person = new List<Person>();
Person p = null;
try
{
while (reader.Read())
{
p = new Person();
if (reader.HasRows)
{
p.Id = reader.GetInt32(0);
p.Name = reader.GetString(1);
p.Age = reader.GetInt32(2);
p.Desc = reader.GetString(3);
p.Medicine = reader.GetString(4);
//Console.WriteLine(" 姓名: " + reader.GetString(1) + " 编号 " + reader.GetInt32(0) + " 地址 " + reader.GetString(2));
}
person.Add(p);
}
}
catch (MySqlException ex)
{
Console.WriteLine("查询失败!" + ex.Message);
}
finally
{
reader.Close();
}
conn.Close();
return person;
}
private void FormInterface_Load(object sender, EventArgs e)
{
IOperation operation;
Person p = new Person();
IPerson person = p as IPerson;
operation = p as IOperation;
person.Lastname = "Cajandig";
person.Firstname = "Mikel";
//operation.Save();
Customer c = new Customer();
Icustomer customer = c as Icustomer;
operation = c as IOperation;
customer.LastName = "tininin";
operation.Save();
}
public void update(Person p)
{
PersonDao personDao = new PersonDao();
personDao.update(p);
}
public void add(Person p)
{
PersonDao personDao = new PersonDao();
personDao.add(p);
}
static void Main()
{
//Application.EnableVisualStyles();
//Application.SetCompatibleTextRenderingDefault(false);
//Application.Run(new Form1());
#region 擴充方法練習
int money = 123456789;
int date = 20151022;
double p = 0.123453333;
Console.WriteLine(money.FormatForMoney());
Console.WriteLine(date.FormatForDate());
Console.WriteLine(p.FormatPercent());
#endregion
#region list 多型 委派 練習
List<Student> std = GetStudent();
Console.WriteLine(std[0].id);
std.Add(AddStudent("007", "王八"));
foreach (Student element in std)
{
Console.WriteLine(element.id);
Console.WriteLine(element.name);
}
Console.WriteLine("------------------------------");
std.ForEach(delegate(Student name)
{
Console.WriteLine(name.id);
Console.WriteLine(name.name);
});
Person jeff = new Person("jeff") { Age = 11 };
List<Person> people = new List<Person>
{
new Person("aaa") {Age = 1},
new Person("bbb") {Age = 2},
new Person("ccc") {Age = 3}
};
people.ForEach(delegate(Person element)
{
Console.WriteLine("name:" + element.name);
Console.WriteLine("Age:" + element.Age);
});
IEnumerable<int> aaa = GetCollection();
aaa = GetCollection3(aaa);
foreach (int element in aaa)
{
Console.WriteLine(element);
}
#endregion
Bitmap bm = GenerateImage("2345");
bm.Save("aaa.bmp", ImageFormat.Bmp);
}
public Person queryOne(int id)
{
MySqlConnection conn = DBSource.getConn();
String sqlSearch = "select * from person where id = " + id + "";
MySqlCommand mysqlcommand = new MySqlCommand(sqlSearch, conn);
conn.Open();
MySqlDataReader reader = mysqlcommand.ExecuteReader();
Person p = null;
try
{
while (reader.Read())
{
p = new Person();
if (reader.HasRows)
{
p.Id = reader.GetInt32(0);
p.Name = reader.GetString(1);
p.Age = reader.GetInt32(2);
p.Desc = reader.GetString(3);
p.Medicine = reader.GetString(4);
}
}
}
catch (MySqlException ex)
{
Console.WriteLine("查询失败!" + ex.Message);
}
finally
{
reader.Close();
}
conn.Close();
return p;
}
public void update(Person p)
{
MySqlConnection conn = DBSource.getConn();
String sqlUpdate = "update person set medicine = '" + p.Medicine + "' where id =" + p.Id + "";
MySqlCommand mysqlupdate = new MySqlCommand(sqlUpdate, conn);
conn.Open();
mysqlupdate.ExecuteNonQuery();
conn.Close();
}