protected void gridDanhSach_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
        {
            DateTime NgayLap    = DateTime.Parse(e.NewValues["NgayLap"].ToString());
            string   IDNguoiLap = Session["IDNhanVien"].ToString();
            string   NguoiNop   = e.NewValues["NguoiNop"] == null ? "" : e.NewValues["NguoiNop"].ToString();
            string   NoiDung    = e.NewValues["NoiDung"] == null ? "" : e.NewValues["NoiDung"].ToString();
            string   TenPhieu   = e.NewValues["TenPhieu"].ToString();
            double   DuDau      = dtSetting.SoQuyThuChi();
            double   SoTien     = double.Parse(e.NewValues["SoTien"].ToString());
            double   DuCuoi     = 0;

            if (TenPhieu == "0")
            {
                //phiếu thu
                DuCuoi = DuDau + SoTien;
            }
            else
            {
                //phiếu chi
                DuCuoi = DuDau - SoTien;
            }
            string IDLoaiThuChi = e.NewValues["IDLoaiThuChi"].ToString();

            data = new dtChiPhi();
            object ID = data.ThemMoi(NgayLap, IDNguoiLap, NguoiNop, NoiDung, DuDau.ToString(), SoTien.ToString(), DuCuoi.ToString(), IDLoaiThuChi, TenPhieu);

            if (ID != null)
            {
                if (TenPhieu == "0")
                {
                    //phiếu thu
                    data.CapNhatQuiThu(SoTien.ToString());
                }
                else
                {
                    //phiếu chi
                    data.CapNhatQuiChi(SoTien.ToString());
                }
            }
            e.Cancel = true;
            gridDanhSach.CancelEdit();
            LoadGrid();
        }
 private void LoadGrid()
 {
     data = new dtChiPhi();
     gridDanhSach.DataSource = data.DanhSach();
     gridDanhSach.DataBind();
 }