public static int sua(string nvID) { classNV nv = classTim.tim_theo_ID(nvID); //...sua thanh con return 0, 0 thanh con return 1 return(0); }
public static classNV tim_theo_ID(string ID) { classNV result = new classNV(); return(result); //tim khong thanh cong return null }
public static classNV tim_theo_ten(string name) { classNV result = new classNV(); int n; int i; return(result); }
private void butInsert_Click(object sender, EventArgs e) { classNV nv = new classNV(); nv.hoten = in_boxName.Text; nv.ns = in_boxNS.Value; nv.quequan = in_boxQq.Text; nv.donvi = in_boxDV.Text; nv.hesoluong = int.Parse(in_boxBL.Text); nv.socmnd = in_boxCMND.Text; nv.sodienthoai = in_BoxDT.Text; string mess = connect.insert(nv) ? "Them thanh cong " : "Them that bai"; MessageBox.Show(mess); }
private void butEdit_Click(object sender, EventArgs e) { classNV nv = new classNV(); nv.hoten = sHoten.Text; nv.ns = sNgaysinh.Value; nv.quequan = sQuequan.Text; nv.donvi = sDonvi.Text; nv.hesoluong = int.Parse(sBacluong.Text); nv.socmnd = sCMND.Text; nv.sodienthoai = sDienthoai.Text; string mess = connect.edit(nv,sCMND.Text) ? "Sua thanh cong " : "Sua that bai"; MessageBox.Show(mess); }
private void butEdit_Click(object sender, EventArgs e) { classNV nv = new classNV(); nv.hoten = sHoten.Text; nv.ns = sNgaysinh.Value; nv.quequan = sQuequan.Text; nv.donvi = sDonvi.Text; nv.hesoluong = int.Parse(sBacluong.Text); nv.socmnd = sCMND.Text; nv.sodienthoai = sDienthoai.Text; string mess = connect.edit(nv, sCMND.Text) ? "Sua thanh cong " : "Sua that bai"; MessageBox.Show(mess); }
public static bool insert(classNV s) { bool isInsert = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "Add_NV"; com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@hoten", s.hoten); com.Parameters.AddWithValue("@ngaysinh", s.ns); com.Parameters.AddWithValue("@quequan", s.quequan); com.Parameters.AddWithValue("@hesoluong", s.hesoluong); com.Parameters.AddWithValue("@maphong", s.donvi); com.Parameters.AddWithValue("@sodt", s.sodienthoai); com.Parameters.AddWithValue("@socmnd", s.socmnd); com.Connection = con; int i = com.ExecuteNonQuery(); isInsert = i > 0 ? true : false; } return isInsert; }
public static bool insert(classNV s) { bool isInsert = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "Add_NV"; com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@hoten", s.hoten); com.Parameters.AddWithValue("@ngaysinh", s.ns); com.Parameters.AddWithValue("@quequan", s.quequan); com.Parameters.AddWithValue("@hesoluong", s.hesoluong); com.Parameters.AddWithValue("@maphong", s.donvi); com.Parameters.AddWithValue("@sodt", s.sodienthoai); com.Parameters.AddWithValue("@socmnd", s.socmnd); com.Connection = con; int i = com.ExecuteNonQuery(); isInsert = i > 0 ? true : false; } return(isInsert); }
public static classNV tim_theo_ten(string name) { classNV result = new classNV(); return result; }
public static classNV tim_theo_ID(string ID) { classNV result = new classNV(); return result; //tim khong thanh cong return null }