private void ApplyFilters() { GridEXFilterCondition condition = new GridEXFilterCondition(); GridEXColumn column = new GridEXColumn(); gridExAgreementsListGrouped.RemoveFilters(); string ktm = gridExDescriptorChanges.CurrentRow.Cells["KTM"].Value.ToString(); string descriptorOld = gridExDescriptorChanges.CurrentRow.Cells["DESKRYPOTR_OLD"].Value.ToString(); string findString = string.Format("{0}|{1};", ktm, descriptorOld); column = gridExAgreementsListGrouped.RootTable.Columns["Find"]; condition.AddCondition(new GridEXFilterCondition(column, ConditionOperator.Contains, findString)); gridExAgreementsListGrouped.RootTable.ApplyFilter(condition); }
protected override void OnTextBoxTextChanged(EventArgs e) { GridEXFilterCondition internalFilter = new GridEXFilterCondition(); String str = TextBox.Text; foreach (GridEXColumn column in DropDownList.Columns) { if (!column.Visible) { continue; } GridEXFilterCondition filterCondition = new GridEXFilterCondition(column, ConditionOperator.Contains, str); internalFilter.AddCondition(LogicalOperator.Or, filterCondition); } DropDownList.ApplyFilter(internalFilter); }
/// <summary> /// Lọc dữ liệu khi bắt đầu load data /// </summary> private void SetDefaultFilter() { try { if (FilterParameter != null && FilterParameter.Count > 0 && grdData != null) { GridEXFilterCondition conditionsub; GridEXFilterCondition condition = new GridEXFilterCondition(); int dem = 0; foreach (KeyValuePair <object, object> arrCondition in FilterParameter) { conditionsub = new GridEXFilterCondition(); conditionsub.Column = GrdData.RootTable.Columns[arrCondition.Key.ToString().Trim()]; conditionsub.Value1 = arrCondition.Value.ToString().Trim(); if (dem > 0) { condition.AddCondition(LogicalOperator.And, conditionsub); } else { condition = conditionsub; } dem = dem + 1; } condition.ConditionOperator = ConditionOperator.Contains; filterEditor1.FilterCondition = condition; if (filterEditor1.FilterCondition != null) { filterEditor1.FilterCondition.ConditionOperator = Janus.Data.ConditionOperator.Contains; } filterEditor1.AutomaticHeightResize = true; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi Exception (GxFilter, SetDefaultFilter)", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void SetSumTotalProperties() { try { if (objLuotkham == null) { objLuotkham = Utility.getKcbLuotkham(Utility.Int64Dbnull(txtPatient_ID.Text), Utility.DoTrim(txtPatient_Code.Text)); } string ErrMsg = ""; decimal newBHYT = Utility.DecimaltoDbnull(txtPtramBHChiTra.Text, 0); _THANHTOAN.TinhlaitienBHYTtruocThanhtoan(m_dtChiPhiThanhtoan, TaophieuThanhtoan(), objLuotkham, Taodulieuthanhtoanchitiet(ref ErrMsg), ref newBHYT); txtPtramBHChiTra.Text = newBHYT.ToString(); GridEXColumn gridExColumntrangthaithanhtoan = getGridExColumn(grdThongTinChuaThanhToan, "trangthai_thanhtoan"); GridEXColumn gridExColumn = getGridExColumn(grdThongTinChuaThanhToan, "TT_KHONG_PHUTHU"); GridEXColumn gridExColumn_tutuc = getGridExColumn(grdThongTinChuaThanhToan, "TT_BN_KHONG_TUTUC"); GridEXColumn gridExColumnTT = getGridExColumn(grdThongTinChuaThanhToan, "TT"); GridEXColumn gridExColumnTT_chietkhau = getGridExColumn(grdThongTinChuaThanhToan, KcbThanhtoanChitiet.Columns.TienChietkhau); GridEXColumn gridExColumnBHYT = getGridExColumn(grdThongTinChuaThanhToan, "TT_BHYT"); GridEXColumn gridExColumnTTBN = getGridExColumn(grdThongTinChuaThanhToan, "TT_BN"); GridEXColumn gridExColumntutuc = getGridExColumn(grdThongTinChuaThanhToan, "tu_tuc"); GridEXColumn gridExColumntrangthai_huy = getGridExColumn(grdThongTinChuaThanhToan, "trangthai_huy"); GridEXColumn gridExColumnPhuThu = getGridExColumn(grdThongTinChuaThanhToan, "TT_PHUTHU"); var gridExFilterCondition_khong_Tutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditionTutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterChuathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 0); var gridExFilterDathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 1); var gridExFilterCondition_TuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterConditionKhongTuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy_va_khongtutuc = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); gridExFilterConditiontrangthai_huy_va_khongtutuc.AddCondition(gridExFilterConditionKhongTuTuc); GridEXColumn gridExColumnBNCT = getGridExColumn(grdThongTinChuaThanhToan,"bnhan_chitra"); // Janus.Windows.GridEX.GridEXColumn gridExColumnTuTuc = getGridExColumn(grdThongTinChuaThanhToan, "bnhan_chitra"); //decimal BN_KHONGTUTUC = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumn_tutuc, AggregateFunction.Sum, // gridExFilterCondition_khong_Tutuc)); //decimal TT = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTT, AggregateFunction.Sum,gridExFilterConditiontrangthai_huy)); //decimal TT_Chietkhau = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTT_chietkhau, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_KHONG_PHUTHU = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumn, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_BHYT = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnBHYT, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_BN = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_BN_DaTT = // Utility.DecimaltoDbnull(grdThongTinDaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //Chuathanhtoan = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, // gridExFilterChuathanhtoan)); ////Tạm bỏ ////decimal PtramBHYT = 0; ////_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); //decimal PhuThu = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); //decimal TuTuc = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnBNCT, AggregateFunction.Sum, // gridExFilterConditionTutuc)); decimal BN_KHONGTUTUC = 0m; decimal TT = 0m; decimal TT_Chietkhau = 0m; decimal TT_KHONG_PHUTHU = 0m; decimal TT_BHYT = 0m; decimal TT_BN = 0m; decimal TT_BN_DaTT = 0m; Chuathanhtoan = 0m; //Tạm bỏ //decimal PtramBHYT = 0; //_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); decimal PhuThu = 0m; decimal TuTuc = 0m; foreach (DataRowView drv in m_dtChiPhiThanhtoan.DefaultView) { if (Utility.Int32Dbnull(drv["tinh_chiphi"], 0) == 1) { if (Utility.Int32Dbnull(drv["tu_tuc"], 0) == 0) BN_KHONGTUTUC += Utility.DecimaltoDbnull(drv["TT_BN_KHONG_TUTUC"], 0); if (Utility.Int32Dbnull(drv["trangthai_huy"], 0) == 0) { TT += Utility.DecimaltoDbnull(drv["TT"], 0); TT_Chietkhau += Utility.DecimaltoDbnull(drv[KcbThanhtoanChitiet.Columns.TienChietkhau], 0); TT_KHONG_PHUTHU += Utility.DecimaltoDbnull(drv["TT_KHONG_PHUTHU"], 0); TT_BHYT += Utility.DecimaltoDbnull(drv["TT_BHYT"], 0); TT_BN += Utility.DecimaltoDbnull(drv["TT_BN"], 0); TT_BN_DaTT += Utility.DecimaltoDbnull(drv["TT_BN"], 0); } if (Utility.Int32Dbnull(drv["trangthai_thanhtoan"], 0) == 0) Chuathanhtoan += Utility.DecimaltoDbnull(drv["TT_BN"], 0); PhuThu += Utility.DecimaltoDbnull(drv["TT_PHUTHU"], 0); if (Utility.Int32Dbnull(drv["tu_tuc"], 0) == 1) TuTuc += Utility.DecimaltoDbnull(drv["TT_TUTUC"], 0); } } txtTongChiPhi.Text = Utility.sDbnull(TT); TT_KHONG_PHUTHU -= TuTuc; txtTongtienDCT.Text = objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull( TT_BHYT +BN_KHONGTUTUC);// objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull(TT_KHONG_PHUTHU); txtPhuThu.Text = Utility.sDbnull(PhuThu); txtTuTuc.Text = Utility.sDbnull(TuTuc); //decimal BHCT = TongChiphiBHYT*PtramBHYT/100; txtBHCT.Text = Utility.sDbnull(TT_BHYT, "0"); decimal BNCT = BN_KHONGTUTUC; txtBNCT.Text = Utility.sDbnull(BNCT); decimal BNPhaiTra = BNCT + Utility.DecimaltoDbnull(txtTuTuc.Text, 0) + Utility.DecimaltoDbnull(txtPhuThu.Text); txtBNPhaiTra.Text = Utility.sDbnull(TT_BN); TinhToanSoTienPhaithu(); decimal Tong_Tamung = 0; if (ucTamung1.m_dtTamung != null) { Tong_Tamung = Utility.DecimaltoDbnull(ucTamung1.m_dtTamung.Compute("SUM(so_tien)", "1=1"), 0); if (Math.Abs(Tong_Tamung) != 0) { decimal chenhlech = Chuathanhtoan - Tong_Tamung; if (cmdHoanung.Tag.ToString() == "1")//Đã hoàn ứng chenhlech = 0; if (chenhlech > 0) { lblThuathieu.Text = "BN Nộp tiền"; txtThuathieu.Text = chenhlech.ToString(); } else { lblThuathieu.Text = "Trả lại BN"; txtThuathieu.Text = Math.Abs(chenhlech).ToString(); } } } if (Tong_Tamung == 0) { lblThuathieu.Text = "BN Nộp tiền"; txtThuathieu.Text = txtSoTienCanNop.Text; } ModifyCommand(); } catch { } }
private void ApplyTribunalMemberFilter() { // code to apply filter criteria to memmebrs list if (CurrentRow() != null) { grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].ApplyFilter(null); // clear filter GridEXFilterCondition filtTribunalMember = new GridEXFilterCondition(); if (this.chkLanguage.Checked) // add language filter { if (CurrentRow().FileLanguageCode == "F") { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearFre"], ConditionOperator.Equal, true)); } else if (CurrentRow().FileLanguageCode == "E") { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearEng"], ConditionOperator.Equal, true)); } else { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearFre"], ConditionOperator.Equal, true)); filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["CanHearEng"], ConditionOperator.Equal, true)); } } if (this.chkTraining.Checked) // add training filter { // charter condition if (CurrentRow().IsCharter) { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["TrainedCharter"], ConditionOperator.Equal, true)); } // program & benefit condition if (!CurrentRow().IsAccountIdNull()) { atLogic.ObjectBE obe = myAtMng.GetCodeTableBE("AccountType"); if (obe.myDT.Rows.Count == 0) { obe.Load(); } CodesDB.AccountTypeDataTable atdt = (CodesDB.AccountTypeDataTable)obe.myDT; CodesDB.AccountTypeRow atr = atdt.FindByAccountTypeId(CurrentRow().AccountId); string trainedByProgramColumn = ""; switch (atr.ProgramID) { case 3: // EI trainedByProgramColumn = "TrainedEI"; break; case 8: // CPP trainedByProgramColumn = "TrainedCPP"; break; case 9: // OAS trainedByProgramColumn = "TrainedOAS"; break; } if (trainedByProgramColumn != "") { filtTribunalMember.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns[trainedByProgramColumn], ConditionOperator.Equal, true)); } } } if (this.chkLocation.Checked) // add location filter { var memberId = new List <int>(); if (!CurrentRow().IsOfficeIdNull()) { int selectedSCOfficeId = CurrentRow().OfficeId; // get service centre latitude and longitude lmDatasets.MemberManagement.OfficeSCListRow scr = myMemMng.DB.OfficeSCList.FindByOfficeId(selectedSCOfficeId);// myAtMng.OfficeMng.GetServiceCentre().Load(selectedSCOfficeId); if (!scr.IsLatitudeNull() && !scr.IsLongitudeNull()) { // get member postal code double distance; maxDistance = (int)maxDistanceEditBox.Value; foreach (MemberManagement.MemberListAssignmentFilterRow mlafr in mListAssignmentFilter) { if (!mlafr.IsLatitudeNull()) { distance = myAtMng.GetPostalCodeLocation().CalculateDistance((double)mlafr.Latitude, (double)mlafr.Longitude, (double)scr.Latitude, (double)scr.Longitude); if (distance >= 0 && distance <= maxDistance) { memberId.Add(mlafr.OfficerId); } } } } } if (memberId.Count == 0) { memberId.Add(-1); } GridEXFilterCondition filtLocation = new GridEXFilterCondition(); foreach (int memID in memberId) { if (filtLocation.Conditions.Count == 0) { filtLocation.AddCondition(new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["OfficerId"], ConditionOperator.Equal, memID)); } else { filtLocation.AddCondition(LogicalOperator.Or, new GridEXFilterCondition(grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].Columns["OfficerId"], ConditionOperator.Equal, memID)); } } filtTribunalMember.AddCondition(filtLocation); } // apply filter only if conditions exist if (filtTribunalMember.Conditions.Count > 0) { grexAppealsReadyForAssignment.DropDowns["ddMemberListAssignmentFilter"].ApplyFilter(filtTribunalMember); } } }
private void SetSumTotalProperties() { try { if (objLuotkham == null) { objLuotkham = CreatePatientExam(); } GridEXColumn gridExColumntrangthaithanhtoan = getGridExColumn(grdThongTinChuaThanhToan, "trangthai_thanhtoan"); GridEXColumn gridExColumn = getGridExColumn(grdThongTinChuaThanhToan, "TT_KHONG_PHUTHU"); GridEXColumn gridExColumn_tutuc = getGridExColumn(grdThongTinChuaThanhToan, "TT_BN_KHONG_TUTUC"); GridEXColumn gridExColumnTT = getGridExColumn(grdThongTinChuaThanhToan, "TT"); GridEXColumn gridExColumnTT_chietkhau = getGridExColumn(grdThongTinChuaThanhToan, KcbThanhtoanChitiet.Columns.TienChietkhau); GridEXColumn gridExColumnBHYT = getGridExColumn(grdThongTinChuaThanhToan, "TT_BHYT"); GridEXColumn gridExColumnTTBN = getGridExColumn(grdThongTinChuaThanhToan, "TT_BN"); GridEXColumn gridExColumntutuc = getGridExColumn(grdThongTinChuaThanhToan, "tu_tuc"); GridEXColumn gridExColumntrangthai_huy = getGridExColumn(grdThongTinChuaThanhToan, "trangthai_huy"); GridEXColumn gridExColumnPhuThu = getGridExColumn(grdThongTinChuaThanhToan, "TT_PHUTHU"); var gridExFilterCondition_khong_Tutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditionTutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterChuathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 0); var gridExFilterDathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 1); var gridExFilterCondition_TuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterConditionKhongTuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy_va_khongtutuc = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); gridExFilterConditiontrangthai_huy_va_khongtutuc.AddCondition(gridExFilterConditionKhongTuTuc); GridEXColumn gridExColumnBNCT = getGridExColumn(grdThongTinChuaThanhToan, "bnhan_chitra"); // Janus.Windows.GridEX.GridEXColumn gridExColumnTuTuc = getGridExColumn(grdThongTinChuaThanhToan, "bnhan_chitra"); decimal BN_KHONGTUTUC = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumn_tutuc, AggregateFunction.Sum), gridExFilterCondition_khong_Tutuc); decimal TT = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTT, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_Chietkhau = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTT_chietkhau, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_KHONG_PHUTHU = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumn, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_BHYT = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnBHYT, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); decimal TT_BN = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); decimal TT_BN_DaTT = Utility.DecimaltoDbnull(grdThongTinDaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); Chuathanhtoan = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterChuathanhtoan)); //Tạm bỏ //decimal PtramBHYT = 0; //_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); decimal PhuThu = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); decimal TuTuc = Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnBNCT, AggregateFunction.Sum, gridExFilterConditionTutuc)); //txtPtramBHChiTra.Text = Utility.sDbnull(PtramBHYT); txtTongChiPhi.Text = Utility.sDbnull(TT); TT_KHONG_PHUTHU -= TuTuc; txtTongtienDCT.Text = objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull( TT_BHYT +BN_KHONGTUTUC);// objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull(TT_KHONG_PHUTHU); txtPhuThu.Text = Utility.sDbnull(PhuThu); txtTuTuc.Text = Utility.sDbnull(TuTuc); //decimal BHCT = TongChiphiBHYT*PtramBHYT/100; txtBHCT.Text = Utility.sDbnull(TT_BHYT, "0"); decimal BNCT = BN_KHONGTUTUC; txtBNCT.Text = Utility.sDbnull(BNCT); decimal BNPhaiTra = BNCT + Utility.DecimaltoDbnull(txtTuTuc.Text, 0) + Utility.DecimaltoDbnull(txtPhuThu.Text); txtBNPhaiTra.Text = Utility.sDbnull(TT_BN); txtSoTienCanNop.Text = Utility.sDbnull(Chuathanhtoan); //Tạm bỏ TinhToanSoTienPhaithu(); ModifyCommand(); } catch { } }
private void SetSumTotalProperties() { try { GridEXColumn gridExColumntrangthaithanhtoan = getGridExColumn(grdChitiet, "trangthai_thanhtoan"); GridEXColumn gridExColumn = getGridExColumn(grdChitiet, "TT_KHONG_PHUTHU"); GridEXColumn gridExColumn_tutuc = getGridExColumn(grdChitiet, "TT_BN_KHONG_TUTUC"); GridEXColumn gridExColumnTT = getGridExColumn(grdChitiet, "TT"); GridEXColumn gridExColumnTT_chietkhau = getGridExColumn(grdChitiet, KcbThanhtoanChitiet.Columns.TienChietkhau); GridEXColumn gridExColumnBHYT = getGridExColumn(grdChitiet, "TT_BHYT"); GridEXColumn gridExColumnTTBN = getGridExColumn(grdChitiet, "TT_BN"); GridEXColumn gridExColumntutuc = getGridExColumn(grdChitiet, "tu_tuc"); GridEXColumn gridExColumntrangthai_huy = getGridExColumn(grdChitiet, "trangthai_huy"); GridEXColumn gridExColumnPhuThu = getGridExColumn(grdChitiet, "TT_PHUTHU"); var gridExFilterCondition_khong_Tutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditionTutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterChuathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 0); var gridExFilterDathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 1); var gridExFilterCondition_TuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterConditionKhongTuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy_va_khongtutuc = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); gridExFilterConditiontrangthai_huy_va_khongtutuc.AddCondition(gridExFilterConditionKhongTuTuc); GridEXColumn gridExColumnBNCT = getGridExColumn(grdChitiet, "bnhan_chitra"); // Janus.Windows.GridEX.GridEXColumn gridExColumnTuTuc = getGridExColumn(grdChitiet, "bnhan_chitra"); decimal BN_KHONGTUTUC = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumn_tutuc, AggregateFunction.Sum), gridExFilterCondition_khong_Tutuc); decimal TT = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnTT, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_Chietkhau = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnTT_chietkhau, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_KHONG_PHUTHU = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumn, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_BHYT = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnBHYT, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); decimal TT_BN = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); Chuathanhtoan = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterChuathanhtoan)); //Tạm bỏ //decimal PtramBHYT = 0; //_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); decimal PhuThu = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); decimal TuTuc = Utility.DecimaltoDbnull(grdChitiet.GetTotal(gridExColumnBNCT, AggregateFunction.Sum, gridExFilterConditionTutuc)); //txtPtramBHChiTra.Text = Utility.sDbnull(PtramBHYT); TT_KHONG_PHUTHU -= TuTuc; decimal BNCT = BN_KHONGTUTUC; decimal BNPhaiTra = BNCT ; txtSoTienCanNop.Text = Utility.sDbnull(Chuathanhtoan); //Tạm bỏ TinhToanSoTienPhaithu(); ModifyCommand(); } catch { } }
private void SetSumTotalProperties() { try { GridEXColumn gridExColumntrangthaithanhtoan = getGridExColumn(grdPaymentDetail, "trangthai_thanhtoan"); GridEXColumn gridExColumn = getGridExColumn(grdPaymentDetail, "TT_KHONG_PHUTHU"); GridEXColumn gridExColumn_tutuc = getGridExColumn(grdPaymentDetail, "TT_BN_KHONG_TUTUC"); GridEXColumn gridExColumnTT = getGridExColumn(grdPaymentDetail, "TT"); GridEXColumn gridExColumnTT_chietkhau = getGridExColumn(grdPaymentDetail, KcbThanhtoanChitiet.Columns.TienChietkhau); GridEXColumn gridExColumnBHYT = getGridExColumn(grdPaymentDetail, "TT_BHYT"); GridEXColumn gridExColumnTTBN = getGridExColumn(grdPaymentDetail, "TT_BN"); GridEXColumn gridExColumntutuc = getGridExColumn(grdPaymentDetail, "tu_tuc"); GridEXColumn gridExColumntrangthai_huy = getGridExColumn(grdPaymentDetail, "trangthai_huy"); GridEXColumn gridExColumnPhuThu = getGridExColumn(grdPaymentDetail, "TT_PHUTHU"); var gridExFilterCondition_khong_Tutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditionTutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterChuathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 0); var gridExFilterDathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 1); var gridExFilterCondition_TuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterConditionKhongTuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy_va_khongtutuc = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); gridExFilterConditiontrangthai_huy_va_khongtutuc.AddCondition(gridExFilterConditionKhongTuTuc); GridEXColumn gridExColumnBNCT = getGridExColumn(grdPaymentDetail, "bnhan_chitra"); // Janus.Windows.GridEX.GridEXColumn gridExColumnTuTuc = getGridExColumn(grdPaymentDetail, "bnhan_chitra"); decimal BN_KHONGTUTUC = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumn_tutuc, AggregateFunction.Sum), gridExFilterCondition_khong_Tutuc); decimal TT = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTT, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_Chietkhau = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTT_chietkhau, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_KHONG_PHUTHU = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumn, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_BHYT = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnBHYT, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); decimal TT_BN = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); Chuathanhtoan = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterChuathanhtoan)); //Tạm bỏ //decimal PtramBHYT = 0; //_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); decimal PhuThu = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); decimal TuTuc = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnBNCT, AggregateFunction.Sum, gridExFilterConditionTutuc)); //txtPtramBHChiTra.Text = Utility.sDbnull(PtramBHYT); txtTongChiPhi.Text = Utility.sDbnull(TT); TT_KHONG_PHUTHU -= TuTuc; txtTongtienDCT.Text = objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull(TT_BHYT + BN_KHONGTUTUC);// objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull(TT_KHONG_PHUTHU); txtPhuThu.Text = Utility.sDbnull(PhuThu); txtTuTuc.Text = Utility.sDbnull(TuTuc); //decimal BHCT = TongChiphiBHYT*PtramBHYT/100; txtBHCT.Text = Utility.sDbnull(TT_BHYT, "0"); decimal BNCT = BN_KHONGTUTUC; txtBNCT.Text = Utility.sDbnull(BNCT); decimal BNPhaiTra = BNCT + Utility.DecimaltoDbnull(txtTuTuc.Text, 0) + Utility.DecimaltoDbnull(txtPhuThu.Text); txtBNPhaiTra.Text = Utility.sDbnull(TT_BN); KcbThanhtoanCollection _item = new KcbThanhtoanController().FetchByID(v_Payment_Id); if (!_item.Any()) { txtsotiendathu.Text = "0"; txtDachietkhau.Text = "0"; } else { txtDachietkhau.Text = _item.FirstOrDefault().TongtienChietkhau.ToString(); txtsotiendathu.Text = (Utility.DecimaltoDbnull(_item.FirstOrDefault().BnhanChitra, 0) + Utility.DecimaltoDbnull(_item.FirstOrDefault().PhuThu, 0) + Utility.DecimaltoDbnull(_item.FirstOrDefault().TuTuc, 0) - Utility.DecimaltoDbnull(txtDachietkhau.Text, 0)).ToString(); } ModifyCommand(); } catch { } }
private void SetSumTotalProperties() { try { if (objLuotkham == null) { objLuotkham = Utility.getKcbLuotkham(Utility.Int64Dbnull(txtPatient_ID.Text), Utility.DoTrim(txtPatient_Code.Text)); } GridEXColumn gridExColumntrangthaithanhtoan = getGridExColumn(grdThongTinChuaThanhToan, "trangthai_thanhtoan"); GridEXColumn gridExColumn = getGridExColumn(grdThongTinChuaThanhToan, "TT_KHONG_PHUTHU"); GridEXColumn gridExColumn_tutuc = getGridExColumn(grdThongTinChuaThanhToan, "TT_BN_KHONG_TUTUC"); GridEXColumn gridExColumnTT = getGridExColumn(grdThongTinChuaThanhToan, "TT"); GridEXColumn gridExColumnTT_chietkhau = getGridExColumn(grdThongTinChuaThanhToan, KcbThanhtoanChitiet.Columns.TienChietkhau); GridEXColumn gridExColumnBHYT = getGridExColumn(grdThongTinChuaThanhToan, "TT_BHYT"); GridEXColumn gridExColumnTTBN = getGridExColumn(grdThongTinChuaThanhToan, "TT_BN"); GridEXColumn gridExColumntutuc = getGridExColumn(grdThongTinChuaThanhToan, "tu_tuc"); GridEXColumn gridExColumntrangthai_huy = getGridExColumn(grdThongTinChuaThanhToan, "trangthai_huy"); GridEXColumn gridExColumnPhuThu = getGridExColumn(grdThongTinChuaThanhToan, "TT_PHUTHU"); var gridExFilterCondition_khong_Tutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditionTutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterChuathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 0); var gridExFilterDathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 1); var gridExFilterCondition_TuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterConditionKhongTuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy_va_khongtutuc = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); gridExFilterConditiontrangthai_huy_va_khongtutuc.AddCondition(gridExFilterConditionKhongTuTuc); GridEXColumn gridExColumnBNCT = getGridExColumn(grdThongTinChuaThanhToan,"bnhan_chitra"); // Janus.Windows.GridEX.GridEXColumn gridExColumnTuTuc = getGridExColumn(grdThongTinChuaThanhToan, "bnhan_chitra"); //decimal BN_KHONGTUTUC = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumn_tutuc, AggregateFunction.Sum, // gridExFilterCondition_khong_Tutuc)); //decimal TT = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTT, AggregateFunction.Sum,gridExFilterConditiontrangthai_huy)); //decimal TT_Chietkhau = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTT_chietkhau, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_KHONG_PHUTHU = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumn, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_BHYT = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnBHYT, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_BN = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //decimal TT_BN_DaTT = // Utility.DecimaltoDbnull(grdThongTinDaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, // gridExFilterConditiontrangthai_huy)); //Chuathanhtoan = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, // gridExFilterChuathanhtoan)); ////Tạm bỏ ////decimal PtramBHYT = 0; ////_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); //decimal PhuThu = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); //decimal TuTuc = // Utility.DecimaltoDbnull(grdThongTinChuaThanhToan.GetTotal(gridExColumnBNCT, AggregateFunction.Sum, // gridExFilterConditionTutuc)); decimal BN_KHONGTUTUC = 0m; decimal TT = 0m; decimal TT_Chietkhau = 0m; decimal TT_KHONG_PHUTHU = 0m; decimal TT_BHYT = 0m; decimal TT_BN = 0m; decimal TT_BN_DaTT = 0m; Chuathanhtoan = 0m; //Tạm bỏ //decimal PtramBHYT = 0; //_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); decimal PhuThu = 0m; decimal TuTuc = 0m; foreach (DataRowView drv in m_dtChiPhiThanhtoan.DefaultView) { if (Utility.Int32Dbnull(drv["tinh_chiphi"], 0) == 1) { if (Utility.Int32Dbnull(drv["tu_tuc"], 0) == 0) BN_KHONGTUTUC += Utility.DecimaltoDbnull(drv["TT_BN_KHONG_TUTUC"], 0); if (Utility.Int32Dbnull(drv["trangthai_huy"], 0) == 0) { TT += Utility.DecimaltoDbnull(drv["TT"], 0); TT_Chietkhau += Utility.DecimaltoDbnull(drv[KcbThanhtoanChitiet.Columns.TienChietkhau], 0); TT_KHONG_PHUTHU += Utility.DecimaltoDbnull(drv["TT_KHONG_PHUTHU"], 0); TT_BHYT += Utility.DecimaltoDbnull(drv["TT_BHYT"], 0); TT_BN += Utility.DecimaltoDbnull(drv["TT_BN"], 0); TT_BN_DaTT += Utility.DecimaltoDbnull(drv["TT_BN"], 0); } if (Utility.Int32Dbnull(drv["trangthai_thanhtoan"], 0) == 0) Chuathanhtoan += Utility.DecimaltoDbnull(drv["TT_BN"], 0); PhuThu += Utility.DecimaltoDbnull(drv["TT_PHUTHU"], 0); if (Utility.Int32Dbnull(drv["tu_tuc"], 0) == 1) TuTuc += Utility.DecimaltoDbnull(drv["TT_TUTUC"], 0); } } //txtPtramBHChiTra.Text = Utility.sDbnull(PtramBHYT); txtTongChiPhi.Text = Utility.sDbnull(TT); TT_KHONG_PHUTHU -= TuTuc; txtTongtienDCT.Text = objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull( TT_BHYT +BN_KHONGTUTUC);// objLuotkham.MaDoituongKcb == "DV" ? "0" : Utility.sDbnull(TT_KHONG_PHUTHU); txtPhuThu.Text = Utility.sDbnull(PhuThu); txtTuTuc.Text = Utility.sDbnull(TuTuc); //decimal BHCT = TongChiphiBHYT*PtramBHYT/100; txtBHCT.Text = Utility.sDbnull(TT_BHYT, "0"); decimal BNCT = BN_KHONGTUTUC; txtBNCT.Text = Utility.sDbnull(BNCT); decimal BNPhaiTra = BNCT + Utility.DecimaltoDbnull(txtTuTuc.Text, 0) + Utility.DecimaltoDbnull(txtPhuThu.Text); txtBNPhaiTra.Text = Utility.sDbnull(TT_BN); txtSoTienCanNop.Text = Utility.sDbnull(Chuathanhtoan); //Tạm bỏ TinhToanSoTienPhaithu(); ModifyCommand(); } catch { } }
private void SetSumTotalProperties() { try { GridEXColumn gridExColumntrangthaithanhtoan = getGridExColumn(grdPaymentDetail, "trangthai_thanhtoan"); GridEXColumn gridExColumn = getGridExColumn(grdPaymentDetail, "TT_KHONG_PHUTHU"); GridEXColumn gridExColumn_tutuc = getGridExColumn(grdPaymentDetail, "TT_BN_KHONG_TUTUC"); GridEXColumn gridExColumnTT = getGridExColumn(grdPaymentDetail, "TT"); GridEXColumn gridExColumnTT_chietkhau = getGridExColumn(grdPaymentDetail, KcbThanhtoanChitiet.Columns.TienChietkhau); GridEXColumn gridExColumnBHYT = getGridExColumn(grdPaymentDetail, "TT_BHYT"); GridEXColumn gridExColumnTTBN = getGridExColumn(grdPaymentDetail, "TT_BN"); GridEXColumn gridExColumntutuc = getGridExColumn(grdPaymentDetail, "tu_tuc"); GridEXColumn gridExColumntrangthai_huy = getGridExColumn(grdPaymentDetail, "trangthai_huy"); GridEXColumn gridExColumnPhuThu = getGridExColumn(grdPaymentDetail, "TT_PHUTHU"); var gridExFilterCondition_khong_Tutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditionTutuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterChuathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 0); var gridExFilterDathanhtoan = new GridEXFilterCondition(gridExColumntrangthaithanhtoan, ConditionOperator.Equal, 1); var gridExFilterCondition_TuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 1); var gridExFilterConditionKhongTuTuc = new GridEXFilterCondition(gridExColumntutuc, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); var gridExFilterConditiontrangthai_huy_va_khongtutuc = new GridEXFilterCondition(gridExColumntrangthai_huy, ConditionOperator.Equal, 0); gridExFilterConditiontrangthai_huy_va_khongtutuc.AddCondition(gridExFilterConditionKhongTuTuc); GridEXColumn gridExColumnBNCT = getGridExColumn(grdPaymentDetail, "bnhan_chitra"); // Janus.Windows.GridEX.GridEXColumn gridExColumnTuTuc = getGridExColumn(grdPaymentDetail, "bnhan_chitra"); decimal BN_KHONGTUTUC = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumn_tutuc, AggregateFunction.Sum), gridExFilterCondition_khong_Tutuc); decimal TT = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTT, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_Chietkhau = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTT_chietkhau, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_KHONG_PHUTHU = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumn, AggregateFunction.Sum), gridExFilterConditiontrangthai_huy); decimal TT_BHYT = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnBHYT, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); decimal TT_BN = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterConditiontrangthai_huy)); Chuathanhtoan = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnTTBN, AggregateFunction.Sum, gridExFilterChuathanhtoan)); //Tạm bỏ //decimal PtramBHYT = 0; //_THANHTOAN.LayThongPtramBHYT(TongChiphiBHYT, objLuotkham, ref PtramBHYT); decimal PhuThu = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnPhuThu, AggregateFunction.Sum)); decimal TuTuc = Utility.DecimaltoDbnull(grdPaymentDetail.GetTotal(gridExColumnBNCT, AggregateFunction.Sum, gridExFilterConditionTutuc)); //txtPtramBHChiTra.Text = Utility.sDbnull(PtramBHYT); txtTongChiPhi.Text = Utility.sDbnull(TT); TT_KHONG_PHUTHU -= TuTuc; txtTongtienDCT.Text = "0"; txtPhuThu.Text = Utility.sDbnull(PhuThu); txtTuTuc.Text = Utility.sDbnull(TuTuc); //decimal BHCT = TongChiphiBHYT*PtramBHYT/100; txtBHCT.Text = Utility.sDbnull(TT_BHYT, "0"); decimal BNCT = BN_KHONGTUTUC; txtBNCT.Text = Utility.sDbnull(BNCT); decimal BNPhaiTra = BNCT + Utility.DecimaltoDbnull(txtTuTuc.Text, 0) + Utility.DecimaltoDbnull(txtPhuThu.Text); txtBNPhaiTra.Text = Utility.sDbnull(TT_BN); KcbThanhtoanCollection _item = new KcbThanhtoanController().FetchByID(v_Payment_Id); if (!_item.Any()) { txtsotiendathu.Text = "0"; txtDachietkhau.Text = "0"; } else { txtDachietkhau.Text = _item.FirstOrDefault().TongtienChietkhau.ToString(); txtsotiendathu.Text = (Utility.DecimaltoDbnull(_item.FirstOrDefault().BnhanChitra, 0) + Utility.DecimaltoDbnull(_item.FirstOrDefault().PhuThu, 0) + Utility.DecimaltoDbnull(_item.FirstOrDefault().TuTuc, 0) - Utility.DecimaltoDbnull(txtDachietkhau.Text, 0)).ToString(); } ModifyCommand(); } catch { } }
private void btnAddCondition_Click(object sender, EventArgs e) { if ((cmbColumn.SelectedItem == null) || (cmbFilterOperator.SelectedItem == null)) { return; } if (filterCondition == null) { filterCondition = new GridEXFilterCondition(); } LogicalOperator logicalOperator; if (this.rbtAnd.Checked) { logicalOperator = LogicalOperator.And; } else { logicalOperator = LogicalOperator.Or; } GridEXFilterCondition cond = null; if (tbcCondition.SelectedTab == tbpCondition) { cond = new GridEXFilterCondition((GridEXColumn)this.cmbColumn.SelectedItem, ((FilterOperatorListItem)this.cmbFilterOperator.SelectedItem).Operator, this.GetFilterValue()); } else if (tbcCondition.SelectedTab == tbpMultiSelectList) { IList list = multiSelectList.SelectedItems; cond = new GridEXFilterCondition(); GridEXFilterCondition childCondition; cond.AddCondition(new GridEXFilterCondition((GridEXColumn)this.cmbColumn.SelectedItem, ConditionOperator.Equal, list[0])); for (int i = 1; i < list.Count; i++) { childCondition = new GridEXFilterCondition((GridEXColumn)this.cmbColumn.SelectedItem, ConditionOperator.Equal, list[i]); cond.AddCondition(LogicalOperator.Or, childCondition); } } else { return; } if ((this.trvFilterCondition.Nodes.Count > 0) && (this.trvFilterCondition.SelectedNode != null) && (this.trvFilterCondition.SelectedNode.Parent != null)) { GridEXFilterCondition parentCondition, siblingCondition, compositeCondition; siblingCondition = (GridEXFilterCondition)this.trvFilterCondition.SelectedNode.Tag; parentCondition = (GridEXFilterCondition)this.trvFilterCondition.SelectedNode.Parent.Tag; if ((parentCondition.Conditions.Count == 1) || (parentCondition.Conditions[1].LogicalOperator == logicalOperator)) { parentCondition.AddCondition(logicalOperator, cond); } else { LogicalOperator auxLogicalOperator = parentCondition.Conditions[1].LogicalOperator; parentCondition.RemoveCondition(siblingCondition); compositeCondition = new GridEXFilterCondition(); compositeCondition.AddCondition(siblingCondition); compositeCondition.AddCondition(logicalOperator, cond); parentCondition.AddCondition(auxLogicalOperator, compositeCondition); } } else { filterCondition.AddCondition(logicalOperator, cond); } this.LoadConditionTreeView(); }