/// <summary>
        /// HÀM THỰC HIỆN TÌM KIẾM THÔNG TIN
        /// </summary>
        private void TIMKIEM_THONGTIN()
        {
            byte TRANG_THAI = 2;

            if (optDaxacnhan.Checked)
            {
                TRANG_THAI = 1;
            }
            if (optChuaxacnhan.Checked)
            {
                TRANG_THAI = 0;
            }
            string MaKho = "-1";

            m_dtPhieutrathuocthua = DuocNoitru.ThuocNoitruTimkiemPhieutrathuocthua(Utility.Int32Dbnull(txtId.Text, -1), chkByDate.Checked ? dtFromdate.Value.ToString("dd/MM/yyyy") : "01/01/1900",
                                                                                   chkByDate.Checked ? dtToDate.Value.ToString("dd/MM/yyyy") : "01/01/1900", Utility.Bool2byte(chkTheongaytra.Checked), Utility.Int32Dbnull(txtKhoanoitru.MyID, -1), Utility.Int32Dbnull(txtKhothuoc.MyID, -1)
                                                                                   , Utility.Int32Dbnull(txtNguoitra.MyID, -1), Utility.Int32Dbnull(txtNguoinhan.MyID, -1), TRANG_THAI, KIEU_THUOC_VT);

            Utility.SetDataSourceForDataGridEx_Basic(grdList, m_dtPhieutrathuocthua, true, true, "1=1", "");
            if (!Utility.isValidGrid(grdList))
            {
                if (m_dtDetail != null)
                {
                    m_dtDetail.Clear();
                }
            }
            ModifyCommand();
        }
 /// <summary>
 /// hàm thực hiện việc di chuyển thông tin của trên lưới
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void grdList_SelectionChanged(object sender, EventArgs e)
 {
     if (Utility.isValidGrid(grdList))
     {
         int IDPhieu = Utility.Int32Dbnull(grdList.GetValue(TPhieutrathuocthua.Columns.Id), -1);
         m_dtDetail = DuocNoitru.ThuocNoitruLayChitietPhieutrathuocthua(IDPhieu, (byte)0);
         Utility.SetDataSourceForDataGridEx(grdDetail, m_dtDetail.Tables[0], false, true, "1=1", "");
         Utility.SetDataSourceForDataGridEx(grdChitiet, m_dtDetail.Tables[1], false, true, "1=1", "");
     }
     else
     {
         grdChitiet.DataSource = null;
         grdDetail.DataSource  = null;
     }
     ModifyCommand();
 }
Esempio n. 3
0
        void GetData(byte tonghoplai)
        {
            DataSet dsData = DuocNoitru.ThuocNoitruLayChitietPhieutrathuocthua((int)idPhieutra, tonghoplai);

            Utility.SetDataSourceForDataGridEx(grdPres, dsData.Tables[0], false, true, "1=1", "");
            Utility.SetDataSourceForDataGridEx(grdChitiet, dsData.Tables[1], false, true, "1=1", "");
            foreach (GridEXRow exRow in grdChitiet.GetDataRows())
            {
                exRow.BeginEdit();
                exRow.IsChecked = Utility.Int32Dbnull(exRow.Cells["_checked"].Value, 0) == 1;
                exRow.EndEdit();
            }
            dtpInputDate.Value = _item.NgayLapphieu;
            txtNhanvien.SetId(Utility.Int16Dbnull(_item.NguoiLapphieu, -1));
            txtKhoanoitru.SetId(Utility.Int16Dbnull(_item.IdKhoatra, -1));
            txtKhothuoc.SetId(Utility.Int16Dbnull(_item.IdKhonhan, -1));
        }
Esempio n. 4
0
 private void SearchData()
 {
     try
     {
         hasLoaded = false;
         int id_khoanoitru = Utility.Int32Dbnull(txtKhoanoitru.MyID, -1);
         int id_kho        = Utility.Int32Dbnull(txtKhothuoc.MyID, -1);
         m_dsData.Clear();
         grdPres.DataSource    = null;
         grdChitiet.DataSource = null;
         m_dsData = DuocNoitru.ThuocNoitruTimkiemThuocthuatralai(id_khoanoitru, id_kho, kieu_thuoc_vt);
         Utility.SetDataSourceForDataGridEx_Basic(grdPres, m_dsData.Tables[0], true, true, "1=1", "");
         Utility.SetDataSourceForDataGridEx_Basic(grdChitiet, m_dsData.Tables[1], true, true, "1=1", "ten_thuoc");
     }
     catch (Exception ex)
     {
     }
     finally
     {
         hasLoaded = true;
         ModifyCommands();
     }
 }