public string Get_OuSchDtl(string json) { Back <Schedudatelist> back = new Back <Schedudatelist>(); string msg = ""; string xml = ""; try { int doctorid = Convert.ToInt32(JsonHelper.GetVluesParentstr(json, "doctorid")); string flag = JsonHelper.GetVluesParentstr(json, "flag"); DateTime today, subst, subend, endtoday, nextst, nextend; DataTable datalist = new DataTable(); if (flag.Equals("1")) { today = DateTime.Now; subst = CommUtil.GetTimeStartByType("Week", today); subend = CommUtil.GetTimeEndByType("Week", today); datalist = bll.QuerySchBydoct(doctorid, today, subend); } else //2 { today = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); endtoday = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); var nextday = today.AddDays(Convert.ToInt32(1 - Convert.ToInt32(today.DayOfWeek)) + 7); nextst = CommUtil.GetTimeStartByType("Week", nextday); var nextendday = endtoday.AddDays(Convert.ToInt32(1 - Convert.ToInt32(endtoday.DayOfWeek)) + 7); nextend = CommUtil.GetTimeEndByType("Week", nextendday); datalist = bll.QuerySchBydoct(doctorid, nextst, nextend); } List <Schedudatelist> dates = new List <Schedudatelist>(); if (datalist == null || datalist.Rows.Count == 0) { //提示无挂号医生 back.errcode = 0; back.errmsg = "暂无可挂号医生"; back.data = new List <Schedudatelist>(); } else { foreach (DataRow row in datalist.Rows) { Schedudatelist sch = new Schedudatelist(); sch.scheduledate = Convert.ToDateTime(row["scheduledate"]).ToString("MM-dd"); sch.schedule = Convert.ToDateTime(row["scheduledate"]).ToString("yyyy-MM-dd"); sch.week = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(Convert.ToDateTime(row["scheduledate"]).DayOfWeek); DataTable yhs = bll.QueryYH(doctorid, Convert.ToDateTime(row["scheduledate"]).ToString("yyyy-MM-dd")); List <ScheduShow> yhslist = new List <ScheduShow>(); foreach (DataRow rw in yhs.Rows) { ScheduShow sche = new ScheduShow(); sche.name = rw["name"].ToString(); sche.spanid = Convert.ToInt32(rw["timespanid"]); sche.yh = Convert.ToInt32(rw["booklimitnum"]) - Convert.ToInt32(rw["ygh"]); yhslist.Add(sche); } sch.list = yhslist; dates.Add(sch); } back.errcode = 0; back.errmsg = ""; xml = JsonHelper.getJsonByObject((Object)dates); back.data = dates; } } catch (Exception ex) { back.errcode = -1; back.errmsg = ex.Message; back.data = new List <Schedudatelist>(); } msg = JsonHelper.getJsonByObject((Object)back); return(msg); }
public string Get_NextDoctByDept(string json) { Back <Oudayschedule> back = new Back <Oudayschedule>(); string msg = ""; string xml = ""; try { int deptid = Convert.ToInt32(JsonHelper.GetVluesParentstr(json, "deptid")); DateTime today, endtoday, nextst, nextend; today = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 00:00:00")); endtoday = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd 23:59:59")); var nextday = today.AddDays(Convert.ToInt32(1 - Convert.ToInt32(today.DayOfWeek)) + 7); nextst = CommUtil.GetTimeStartByType("Week", nextday); var nextendday = endtoday.AddDays(Convert.ToInt32(1 - Convert.ToInt32(endtoday.DayOfWeek)) + 7); nextend = CommUtil.GetTimeEndByType("Week", nextendday); DataTable doct = bll.QueryDoctByDept(deptid, nextst, nextend); List <Oudayschedule> list = new List <Oudayschedule>(); if (doct == null || doct.Rows.Count == 0) { //提示无挂号医生 back.errcode = 0; back.errmsg = "暂无可挂号医生"; back.data = new List <Oudayschedule>(); } else { int mainNum = doct.Rows.Count; foreach (DataRow row in doct.Rows) { Oudayschedule days = new Oudayschedule(); BsUser user = new BsUser(); user.doctorid = Convert.ToInt32(row["id"]); user.name = row["docname"].ToString(); user.deptid = Convert.ToInt32(row["deptid"]); user.deptname = row["deptname"].ToString(); user.docgra = row["docgra"].ToString(); user.price = Convert.ToDouble(row["price"]); user.resume = row["resume"].ToString(); user.picture = row["picture"].ToString(); days.user = user; DataTable datalist = bll.QuerySchBydoct(user.doctorid, nextst, nextend); List <Schdatecs> dates = new List <Schdatecs>(); foreach (DataRow rw in datalist.Rows) { Schdatecs sch = new Schdatecs(); //sch.id = Convert.ToInt32(rw["id"]); sch.scheduledate = Convert.ToDateTime(rw["scheduledate"]).ToString("MM-dd"); sch.week = System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(Convert.ToDateTime(rw["scheduledate"]).DayOfWeek); dates.Add(sch); } days.list = dates; list.Add(days); } back.errcode = 0; back.errmsg = ""; xml = JsonHelper.getJsonByObject((Object)list); back.data = list; } } catch (Exception ex) { back.errcode = -1; back.errmsg = ex.Message; back.data = new List <Oudayschedule>(); } msg = JsonHelper.getJsonByObject((Object)back); return(msg); }