/// <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.##") + "%");
}
