C# (CSharp) BaoCaoTHTHDT_InFo Examples

Example #1

        public void Xoa(BaoCaoTHTHDT_InFo baocao)
        {
            SqlCommand cmd = new SqlCommand("delete from BaoCaoTHTHDT where MaBCTHTHDT=@mabaocao and MaDuAn=@maduan");

            cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value = baocao.Maubaocao.Mamaubaocao;
            cmd.Parameters.Add("maduan", SqlDbType.Int).Value   = baocao.Duan.MaDuAn;
            ds.Execute(cmd);
        }

Example #2

        public void Sua(BaoCaoTHTHDT_InFo baocao)
        {
            SqlCommand cmd = new SqlCommand("update BaoCaoTHTHDT set VonDauTu=@vondautu,LuyKeVonDauTu=@luykevon,GhiChu=@ghichu where MaBCTHTHDT=@mabaocao and MaDuAn=@maduan");

            cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value         = baocao.Maubaocao.Mamaubaocao;
            cmd.Parameters.Add("maduan", SqlDbType.Int).Value           = baocao.Duan.MaDuAn;
            cmd.Parameters.Add("vondautu", SqlDbType.Int).Value         = baocao.Vondautu;
            cmd.Parameters.Add("luykevon", SqlDbType.Int).Value         = baocao.Luykevon;
            cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
            ds.Execute(cmd);
        }

Example #3

        public void Them(BaoCaoTHTHDT_InFo baocao)
        {
            SqlCommand cmd = new SqlCommand("insert into BaoCaoTHTHDT(MaBCTHTHDT,MaDuAn,VonDauTu,LuyKeVonDauTu,GhiChu) values(@mabaocao,@maduan,@vondautu,@luykevon,@ghichu)");

            cmd.Parameters.Add("mabaocao", SqlDbType.Int).Value         = baocao.Maubaocao.Mamaubaocao;
            cmd.Parameters.Add("maduan", SqlDbType.Int).Value           = baocao.Duan.MaDuAn;
            cmd.Parameters.Add("vondautu", SqlDbType.Int).Value         = baocao.Vondautu;
            cmd.Parameters.Add("luykevon", SqlDbType.Int).Value         = baocao.Luykevon;
            cmd.Parameters.Add("ghichu", SqlDbType.NVarChar, 200).Value = baocao.Ghichu;
            ds.Execute(cmd);
        }

Example #4

File: BaoCaoTHTHDT_Ctrl.cs Project: Technology-Community/Statistical-Reports-Manager

 public void Sua(BaoCaoTHTHDT_InFo baocao)
 {
     dbbaocao.Sua(baocao);
 }

Example #5

File: BaoCaoTHTHDT_Ctrl.cs Project: Technology-Community/Statistical-Reports-Manager

 public void Xoa(BaoCaoTHTHDT_InFo baocao)
 {
     dbbaocao.Xoa(baocao);
 }

Example #6

File: BaoCaoTHTHDT_Ctrl.cs Project: Technology-Community/Statistical-Reports-Manager

 public void Them(BaoCaoTHTHDT_InFo baocao)
 {
     dbbaocao.Them(baocao);
 }