C# (CSharp) CT_HDB 예제들

예제 #1

 public void XoaDuLieu(CT_HDB et)
 {
     cn.ThucThiCauLenhSql(@"DELETE FROM CTHDBAN WHERE Mahdban='" + et.Mahdb1 + "'");
 }

예제 #2

        public void SuaDuLieu(CT_HDB et)
        {
            cn.ThucThiCauLenhSql(@" UPDATE    CTHDBAN
SET  Maxe ='" + et.Maxe1 + "', Soluong ='" + et.Soluong1 + "', Dongia ='" + et.Dongia1 + "', Tientra ='" + et.Tientra1 + "', Tienthua ='" + et.Tienthua1 + "', Thanhtoan ='" + et.Thanhtoan1 + "' WHERE Mahdban='" + et.Mahdb1 + "'");
        }

예제 #3

        public void ThemDuLieu(CT_HDB et)
        {
            cn.ThucThiCauLenhSql(@"INSERT INTO CTHDBAN
                      (Mahdban, Maxe, Soluong, Dongia, Tientra, Tienthua, Thanhtoan)
VALUES ('" + et.Mahdb1 + "','" + et.Maxe1 + "','" + et.Soluong1 + "','" + et.Dongia1 + "','" + et.Tientra1 + "','" + et.Tienthua1 + "','" + et.Thanhtoan1 + "')");
        }

예제 #4

 public void XoaDuLieu(CT_HDB et)
 {
     cn.XoaDuLieu(et);
 }

예제 #5

 public void SuaDuLieu(CT_HDB et)
 {
     cn.SuaDuLieu(et);
 }

예제 #6

 public void ThemDuLieu(CT_HDB et)
 {
     cn.ThemDuLieu(et);
 }