public static bool Update(Emp emp)
{
if (!EmpDao.FindByEmpNo(emp))
{
return(false);
}
using (var cn = new SqlConnection(Config.CnStr))
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandText = "update emp set ename=@p2,edate=@p3 where eno=@p1";
cmd.Parameters.AddWithValue("@p1", emp.EmpNo);
cmd.Parameters.AddWithValue("@p2", emp.EmpName);
cmd.Parameters.AddWithValue("@p3", emp.JoinDate);
cn.Open();
cmd.ExecuteNonQuery();
return(true);
}
}
public static bool Add(Emp emp)
{
if (EmpDao.FindByEmpNo(emp))
{
return(false);
}
using (var cn = new SqlConnection(Config.CnStr))
using (var cmd = new SqlCommand())
{
cmd.Connection = cn;
cmd.CommandText = "insert into emp values (@p1,@p2,@p3)";
cmd.Parameters.AddWithValue("@p1", emp.EmpNo);
cmd.Parameters.AddWithValue("@p2", emp.EmpName);
cmd.Parameters.AddWithValue("@p3", emp.JoinDate);
cn.Open();
cmd.ExecuteNonQuery();
return(true);
}
}