PageRenderTime 302ms CodeModel.GetById 28ms RepoModel.GetById 0ms app.codeStats 0ms

/EESoft/RetirementCenter/RetirementCenter/Forms/Qry/Qry00Frm.cs

https://github.com/EgyFalseX/Winform
C# | 91 lines | 69 code | 13 blank | 9 comment | 6 complexity | 34f7514de423aa17bb17837c8842779e MD5 | raw file
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading;
  9. using System.Windows.Forms;
  10. using DevExpress.Data.Linq;
  11. using DevExpress.XtraEditors;
  12. using DevExpress.XtraGrid.Views.Grid;
  13. using DevExpress.XtraSplashScreen;
  14. using System.Linq;
  15. using System.Runtime.Serialization;
  16. namespace RetirementCenter
  17. {
  18. public partial class Qry00Frm : DevExpress.XtraEditors.XtraForm
  19. {
  20. DataSources.Linq.dsTeachersUnionViewsDataContext dsLinq = new DataSources.Linq.dsTeachersUnionViewsDataContext();
  21. #region - Functions -
  22. public Qry00Frm()
  23. {
  24. InitializeComponent();
  25. }
  26. #endregion
  27. #region - Event Handlers -
  28. private void QryTblAhteatyFrm_Load(object sender, EventArgs e)
  29. {
  30. //if (Program.UserInfo.IsAdmin)
  31. // LSMS.QueryableSource = dsLinq.vTBLMashats;
  32. //else
  33. // LSMS.QueryableSource = from q in dsLinq.vTBLMashats where Program.UserInfo.Syndicates.Contains((int)q.SyndicateId) select q;
  34. LSMSTBLMashats.QueryableSource = dsLinq.TBLMashats;
  35. //gridViewTBLMashats.BestFitColumns();
  36. }
  37. private void btnPrintExport_Click(object sender, EventArgs e)
  38. {
  39. // Check whether the GridControl can be previewed.
  40. if (!gridControlData.IsPrintingAvailable)
  41. {
  42. msgDlg.Show("The 'DevExpress.XtraPrinting' library is not found");
  43. return;
  44. }
  45. // Open the Preview window.
  46. gridControlData.ShowRibbonPrintPreview();
  47. }
  48. private void gridViewTBLMashats_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
  49. {
  50. return;
  51. if (e.FocusedRowHandle < 0)
  52. return;
  53. GridView gv = (GridView)sender;
  54. DataSources.Linq.TBLMashat member = (DataSources.Linq.TBLMashat)gv.GetRow(e.FocusedRowHandle);
  55. LinqServerModeSource lsms = new LinqServerModeSource();
  56. lsms.ElementType = typeof(DataSources.Linq.TBLWarasa);
  57. lsms.KeyExpression = "PersonId";
  58. lsms.QueryableSource = from q in dsLinq.TBLWarasas where q.MMashatId == member.MMashatId select q;
  59. //gv.datasou
  60. }
  61. #endregion
  62. private void gridViewTBLMashats_MasterRowGetChildList(object sender, MasterRowGetChildListEventArgs e)
  63. {
  64. GridView gv = (GridView)sender;
  65. GridView gvdetail = (GridView)gv.GetDetailView(e.RowHandle, e.RelationIndex);
  66. DataSources.Linq.TBLMashat member = (DataSources.Linq.TBLMashat)gv.GetRow(e.RowHandle);
  67. LinqServerModeSource lsms = new LinqServerModeSource();
  68. lsms.ElementType = typeof(DataSources.Linq.TBLWarasa);
  69. lsms.KeyExpression = "PersonId";
  70. lsms.QueryableSource = from q in dsLinq.TBLWarasas where q.MMashatId == member.MMashatId select q;
  71. List<DataSources.Linq.TBLWarasa> query = (from q in dsLinq.TBLWarasas where q.MMashatId == member.MMashatId select q).ToList();
  72. //e.ChildList = dsLinq.TBLWarasas.ToList().Where(x => x.MMashatId == member.MMashatId).ToList();
  73. List<DataSources.Linq.TBLWarasa> xx = dsLinq.TBLWarasas.ToList().Where(x => x.MMashatId == member.MMashatId).ToList();
  74. e.ChildList = xx;
  75. DataTable dtl;
  76. }
  77. }
  78. }