public ActionResult GetRelationByClienterId()
        {
            BCRelationGetByClienterIdPM model = new BCRelationGetByClienterIdPM();

            TryUpdateModel(model);
            ViewBag.Name  = model.Name;
            ViewBag.Phone = model.Phone;
            return(View(iBusinessClienterRelationProvider.GetByClienterId(model)));
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 根据骑士id查询骑士绑定商家列表   caoheyang 20150608
        /// </summary>
        public PageInfo <BCRelationGetByClienterIdDM> GetByClienterId(BCRelationGetByClienterIdPM model)
        {
            string where = string.Format(" ClienterId={0}", model.ClienterId);
            string columnList = "a.BusinessId,a.ClienterId,b.Name as BusinessName,b.PhoneNo as BusinessPhoneNo,"
                                + " b.Address as BusinessAddress,a.IsBind,a.UpdateBy,a.UpdateTime,c.TrueName as ClienterName";
            string tableList = "dbo.BusinessClienterRelation a ( nolock )  join dbo.business b ( nolock )"
                               + " on a.BusinessId = b.Id join dbo.clienter c ( nolock ) on c.Id = a.ClienterId";

            return(new PageHelper().GetPages <BCRelationGetByClienterIdDM>(SuperMan_Read, model.PageIndex, where, "a.Id desc", columnList,
                                                                           tableList, SystemConst.PageSize, true));
        }
 /// <summary>
 /// 根据骑士id查询骑士绑定商家列表   caoheyang 20150608
 /// </summary>
 public PageInfo <BCRelationGetByClienterIdDM> GetByClienterId(BCRelationGetByClienterIdPM model)
 {
     return(businessClienterRelationDao.GetByClienterId(model));
 }
 public ActionResult PostGetRelationByClienterId(BCRelationGetByClienterIdPM model)
 {
     return(View(iBusinessClienterRelationProvider.GetByClienterId(model)));
 }