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 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})"; }
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})"; }