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
{
string number = Number.Text;
string name = Name1.Text;
string phone = Phone.Text;
model.employee r = new model.employee();
employeeDaoz c = new employeeDaoz();
c.addEmployee(number, name, phone);
Console.Write(c.kehu + "!!");
if (c.kehu == 0)
{
}
else
{
int node = k.dataGridView1.Rows.Count;
k.dt.Rows.Add(node + 1, number, name, phone);
k.dataGridView1.DataSource = k.dt;
this.Close();
}
}
}
public static List <model.employee> selectAll(String number)
{
MySqlConnection conn = Util.Util.getConn();
MySqlDataReader dataReader = null;
MySqlCommand command = null;
List <model.employee> kehus = new List <model.employee>();
model.employee r = new model.employee();
try
{
command = conn.CreateCommand();
command.CommandText = "SELECT * FROM employee where employee_number='" + number + "'";
dataReader = command.ExecuteReader();
Console.WriteLine();
while (dataReader.Read())
{
r.Id = dataReader.GetInt16(0);
r.Employee_number = dataReader.GetString(1);
r.Employee_name = dataReader.GetString(2);
r.Phone = dataReader.GetString(3);
kehus.Add(r);
}
}
catch (Exception)
{
MessageBox.Show("查询出错！");
}
finally
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(kehus);
}
public static List <model.employee> find_all()//查询出所有客户
{
MySqlConnection conn = Util.Util.getConn();
String sql = "select * from employee";
MySqlDataAdapter da = new MySqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
Console.WriteLine("ds:" + ds);
da.Fill(ds);
conn.Close();
//获得DataSet里的数据
List <model.employee> rs = new List <model.employee>();
try
{
if (ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0)//判断DataSet里是否有值
{
rs = new List <model.employee>();
int count = ds.Tables[0].Rows.Count;//获得表的行数
for (int i = 0; i < count; i++)
{
model.employee r = new model.employee();
r.Id = (int)ds.Tables[0].Rows[i]["id"];
r.Employee_name = (string)ds.Tables[0].Rows[i]["employee_name"];
r.Employee_number = (string)ds.Tables[0].Rows[i]["employee_number"];
r.Phone = (string)ds.Tables[0].Rows[i]["phone"];
rs.Add(r);
}
}
}
catch
{
MessageBox.Show("查询出错！");
}
return(rs);
}
private void employee_update_Load(object sender, EventArgs e)
{
Console.Write("！！！！！" + kehuguanli.number);
model.employee r = dao.employeeDaoz.select(number);
Number.Text = r.Employee_number;
}
