public static List <model.kehu> find_all()//查询出所有客户
{
MySqlConnection conn = Util.Util.getConn();
String sql = "select * from customer";
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
Console.WriteLine("ds:" + ds);
da.Fill(ds);
conn.Close();
//获得DataSet里的数据
List <model.kehu> rs = new List <model.kehu>();;
if (ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)//判断DataSet里是否有值
{
rs = new List <model.kehu>();
int count = ds.Tables[0].Rows.Count;//获得表的行数
for (int i = 0; i < count; i++)
{
model.kehu r = new model.kehu();
r.id = (int)ds.Tables[0].Rows[i]["id"];
r.customer_name = (string)ds.Tables[0].Rows[i]["customer_name"];
r.customer_number = (string)ds.Tables[0].Rows[i]["customer_number"];
r.phone = (string)ds.Tables[0].Rows[i]["phone"];
r.address = (string)ds.Tables[0].Rows[i]["address"];
rs.Add(r);
}
}
return(rs);
}
private void kehu_update_Load(object sender, EventArgs e)
{
Console.Write("！！！！！" + kehuguanli.number);
model.kehu r = dao.customerDaoz.select(number);
Number.Text = r.Customer_number;
Name1.Text = r.Customer_name;
}
private void button1_Click(object sender, EventArgs e)
{
if (Number.Text == "")
{
MessageBox.Show("客户编码不能为空！");
}
else if (Name1.Text == "")
{
MessageBox.Show("客户名称不能为空！");
}
else if (Phone.Text == "")
{
MessageBox.Show("手机号不能为空！");
}
else if (Encoding.Default.GetByteCount(Phone.Text) != 11)
{
MessageBox.Show("手机号长度不为11！");
}
else if (Address.Text == "")
{
MessageBox.Show("地址不能为空！");
}
else
{
string number = Number.Text;
string name = Name1.Text;
string phone = Phone.Text;
string address = Address.Text;
model.kehu r = new model.kehu();
r.Phone = phone;
r.Address = address;
r.Customer_name = name;
r.Customer_number = number;
customerDaoz c = new customerDaoz();
c.addCustomer(number, name, phone, address);
Console.Write(c.kehu + "!!");
if (c.kehu == 0)
{
}
else
{
int node = k.dataGridView1.Rows.Count;
k.dt.Rows.Add(node + 1, number, name, phone, address);
k.dataGridView1.DataSource = k.dt;
this.Close();
}
}
}
public static List <model.kehu> selectAll(String name)//按名字查询
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
List <model.kehu> kehus = new List <model.kehu>();
model.kehu r = new model.kehu();
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM customer where customer_number='" + name + "'";
dataReader = command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
r.Id = dataReader.GetInt16(0);
r.Customer_number = dataReader.GetString(1);
r.Customer_name = dataReader.GetString(2);
r.Phone = dataReader.GetString(3);
r.Address = dataReader.GetString(4);
kehus.Add(r);
}
}
catch (Exception)
{
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(kehus);
}
