/// <summary> /// 验证该订单是否已经存在 /// </summary> /// <param name="errMsg">错误信息</param> /// <returns>结果</returns> private bool IsOrderExistValidate(out string errMsg) { nobModel = EBS.Interface.Data.DBOper.N_Order_Base.Get("IsDel=0 and OrderId=@OrderId and SoufunId=@SoufunId", "CreateTime desc", new object[] { OrderId, OwnerSoufunId }); if (nobModel == null || nobModel.ID <= 0) { errMsg = "无效的订单!"; return(false); } errMsg = ""; return(true); }
/// <summary> /// 抢客户是否成功添加日志 /// </summary> /// <param name="orderbase"></param> /// <param name="qiangState">0失败,1成功</param> /// <param name="qiangRemark">错误信息</param> /// <returns></returns> protected static bool InsertGuanjiaUserMap(EBS.Interface.Model.N_Order_Base orderbase, EBS.Interface.Model.Admin_UserInfo aui, int qiangState, string qiangRemark) { int gumID = 0; EBS.Interface.Model.GuanjiaUserMap gum = new EBS.Interface.Model.GuanjiaUserMap(); gum.OnwerSoufunId = orderbase.SoufunId; gum.OnwerSoufunName = orderbase.OrderId; gum.OperType = 0;//管家 gum.OperID = aui.SoufunId; gum.OperName = string.IsNullOrEmpty(aui.TrueName) ? aui.SoufunName : aui.TrueName; gum.OperCity = orderbase.CityName; gum.CreateTime = DateTime.Now; gum.QiangState = qiangState; gum.QiangRemark = qiangRemark; return(EBS.Interface.Data.DBOper.GuanjiaUserMap.Add(gum, out gumID)); }
/// <summary> /// 是否有名额验证 /// </summary> /// <param name="errMsg">错误信息</param> /// <returns>结果</returns> private bool HasQuotaValidate(out string errMsg) { //今天抢过的单数 long orderbaseCount = new EBS.Interface.Model.N_Order_Base().INNER_JOIN(EBS.Interface.Model.N_Order_Service.TableInfo, "ser", "SRCTAB.OrderId=ser.OrderId").Where("SRCTAB.IsDel=0 AND ser.IsDel=0 AND SRCTAB.GrabOrderDate>convert(varchar(10),getdate(),120) AND SRCTAB.UserRank<@UserRank AND ser.SoufunId=@SoufunId and SRCTAB.orderid not in (select orderid from Order_Extend where HomeClubApplyGjName=@GjName) and SRCTAB.SourceId not in (1,3,4)", new object[] { (int)EBS.BLL.EnumBLL.UserRank.E, auiModel.SoufunId, auiModel.TrueName }).Count(); if (orderbaseCount >= DayOrderCount) { errMsg = "对不起,您今天已经超过了每日最大抢单数:" + DayOrderCount + ",明天再来吧"; return(false); } //该管家意向客户数量 long userCount = new EBS.Interface.Model.N_Order_Base().INNER_JOIN(EBS.Interface.Model.N_Order_Service.TableInfo, "ser", "SRCTAB.OrderId=ser.OrderId").Where("SRCTAB.IsDel=0 AND ser.IsDel=0 AND SRCTAB.GrabOrderDate<='1900-01-01' AND SRCTAB.UserRank<@UserRank AND ser.SoufunId=@SoufunId", new object[] { (int)EBS.BLL.EnumBLL.UserRank.E, auiModel.SoufunId }).Count(); if (userCount >= DayUserCount) { errMsg = "抢客失败,意向客户名单已满"; return(false); } errMsg = ""; return(true); }