public int update(LuongEntities obj)
{
int result = 0;
string strQuery = "update dbo.LuongNhanVien set masoluong='" + obj.MaSoLuong1 + "',songaycong='" + obj.SoNgayCong1 + "',Phucapcv='" + obj.PhuCapCV1 + "',sogiolamthem='" + obj.SoGiolamThem1 + "',hesoluong='" + obj.HeSoLuong1 + "',thuong='" + obj.Thuong1 + "',tamung='" + obj.TamUng1 + "',ngaylap='" + obj.NgayLap1 + "'where MaSoLuong='" + obj.MaSL1 + "'";
DataConfig config = new DataConfig();
result = config.excuteNonquery(strQuery);
return(result);
}
//them csdl
public int insert(LuongEntities obj)
{
int result = 0;
string strQuery = "insert into LuongNhanVien(MaSoLuong,SoNgayCong,PhuCapCV,SoGioLamThem,HeSoLuong,Thuong,TamUng,NgayLap) values ('" + obj.MaSoLuong1 + "','" + obj.SoNgayCong1 + "','" + obj.PhuCapCV1 + "','" + obj.SoGiolamThem1 + "','" + obj.HeSoLuong1 + "','" + obj.Thuong1 + "','" + obj.TamUng1 + "','" + obj.NgayLap1 + "')";
DataConfig config = new DataConfig(); //khoi tao
result = config.excuteNonquery(strQuery); //thuc thi cau lenh
return(result); //tra ve so ban ghi dc them
}
