예제 #1
0
        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:;
        }
예제 #2
0
        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})";
        }
예제 #3
0
        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})";
        }