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