C# (CSharp) EC_tb_Loaihang Exemples

Exemple #1

        public void sual(EC_tb_Loaihang l)
        {
            string sql = (@"UPDATE tb_Loaihang
            SET tenloai =N'" + l.TENLOAI + "', manhom =N'" + l.MANHOM + "' where  maloai =N'" + l.MALOAI + "'");

            cn.ExcuteNonQuery(sql);
        }

Exemple #2

Fichier : E_tb_Loaihang.cs Projet : Hoangthuy98/QLCH_NHom11

 public void themoikh(EC_tb_Loaihang kh)
 {
     if (!khsql.kiemtral(kh.MALOAI))
     {
         khsql.themmoil(kh);
     }
     else
     {
         MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
     }
 }

Exemple #3

Fichier : E_tb_Loaihang.cs Projet : Hoangthuy98/QLCH_NHom11

 public void xoakh(EC_tb_Loaihang kh)
 {
     khsql.xoal(kh);
 }

Exemple #4

Fichier : E_tb_Loaihang.cs Projet : Hoangthuy98/QLCH_NHom11

 public void suakh(EC_tb_Loaihang kh)
 {
     khsql.sual(kh);
 }

Exemple #5

 public void xoal(EC_tb_Loaihang l)
 {
     cn.ExcuteNonQuery("DELETE FROM [tb_Loaihang] WHERE [maloai] = N'" + l.MALOAI + "'");
 }

Exemple #6

 public void themmoil(EC_tb_Loaihang l)
 {
     cn.ExcuteNonQuery(@"INSERT INTO tb_Loaihang
               (maloai, manhom, tenloai) VALUES   (N'" + l.MALOAI + "',N'" + l.MANHOM + "',N'" + l.TENLOAI + "')");
 }