Beispiel #1
0
        public void xoact(string id)
        {
            hoadonct ct = (from c in db.hoadoncts select c).Single(x => x.id == id);

            db.hoadoncts.DeleteOnSubmit(ct);
            db.SubmitChanges();
        }
Beispiel #2
0
        public void suahdct(string idhoadon, string idsp, string diengiai, double sl, double dongia, string idcv, string loaithue, double thue, double chietkhau, double thanhtien, string id, string tiente, double tygia, double nguyente)
        {
            hoadonct ct = (from c in db.hoadoncts select c).Single(x => x.id == id);

            ct.idhoadon  = idhoadon;
            ct.idsanpham = idsp;
            ct.diengiai  = diengiai;
            ct.soluong   = sl;
            ct.dongia    = dongia;
            ct.idcv      = idcv;
            ct.loaithue  = loaithue;
            ct.thue      = thue;
            ct.chietkhau = chietkhau;
            ct.thanhtien = thanhtien;
            ct.tiente    = tiente;
            ct.tygia     = tygia;
            ct.nguyente  = nguyente;

            db.SubmitChanges();
        }
Beispiel #3
0
        public void moihdct(string idhhoadon, string idsanpham, string diengiai, double soluong, double dongia, string idcv, string loaithue, double thue, double chietkhau, double thanhtien, string id, string tiente, double tygia, double nguyente)
        {
            hoadonct hdct = new hoadonct();

            hdct.idhoadon  = idhhoadon;
            hdct.idsanpham = idsanpham;
            hdct.diengiai  = diengiai;
            hdct.soluong   = soluong;
            hdct.dongia    = dongia;
            hdct.idcv      = idcv;
            hdct.loaithue  = loaithue;
            hdct.thue      = thue;
            hdct.chietkhau = chietkhau;
            hdct.thanhtien = thanhtien;
            hdct.id        = id;
            hdct.tiente    = tiente;
            hdct.tygia     = tygia;
            hdct.nguyente  = nguyente;

            db.hoadoncts.InsertOnSubmit(hdct);
            db.SubmitChanges();
        }