public void GetList(int UserID, int StarPageIndex, int EndPageIndex, HttpContext context)
{
StringBuilder sb = new StringBuilder();
string jsonData = string.Empty;
try
{
PageInfo page = new PageInfo();
DataSet SourceTemps = new DataSet();
SourceTemps = GetYTTemp(UserID, StarPageIndex, EndPageIndex);
DataTable SourceTemp = new DataTable();
if (SourceTemps != null && SourceTemps.Tables.Count > 0)
{
page.recordsTotal = Convert.ToInt32(SourceTemps.Tables[0].Rows[0][0]);
SourceTemp = SourceTemps.Tables[1];
Y_UserYuYueEntity model = new Y_UserYuYueEntity();
int TotoleCount = Convert.ToInt32(SourceTemps.Tables[0].Rows[0][0]);
if (SourceTemp != null && SourceTemp.Rows.Count > 0)
{
List <GetList> list = new List <GetList>();
foreach (DataRow DTR in SourceTemp.Rows)
{
Y_UserYuYueEntity ds = MgrServices.ReservationService.GetEntityBYID(Convert.ToInt32(DTR["YT_ID"]));
int aa = Convert.ToInt32(DTR["YT_ID"]);
DateTime begin = new DateTime();;//我的预约时间表里面的预约日期
DateTime Begindata = Convert.ToDateTime(DTR["YT_BDate"].ToString());
DateTime Enddata = Convert.ToDateTime(DTR["YT_EDate"].ToString());
TimeSpan ts = Enddata - Begindata;
DateTime test = new DateTime();
string YTTime = DTR["YT_BTime"].ToString() + "-" + DTR["YT_ETime"].ToString();; //预约时间表的日期
string YUTime = ""; //我的预约表的日期
if (ds != null)
{
YUTime = ds._yu_time;
begin = Convert.ToDateTime(ds._yu_data);
}
GetList models = new GetList();
models.Num = TotoleCount;
models.id = DTR["YT_ID"].ToString(); //用户ID
models.Name = DTR["U_LoginName"].ToString(); //登陆名称
for (int i = 0; i < ts.Days + 1; i++)
{
test = Begindata.AddDays(i);
if (test == DateTime.Now)
{
models.Week1 = "1";
if (begin == DateTime.Now)
{
if (YTTime == YUTime)
{
models.Week1 = "r1";//已经预约
}
else
{
models.Week1 = "r0";//没有预约
}
}
}
else if (test == Convert.ToDateTime(DateTime.Now.AddDays(1).ToShortDateString().ToString()))
{
models.Week2 = "2";
if (begin == Convert.ToDateTime(DateTime.Now.AddDays(1).ToShortDateString().ToString()))
{
if (YTTime == YUTime)
{
models.Week2 = "r1";//已经预约
}
else
{
models.Week2 = "r0";//没有预约
}
}
}
else if (test == Convert.ToDateTime(DateTime.Now.AddDays(2).ToShortDateString().ToString()))
{
models.Week3 = "3";
if (begin == Convert.ToDateTime(DateTime.Now.AddDays(2).ToShortDateString().ToString()))
{
if (YTTime == YUTime)
{
models.Week3 = "r1";//已经预约
}
else
{
models.Week3 = "r0";//没有预约
}
}
}
else if (test == Convert.ToDateTime(DateTime.Now.AddDays(3).ToShortDateString().ToString()))
{
models.Week4 = "4";
if (begin == Convert.ToDateTime(DateTime.Now.AddDays(3).ToShortDateString().ToString()))
{
if (YTTime == YUTime)
{
models.Week4 = "r1";//已经预约
}
else
{
models.Week4 = "r0";//没有预约
}
}
}
else if (test == Convert.ToDateTime(DateTime.Now.AddDays(4).ToShortDateString().ToString()))
{
models.Week5 = "5";
if (begin == Convert.ToDateTime(DateTime.Now.AddDays(4).ToShortDateString().ToString()))
{
if (YTTime == YUTime)
{
models.Week5 = "r1";//已经预约
}
else
{
models.Week5 = "r0";//没有预约
}
}
}
else if (test == Convert.ToDateTime(DateTime.Now.AddDays(5).ToShortDateString().ToString()))
{
models.Week6 = "6";
if (begin == Convert.ToDateTime(DateTime.Now.AddDays(5).ToShortDateString().ToString()))
{
if (YTTime == YUTime)
{
models.Week6 = "r1";//已经预约
}
else
{
models.Week6 = "r0";//没有预约
}
}
}
else if (test == Convert.ToDateTime(DateTime.Now.AddDays(6).ToShortDateString().ToString()))
{
models.Week7 = "7";
if (begin == Convert.ToDateTime(DateTime.Now.AddDays(6).ToShortDateString().ToString()))
{
if (YTTime == YUTime)
{
models.Week7 = "r1";//已经预约
}
else
{
models.Week7 = "r0";//没有预约
}
}
}
else
{
models.Week1 = "r0";//0是没有预约，1是已经预约
}
}
list.Add(models);
}
string json = JsonConvert.SerializeObject(list);
context.Response.Write(json);
}
}
}
catch
{ }
}
//废弃预约管理列表
private void InitGaugePages(int UserID, int StarPageIndex, int EndPageIndex, HttpContext context)
{
try
{
PageInfo page = new PageInfo();
DataSet SourceTemps = new DataSet();
SourceTemps = GetYTTemp(UserID, StarPageIndex, EndPageIndex);
DataTable SourceTemp = new DataTable();
if (SourceTemps != null && SourceTemps.Tables.Count > 0)
{
page.recordsTotal = Convert.ToInt32(SourceTemps.Tables[0].Rows[0][0]);
SourceTemp = SourceTemps.Tables[1];
Y_UserYuYueEntity model = new Y_UserYuYueEntity();
if (SourceTemp != null && SourceTemp.Rows.Count > 0)
{
foreach (DataRow DTR in SourceTemp.Rows)
{
Y_UserYuYueEntity ds = MgrServices.ReservationService.GetEntityBYID(Convert.ToInt32(DTR["YT_ID"]));
int aa = Convert.ToInt32(DTR["YT_ID"]);
DateTime begin = new DateTime();;//我的预约时间表里面的预约日期
string Begindata = DTR["YT_BDate"].ToString();
string Enddata = DTR["YT_EDate"].ToString();
//TimeSpan ts = Enddata - Begindata;
DateTime test = new DateTime();
string YTTime = DTR["YT_BTime"].ToString() + "-" + DTR["YT_ETime"].ToString();; //预约时间表的日期
string YUTime = ""; //我的预约表的日期
if (ds != null)
{
YUTime = ds._yu_time;
begin = Convert.ToDateTime(ds._yu_data);
}
DateTime aaa = Convert.ToDateTime(DateTime.Now.AddDays(1).ToShortDateString().ToString());
string Datastate = ""; //判断这个日期是否有时间
string DataTime = ""; //判断这个时间段是否有预约
String[] arr =
{
DTR["YT_ID"].ToString(), //用户ID
DTR["U_LoginName"].ToString(), //登陆名称
"", //姓名名称
"", //性别
"", //姓名名称
"", //性别
"", //性别
"",
"",
Datastate,
DataTime, //10
YTTime, //11
Begindata, //12
Enddata
};
page.data.Add(arr);
}
}
}
page.recordsFiltered = page.recordsTotal;
String json = Common.ObjectToJson(page);
context.Response.Write(json);
}
catch
{
}
}
