예제 #1
0
        public UserLadeDetailReport(string FromDate, string FromTime, string ToDate, string ToTime)
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();

            try
            {
                HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory LadeAssignmentFactory = new HPS.BLL.LadeAssignmentBLL.BLLLadeAssignment_TFactory();
                DataTable LaderTypeReportTable = new DataTable();
                LadeAssignmentFactory.SelectLadeUserDetailReport(FromDate, FromTime, ToDate, ToTime, ref LaderTypeReportTable);
                this.DataSource                  = LaderTypeReportTable;
                FromDatetxt.Text                 = FromDate;
                FromTimetxt.Text                 = FromTime;
                ToDatetxt.Text                   = ToDate;
                ToTimetxt.Text                   = ToTime;
                UserNametxt.Text                 = HPS.Common.CurrentUser.user.UserName_nvc;
                Datetxt.Text                     = LadeAssignmentFactory.ServerJalaliDate;
                Timetxt.Text                     = LadeAssignmentFactory.ServerTime;
                UserName_nvctxt.DataField        = "UserName_nvc";
                LadeAssignmentCounttxt.DataField = "LadeAssignmentCount";
                LadBillCounttxt.DataField        = "LadBillCount";
                CanceledLabillCounttxt.DataField = "LadeBillCancelCount";

                Int64?AllLadeAssignmentcount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadeAssignmentCount"]).Sum();
                AllLadeAssignmentCountxt.Text = AllLadeAssignmentcount.HasValue ? AllLadeAssignmentcount.ToString() : "0";

                Int64?AllLadBillcountRecords = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadBillCount"]).Sum();
                AllLadBillCounttxt.Text = AllLadBillcountRecords.HasValue ? AllLadBillcountRecords.ToString() : "0";

                Int64?Allremaindercount = (from row in LaderTypeReportTable.AsEnumerable() select(Int32) row["LadeBillCancelCount"]).Sum();
                AllCanceledLadBillCounttxt.Text = Allremaindercount.HasValue ? Allremaindercount.ToString() : "0";
            }
            catch (Exception ex)
            {
                Hepsa.Core.Common.MessageBox.ErrorMessage(ex.Message);
            }
        }