Пример #1
0
 private void load_cbo_loai_de_xuat()
 {
     BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN();
     BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN();
     v_us.FillDataset(v_ds, "where id_loai_tu_dien =" + 17);
     m_cbo_loai_de_xuat.DataSource = v_ds.CM_DM_TU_DIEN;
     m_cbo_loai_de_xuat.ValueMember = CM_DM_TU_DIEN.ID;
     m_cbo_loai_de_xuat.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
     DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow();
     v_dr[CM_DM_TU_DIEN.ID] = -1;
     v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 17;
     v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "";
     v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "----------------------------Tất cả-----------------------------";
     v_dr[CM_DM_TU_DIEN.TEN] = "";
     v_dr[CM_DM_TU_DIEN.GHI_CHU] = "";
     v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
     m_cbo_trung_tam.SelectedIndex = 0;
 }
 private void load_cbo_trang_thai()
 {
     m_trang_thai = false;
     BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN();
     BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN();
     v_us.FillDataset(v_ds, "where id_loai_tu_dien = " + 12);
     m_cbo_trang_thai.DataSource = v_ds.CM_DM_TU_DIEN;
     m_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID;
     m_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN;
     DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow();
     v_dr[CM_DM_TU_DIEN.ID] = -1;
     v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 12;
     v_dr[CM_DM_TU_DIEN.TEN] = "Tất cả";
     v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "Tất cả";
     v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "TRANG_THAI_THU";
     v_dr[CM_DM_TU_DIEN.GHI_CHU] = " ";
     v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
     m_cbo_trang_thai.SelectedIndex = 0;
     m_trang_thai = true;
 }
 private void load_data_to_cbo_trang_thai()
 {
     BCTKUS.US_CM_DM_TU_DIEN v_us_trang_thai_van_thu = new BCTKUS.US_CM_DM_TU_DIEN();
     BCTKDS.DS_CM_DM_TU_DIEN v_ds_trang_thai_van_thu = new BCTKDS.DS_CM_DM_TU_DIEN();
     v_us_trang_thai_van_thu.FillDataset(v_ds_trang_thai_van_thu, "where id_loai_tu_dien=22"); //id loai tu dien trang thai van thu
     DataRow v_dr = v_ds_trang_thai_van_thu.CM_DM_TU_DIEN.NewRow();
     v_dr[CM_DM_TU_DIEN.ID] = -1;
     v_dr[CM_DM_TU_DIEN.GHI_CHU] = "";
     v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 22;
     v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = "TatCa";
     v_dr[CM_DM_TU_DIEN.TEN] = "0 - Tất cả";
     v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "0 - Tất cả";
     v_ds_trang_thai_van_thu.Tables[0].Rows.InsertAt(v_dr, 0);
     v_ds_trang_thai_van_thu.AcceptChanges();
     m_cbo_trang_thai.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
     m_cbo_trang_thai.ValueMember = CM_DM_TU_DIEN.ID;
     m_cbo_trang_thai.DataSource = v_ds_trang_thai_van_thu.CM_DM_TU_DIEN;
 }
 private void load_cbo_loai_dinh_muc()
 {
     BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN();
     BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN();
     v_us.FillDataset(v_ds, "where id_loai_tu_dien =" + 17);
     m_cbo_loai_dm.DataSource = v_ds.CM_DM_TU_DIEN;
     m_cbo_loai_dm.ValueMember = CM_DM_TU_DIEN.ID;
     m_cbo_loai_dm.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
     //DataRow v_dr = v_ds.CM_DM_TU_DIEN.NewRow();
     //v_dr[CM_DM_TU_DIEN.ID] = -1;
     //v_dr[CM_DM_TU_DIEN.ID_LOAI_TU_DIEN] = 17;
     //v_dr[CM_DM_TU_DIEN.MA_TU_DIEN] = " ";
     //v_dr[CM_DM_TU_DIEN.TEN] = "Tất cả";
     //v_dr[CM_DM_TU_DIEN.TEN_NGAN] = "Tất cả";
     //v_ds.CM_DM_TU_DIEN.Rows.InsertAt(v_dr, 0);
     //m_cbo_loai_dm.SelectedIndex = 0;
     flag_loai_dm = true;
 }
        private void load_data_2_cbo()
        {
            m_status_cbo = false;
            BCTKDS.DS_CM_DM_TU_DIEN v_ds_cm_dm_tu_dien = new BCTKDS.DS_CM_DM_TU_DIEN();
            BCTKUS.US_CM_DM_TU_DIEN v_us_cm_dm_tu_dien = new BCTKUS.US_CM_DM_TU_DIEN();
            v_us_cm_dm_tu_dien.FillDatasetByLoaiTuDienLoaiDinhMuc(v_ds_cm_dm_tu_dien);

            m_cbo_loai_dinh_muc.DataSource = v_ds_cm_dm_tu_dien.CM_DM_TU_DIEN;
            m_cbo_loai_dinh_muc.DisplayMember = CM_DM_TU_DIEN.TEN_NGAN;
            m_cbo_loai_dinh_muc.ValueMember = CM_DM_TU_DIEN.ID;
            m_status_cbo = true;
        }
 private void load_txt_cbo_trang_thai()
 {
     BCTKUS.US_CM_DM_TU_DIEN v_us = new BCTKUS.US_CM_DM_TU_DIEN();
     BCTKDS.DS_CM_DM_TU_DIEN v_ds = new BCTKDS.DS_CM_DM_TU_DIEN();
     if (m_id_trang_thai != -1)
     {
         v_us.FillDataset(v_ds, "where id = " + m_id_trang_thai);
         m_cbo_trang_thai.Text = v_ds.Tables[0].Rows[0][4].ToString();
     }
     else
     {
         m_cbo_trang_thai.Text = "Tất cả";
     }
 }
 public void Display_for_chi_tiet(decimal v_id_phap_nhan, decimal v_id_trang_thai, DateTime v_dt_tu_ngay, DateTime v_dt_den_ngay, decimal v_tong_bill, decimal v_tong_chi_phi)
 {
     m_obj_trans = get_trans_object(m_fg);
     format_controls();
     m_dt_tu_ngay = v_dt_tu_ngay;
     m_dt_den_ngay = v_dt_den_ngay;
     m_id_trang_thai = v_id_trang_thai;
     load_txt_cbo_trang_thai();
     BCTKUS.US_CM_DM_TU_DIEN v_us_td = new BCTKUS.US_CM_DM_TU_DIEN();
     BCTKDS.DS_CM_DM_TU_DIEN v_ds_td = new BCTKDS.DS_CM_DM_TU_DIEN();
     US_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_us_tong_hop = new US_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
     DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN v_ds_tong_hop = new DS_V_TONG_TIEN_BILL_THEO_PHONG_BAN();
     v_us_td.FillDataset(v_ds_td, "where ID =" + v_id_phap_nhan);
     m_lbl_phap_nhan.Text ="PN: " + v_ds_td.Tables[0].Rows[0][4].ToString().ToUpper();
     m_lbl_tu_ngay.Text = v_dt_tu_ngay.Date.ToShortDateString();
     m_lbl_den_ngay.Text = v_dt_den_ngay.Date.ToShortDateString();
     m_lbl_tong_bill.Text = CIPConvert.ToStr(v_tong_bill, "#,###");
     m_lbl_tong_chi_phi.Text = CIPConvert.ToStr(v_tong_chi_phi, "#,###") + "   (VNĐ)";
     v_us_tong_hop.FillDataset_chi_phi_theo_phong_ban(v_ds_tong_hop, v_id_phap_nhan, v_id_trang_thai, v_dt_tu_ngay, v_dt_den_ngay);
     m_fg.Redraw = false;
     CGridUtils.Dataset2C1Grid(v_ds_tong_hop, m_fg, m_obj_trans);
     CGridUtils.MakeSoTT(0, m_fg);
     m_fg.Redraw = true;
     this.ShowDialog();
 }