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);
}