Beispiel #1
0
        public InvitationDetail SelectInvitationDetail(int Invpeopleid)
        {
            var sql = "select  b.username as UserName,isnull(sum(c.investment_amount),0.00) as InvestedAmount,(select top 1 invest_time from hx_Bid_records where hx_Bid_records.investor_registerid = a.invpersonid order by invest_time desc) as invest_time, b.registration_time from hx_td_Userinvitation a left join hx_member_table b on a.invpersonid = b.registerid left join hx_Bid_records c on a.invpersonid = c.investor_registerid where a.Invpeopleid = @Invpeopleid group by a.invpersonid,b.username,b.registration_time order by invest_time desc,b.registration_time desc";

            SqlParameter[] parameters =
            {
                new SqlParameter("@Invpeopleid", SqlDbType.Int, 4)
            };
            parameters[0].Value = Invpeopleid;
            var ent = new InvitationDetail()
            {
                InvitationTotalAmount = "0.00", InvitedInvestedPeopleCount = "0", InvitedPeopleCount = "0"
            };
            var     ds = DbHelper.Query(sql, parameters);
            decimal invitationTotalAmount = 0.00M;
            int     invitedPeopleCount = 0, invitedInvestedPeopleCount = 0;

            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                InitInvitationDetailList(ds.Tables[0], ref invitedPeopleCount, ref invitedInvestedPeopleCount, ref invitationTotalAmount);
            }
            ent.InvitationTotalAmount      = invitationTotalAmount.ToString("f2") + "元";
            ent.InvitedPeopleCount         = invitedPeopleCount.ToString() + "人";
            ent.InvitedInvestedPeopleCount = invitedInvestedPeopleCount.ToString() + "人";
            return(ent);
        }
        public async Task <IActionResult> InvitationDetail(int invitationId)
        {
            ProcessSystemInfo();
            Invatation invitation;
            var        user = await _userManager.GetUserAsync(User);

            try
            {
                invitation = _context.Invatations.First(a => a.Id == invitationId);
                var employeeId = _context.EmployeeCvs.First(a => a.Id == invitation.EmployeeCvId).EmployeeId;
                if (user.Id != employeeId)
                {
                    TempData["Error"] = "Please select correct invitation";
                    return(RedirectToAction("MyInvitations"));
                }
            }
            catch (InvalidOperationException)
            {
                TempData["Error"] = "Please select correct invitation";
                return(RedirectToAction("MyInvitations"));
            }
            var jobProfile = _context.EmployerJobProfiles.First(a => a.Id == invitation.EmployerJobProfileId);
            var employer   = _context.Employers.First(a => a.Id == jobProfile.EmployerId);
            var result     = new InvitationDetail
            {
                SentDate           = invitation.SentTime,
                CompanyDescription = employer.BriefDescription,
                JobDescription     = jobProfile.Description,
                Title        = jobProfile.Title,
                InvitationId = invitation.Id
            };

            return(View(result));
        }
Beispiel #3
0
        public BasePage <List <UserInvestedStatistics> > SelectInvitationDetailPage(int Invpeopleid, int pageIndex, int pageSize = 12)
        {
            BasePage <List <UserInvestedStatistics> > result = new BasePage <List <UserInvestedStatistics> >()
            {
                pageCount = 0, recordCount = 0, rows = new List <UserInvestedStatistics>()
            };
            var sql = "select  b.username as UserName,isnull(sum(c.investment_amount),0.00) as InvestedAmount,(select top 1 invest_time from hx_Bid_records where hx_Bid_records.investor_registerid = a.invpersonid order by invest_time desc) as invest_time, b.registration_time from hx_td_Userinvitation a left join hx_member_table b on a.invpersonid = b.registerid left join hx_Bid_records c on a.invpersonid = c.investor_registerid where a.Invpeopleid = @Invpeopleid group by a.invpersonid,b.username,b.registration_time order by invest_time desc,b.registration_time desc";

            SqlParameter[] parameters =
            {
                new SqlParameter("@Invpeopleid", SqlDbType.Int, 4)
            };
            parameters[0].Value = Invpeopleid;
            var ent = new InvitationDetail()
            {
                InvitationTotalAmount = "0.00", InvitedInvestedPeopleCount = "0", InvitedPeopleCount = "0"
            };
            var     ds = DbHelper.Query(sql, parameters);
            decimal invitationTotalAmount = 0.00M;
            int     invitedPeopleCount = 0, invitedInvestedPeopleCount = 0;

            if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
            {
                var items = InitInvitationDetailList(ds.Tables[0], ref invitedPeopleCount, ref invitedInvestedPeopleCount, ref invitationTotalAmount);
                if (items.Count > 0)
                {
                    result.pageCount = items.Count / pageSize;
                    if (items.Count % pageSize > 0)
                    {
                        result.pageCount += 1;
                    }
                    result.recordCount = items.Count;
                    if (pageIndex < 1)
                    {
                        pageIndex = 1;
                    }
                    result.rows = items.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
                }
            }
            return(result);
        }