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); } }