/// <summary> /// 所选日期判断是否能预约 /// </summary> /// <param name="ydjh"></param> /// <param name="date"></param> /// <returns></returns> public bool GetScheduleResult(string yybh, string qybh, string ydjh, string rq, string sj) { DateTime rq_date = Convert.ToDateTime(rq); var kssj = sj.Split('-')[0]; DateTime sj_date = Convert.ToDateTime(rq + " " + kssj); var ygxx = new QyygjbxxService().GetModel(yybh, ydjh); var jbsz = new PqJbszService().GetModel(yybh); var qypq = new PqQyszService().GetModelByDate(yybh, qybh, rq_date); var tjrq = new PqTjrqService().GetModel(yybh, qybh, rq_date); var tjsj = new PqTjsjService().GetListByRq(qybh, yybh, rq_date).FirstOrDefault(x => x.kssj <= sj_date && sj_date < x.jssj); var yyList = new DdJbxxService().GetQyYyListByDate(yybh, qybh, rq_date);//每天预约人数 if (jbsz == null || jbsz.tjyl <= yyList.Count) { return(false); } var weekDay = Convert.ToInt32(rq_date.DayOfWeek).ToString(); if ((jbsz.xxr.Contains(weekDay) || jbsz.ztyy.Contains(rq)) && !jbsz.tsky.Contains(rq)) { return(false); } if (tjrq == null || tjrq.flag > 0 || tjrq.tjrs <= yyList.Count) { return(false); } if (tjsj == null) { return(false); } var sj_yyList = yyList.Where(x => x.yykssj <= sj_date && sj_date < x.yyjssj); if (tjsj.tjrs <= sj_yyList.Count()) { return(false); } if (qypq != null) { var pjtcList = new PqQyszService().GetPjtc(qypq.pqbh);//瓶颈套餐 var pjtcModel = pjtcList.FirstOrDefault(x => x.tcbh == ygxx.tcbh); if (pjtcModel != null) { var pjtcs = pjtcList.Where(x => x.fzbh == pjtcModel.pqbh).Select(a => a.tcbh).ToArray();; var tcyyrs = yyList.Where(a => pjtcs.Contains(a.tcid)).Count();//套餐体检人数 if (tcyyrs >= pjtcModel.tjrs) { return(false); } } } return(true); }
/// <summary> /// 预约今日团检总进度 /// </summary> /// <param name="yybh"></param> /// <returns>百分比,80/100</returns> public List <string> GetHometjzryyjd(string yybh) { List <string> li = new List <string>(); string sql = "select count(1) from dd_jbxx_new where yybh='" + yybh + "' and ddly=1 and ddzt in (2,3,6,7,9) and yykssj>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' and yykssj<'" + DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + "'"; int daystotal = 0; using (IDbConnection conn = new DapperConnection().DbConnection) { daystotal = conn.Query <int>(sql, null).FirstOrDefault(); } int tjyl = new PqJbszService().GetModel(yybh).tjyl; li.Add((daystotal * 1.0 / tjyl * 100).ToString("0.##") + "%"); li.Add(daystotal.ToString() + "/" + tjyl.ToString()); return(li); }
/// <summary> /// 今日预约总进度 /// </summary> /// <param name="yybh"></param> /// <returns></returns> public string GetHomezryyjd(string yybh) { string sql = "select count(1) from dd_jbxx_new where yybh='" + yybh + "' and ddly=0 and ddzt in (2,3,6,7,9) and yykssj>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' and yykssj<'" + DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + "'"; int daystotal = 0; using (IDbConnection conn = new DapperConnection().DbConnection) { daystotal = conn.Query <int>(sql, null).FirstOrDefault(); } int qdl = 0; var pqModel = new PqJbszService().GetModel(yybh); if (pqModel != null) { qdl = pqModel.zdjd; } return(qdl.Equals(0)?"100%":(daystotal * 1.0 / qdl * 100).ToString("0.##") + "%"); }