//ham lay du lieu tu cotroller void ganDL(LuongDT dtL) { dtL.Bacluong = txtBacLuong.Text.Trim(); dtL.Luongcoban = txtLuongCoBan.Text.Trim(); dtL.Hesoluong = txtHeSoLuong.Text.Trim(); dtL.Hesophucap = txtHeSoPhuCap.Text.Trim(); }
//SỬA dl public bool UpdateData(LuongDT dtL) { cmd.CommandText = "UPDATE luong SET luongcoban = '" + dtL.Luongcoban + "',hesoluong = '" + dtL.Hesoluong + "',hesophucap = '" + dtL.Hesophucap + "'WHERE bacluong ='" + dtL.Bacluong + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; try { conn.OpenConn(); cmd.ExecuteNonQuery(); conn.CloseConn(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); conn.CloseConn(); } return(false); }
//thêm mới dl public bool AddData(LuongDT dtL) { cmd.CommandText = "INSERT INTO luong values ('" + dtL.Bacluong + "','" + dtL.Luongcoban + "','" + dtL.Hesoluong + "','" + dtL.Hesophucap + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = conn.Connection; try { conn.OpenConn(); cmd.ExecuteNonQuery(); conn.CloseConn(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); conn.CloseConn(); } return(false); }
public bool UpdateData(LuongDT dtL) { return(lMH.UpdateData(dtL)); }
public bool AddData(LuongDT dtL) { return(lMH.AddData(dtL)); }