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