private void LoadgrdDSLoaiTK() { Mouse.OverrideCursor = Cursors.Wait; try { DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@INP_USER", "string", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@MA_DVI_QLY", "string", ClientInformation.MaDonVi); LDatatable.AddParameter(ref dt, "@StartRow", "INT", StartRow.ToString()); LDatatable.AddParameter(ref dt, "@EndRow", "INT", EndRow.ToString()); Presentation.Process.KhaiThacDuLieuProcess process = new Presentation.Process.KhaiThacDuLieuProcess(); DataSet ds = process.GetDanhSachLoaiTK(dt); if (ds != null && ds.Tables.Count > 0) { grdDSLoaiTK.ItemsSource = ds.Tables[0].DefaultView; } else { grdDSLoaiTK.ItemsSource = null; } } catch (Exception ex) { CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } Mouse.OverrideCursor = Cursors.Arrow; }
private void LoadCheckBox(string maLoaiTK, string maTK) { Mouse.OverrideCursor = Cursors.Wait; try { DataTable dt = null; LDatatable.MakeParameterTable(ref dt); LDatatable.AddParameter(ref dt, "@INP_USER", "string", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@MA_DVI_QLY", "string", ClientInformation.MaDonVi); LDatatable.AddParameter(ref dt, "@StartRow", "INT", StartRow.ToString()); LDatatable.AddParameter(ref dt, "@EndRow", "INT", EndRow.ToString()); LDatatable.AddParameter(ref dt, "@INP_USER", "string", ClientInformation.TenDangNhap); LDatatable.AddParameter(ref dt, "@MA_LOAITK", "string", maLoaiTK); LDatatable.AddParameter(ref dt, "@MATK", "string", maTK); Presentation.Process.KhaiThacDuLieuProcess process = new Presentation.Process.KhaiThacDuLieuProcess(); DataSet ds = process.GetDanhSachMapping(dt); grdDSDKien.UnselectAll(); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { List <DataRowView> lstDr = new List <DataRowView>(); for (int i = 0; i < grdDSDKien.Items.Count; i++) { DataRowView dr = (DataRowView)grdDSDKien.Items[i]; for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { if (dr["MA_DKIEN"].ToString().Equals(ds.Tables[0].Rows[j]["MA_MAPPING"])) { lstDr.Add(dr); } } } grdDSDKien.Select(lstDr); } } catch (Exception ex) { CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } Mouse.OverrideCursor = Cursors.Arrow; }
private void LoadgrdDSDKien(string dkien) { Mouse.OverrideCursor = Cursors.Wait; try { Presentation.Process.KhaiThacDuLieuProcess process = new Presentation.Process.KhaiThacDuLieuProcess(); DataSet ds = process.GetDanhSachDKien(dkien); if (ds != null && ds.Tables.Count > 0) { grdDSDKien.ItemsSource = ds.Tables[0].DefaultView; } else { grdDSDKien.ItemsSource = null; } } catch (Exception ex) { CommonFunction.ThongBaoLoi(ex); LLogging.WriteLog(ex.TargetSite.Name, LLogging.LogType.ERR, ex); } Mouse.OverrideCursor = Cursors.Arrow; }