コード例 #1
0
 public bool UpdateTonKho(TonKhoDTO dtoTonKho)
 {
     string strQuery = "Update TONKHO Set ";
     strQuery += "NGAYTHANG = N'" + dtoTonKho.NgayThang + "',";
     strQuery += "MAMATHANG = N'" + dtoTonKho.MaMatHang + "',";
     strQuery += "SOLUONGDAU = " + dtoTonKho.SoLuongDau;
     strQuery += "SOLUONGNHAP = " + dtoTonKho.SoLuongNhap;
     strQuery += "SOLUONGXUAT = " + dtoTonKho.SoLuongXuat;
     strQuery += "SOLUONGTON = " + dtoTonKho.SoLuongTon ;
     strQuery += "Where MATONKHO = N'" + dtoTonKho.MaTonKho + "'";
     return dp.ExecuteNonQuery(strQuery);
 }
コード例 #2
0
 public bool InsertTonKho(TonKhoDTO dtoTonKho)
 {
     string strQuery = "Insert Into TONKHO Values(";
     strQuery += "N'" + dtoTonKho.MaTonKho + "',";
     strQuery += "N'" + dtoTonKho.NgayThang + "',";
     strQuery += "N'" + dtoTonKho.MaMatHang + "',";
     strQuery += dtoTonKho.SoLuongDau;
     strQuery += dtoTonKho.SoLuongNhap;
     strQuery += dtoTonKho.SoLuongXuat;
     strQuery += dtoTonKho.SoLuongTon;
     return dp.ExecuteNonQuery(strQuery);
 }