private void btnPrint_Click(object sender, EventArgs e) { List <SZAservice> dt1 = dt; if (ListSelected.Count > 0) { dt1 = dt1.Where(d => ListSelected.Contains(d.ZID)).ToList(); } //else //{ // if (MessageBox.Show("در صورت انتخاب نكردن موردي همه موارد در گزارش ذكر ميشود.\nآيا مايل به ادامه هستيد؟", // "سوال", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) // { // goto END1; // } //} var DateNow = DateTime.Now; string today = pc.GetYear(DateNow).ToString("0000") + "/" + pc.GetMonth(DateNow).ToString("00") + "/" + pc.GetDayOfMonth(DateNow).ToString("00"); StiReport report = new StiReport(); report.Load(@"C:\Users\North-PC\Desktop\Report Sarfasl (Stimulsoft)\Atiran\ReportZirSarfasl1.mrt"); //report.Dictionary.Databases.Add(new StiSqlDatabase("Connection", "Integrated Security=True;Data Source=.;Initial Catalog=ZAnsari;Password=;User ID="));//Connections.ConnectionInfo.BuildStimulConnectionString())); //report.Compile(); report.Dictionary.Variables["User"].Value = "alirezasadegghi"; report.Dictionary.Variables["today"].Value = today; report.Dictionary.Variables["NameSarfasl"].Value = _nameSarfasl; report.Dictionary.Variables["FromDate"].Value = textDate1.FromDate; report.Dictionary.Variables["ToDate"].Value = textDate1.ToDate; report.RegBusinessObject("SZA", dt1); report.Render(); report.Show(); //END1:; }
private void chbAll_CheckedChanged(object sender, EventArgs e) { List <int> list1 = ((List <SZAservice>)dgvZirSarfal.DataSource).Select(a => a.ZID).ToList(); ListSelected.RemoveAll(x => list1.Contains(x)); if (chbAll.Checked) { ListSelected.AddRange(list1); foreach (DataGridViewRow row in dgvZirSarfal.Rows) { row.Cells["select"].Value = true; row.DefaultCellStyle.BackColor = Color.PaleTurquoise; } } else { foreach (DataGridViewRow row in dgvZirSarfal.Rows) { row.Cells["select"].Value = false; row.DefaultCellStyle.BackColor = Color.White; } } SetTextLabelFooter(); //lblFooterNumber.Text = $"تعداد: {dgvZirSarfal.RowCount}\nتعداد انتخابي: {ListSelected.Count}"; }
private void GetData() { lblLoding.Visible = true; ListSelected.Clear(); var listsarfasl = new List <int>(); listsarfasl.Add(_sarfaslID); Thread tGetdata = new Thread(() => { dt = conection.GetSZAServices(textDate1.FromDate, textDate1.ToDate, _listZirSar, listsarfasl, new List <int>()); }); tGetdata.Start(); tGetdata.Join(); //dt = conection.GetZirSarfaslServices1(listsarfasl, _listZirSar, textDate1.FromDate, textDate1.ToDate); int row = 1; dgvZirSarfal.DataSource = dt0 = dt.GroupBy(g => new { g.ZID, g.ZSarfaslID, g.ZName, g.Zbed, g.Zbes, g.ZMan, g.Zbed_bes, g.ZMan_Befor, g.Zbed_bes_Befor, g.ZMan_All, g.Zbed_bes_All, g.Zhas_dar, g.ZActive }).Select(g => new SZAservice() { Zrow = row++, ZID = g.Key.ZID, ZSarfaslID = g.Key.ZSarfaslID, ZName = g.Key.ZName, Zbed = g.Key.Zbed, Zbes = g.Key.Zbes, ZMan = g.Key.ZMan, Zbed_bes = g.Key.Zbed_bes, ZMan_Befor = g.Key.ZMan_Befor, Zbed_bes_Befor = g.Key.Zbed_bes_Befor, ZMan_All = g.Key.ZMan_All, Zbed_bes_All = g.Key.Zbed_bes_All, Zhas_dar = g.Key.Zhas_dar, ZActive = g.Key.ZActive }).ToList(); chbAll.Checked = false; SetTextLabelFooter(dt.Count, dt.Sum(d => d.Zbed), dt.Sum(d => d.Zbes), dt.Sum(d => d.ZMan), dt.Sum(d => d.ZMan_All)); SetGrid(); txtFilter.Focus(); lblLoding.Visible = false; }
private void AddOrRemoveInListAndTextSelected(int rowData, bool isAdded) { ListSelected.RemoveAll(i => i == (int)dgvZirSarfal.Rows[rowData].Cells["ZID"].Value); if (isAdded) { ListSelected.Add((int)dgvZirSarfal.Rows[rowData].Cells["ZID"].Value); } SetTextLabelFooter(); //lblFooterNumber.Text = $"تعداد: {dgvZirSarfal.RowCount}\nتعداد انتخابي: {ListSelected.Count}"; }
private void SetTextLabelFooter() { decimal bedSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbed); decimal besSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbes); decimal sumSelect = bedSelect - besSelect; string status0 = sumSelect > 0 ? "بد" : sumSelect == 0 ? "--" : "بس"; lblFooterNumber.Text = $"تعداد: {dgvZirSarfal.RowCount}\nتعداد انتخابي: {ListSelected.Count}"; lblBedSelect.Text = (bedSelect).ToMan(); lblBesSelect.Text = (besSelect).ToMan(); lblManSelect.Text = $"{Math.Abs(sumSelect).ToMan()} ({status0})"; }
public TTTreeSplitDlg(IBaseWindow baseWin) { InitializeComponent(); btnClose.Image = UIHelper.LoadResourceImage("Resources.btn_cancel.gif"); ListSelected.AddColumn("-", 300); ListSkipped.AddColumn("-", 300); fController = new TreeSplitController(this); fController.Init(baseWin); SetLocale(); }
public void SetLocale() { Title = LangMan.LS(LSID.LSID_ToolOp_3); pageTreeSplit.Text = LangMan.LS(LSID.LSID_ToolOp_3); btnClose.Text = LangMan.LS(LSID.LSID_DlgClose); btnSelectAll.Text = LangMan.LS(LSID.LSID_SelAll); btnSelectFamily.Text = LangMan.LS(LSID.LSID_SelFamily); btnSelectAncestors.Text = LangMan.LS(LSID.LSID_SelAncestors); btnSelectDescendants.Text = LangMan.LS(LSID.LSID_SelDescendants); btnDelete.Text = LangMan.LS(LSID.LSID_DoDelete); btnSave.Text = LangMan.LS(LSID.LSID_MIFileSaveAs); ListSelected.SetColumnCaption(0, LangMan.LS(LSID.LSID_Person)); ListSkipped.SetColumnCaption(0, LangMan.LS(LSID.LSID_Person)); }
private void dgvZirSarfal_DataBindingComplete(object sender, DataGridViewBindingCompleteEventArgs e) { foreach (DataGridViewRow row in dgvZirSarfal.Rows) { row.Cells["ZMan"].Value = Math.Abs((decimal)row.Cells["ZMan"].Value).ToString(); row.Cells["ZMan_Befor"].Value = Math.Abs((decimal)row.Cells["ZMan_Befor"].Value).ToString(); row.Cells["ZMan_All"].Value = Math.Abs((decimal)row.Cells["ZMan_All"].Value).ToString(); if (ListSelected.Any(i => i == (int)row.Cells["ZID"].Value)) { row.Cells["select"].Value = true; row.DefaultCellStyle.BackColor = Color.PaleTurquoise; } else { row.Cells["select"].Value = false; row.DefaultCellStyle.BackColor = Color.White; } } }
private void SetTextLabelFooter(int number, decimal bed, decimal bes, decimal sum, decimal sumAll) { decimal bedSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbed); decimal besSelect = dt.Where(d => ListSelected.Contains(d.ZID)).Sum(d => d.Zbes); decimal sumSelect = bedSelect - besSelect; string status0 = sumSelect > 0 ? "بد" : sumSelect == 0 ? "--" : "بس"; string status1 = sum > 0 ? "بد" : sum == 0 ? "--" : "بس"; string status2 = sumAll > 0 ? "بد" : sumAll == 0 ? "--" : "بس"; lblFooterNumber.Text = $"تعداد: {number}\nتعداد انتخابي: {ListSelected.Count}"; lblBedSelect.Text = (bedSelect).ToMan(); lblBesSelect.Text = (besSelect).ToMan(); lblManSelect.Text = $"{Math.Abs(sumSelect).ToMan()} ({status0})"; lblBedDate.Text = (bed).ToMan(); lblBesDate.Text = (bes).ToMan(); lblManDate.Text = $"{Math.Abs(sum).ToMan()} ({status1})"; lblMan.Text = $"{ Math.Abs(sumAll).ToMan()} ({status2})"; }
public void UpdateUI() { if (EndTime < 0 || StartTime < 0) { return; } ListSelected.ToList().ForEach(o => o.IsSelect = false); if (StartTime < EndTime) { for (var i = StartTime; i <= EndTime; i++) { var el = List.FirstOrDefault(o => o.ID == i); if (el != null) { el.IsSelect = true; } } } if (StartTime <= EndTime) { return; } for (var i = 0; i <= StartTime; i++) { var el = List.FirstOrDefault(o => o.ID == i); if (el != null) { el.IsSelect = true; } } for (var i = EndTime; i <= 23; i++) { var el = List.FirstOrDefault(o => o.ID == i); if (el != null) { el.IsSelect = true; } } }
private void UpdateSplitLists() { ListSelected.BeginUpdate(); ListSelected.Items.Clear(); ListSkipped.BeginUpdate(); ListSkipped.Items.Clear(); try { int cnt = 0; int num = fTree.RecordsCount; for (int i = 0; i < num; i++) { GEDCOMRecord rec = fTree[i]; if (rec is GEDCOMIndividualRecord) { cnt++; GEDCOMIndividualRecord iRec = rec as GEDCOMIndividualRecord; string st = iRec.XRef + " / " + GKUtils.GetNameString(iRec, true, false); if (fSplitList.IndexOf(iRec) < 0) { ListSkipped.Items.Add(st); } else { ListSelected.Items.Add(st); } } } Text = fSplitList.Count.ToString() + @" / " + cnt.ToString(); } finally { ListSelected.EndUpdate(); ListSkipped.EndUpdate(); } }
private void Update() { StartTime = ListSelected.Any() ? ListSelected.Min(m => m.ID) : -1; EndTime = ListSelected.Any() ? ListSelected.Max(m => m.ID) : -1; }
public void SetSelected(int start, int end) { ListSelected.ToList().ForEach(o => o.IsSelect = false); List.Where(o => o.ID >= start && o.ID <= end).ToList().ForEach(e => e.IsSelect = true); Update(); }