public ActionResult Index()
{
string constring = ConfigurationManager.AppSettings["connectionString"];
Registration registration = new Registration(constring);
if (registration.IsItemReturn())
{
ViewBag.state = "设备状态: 已归还";
}
else
{
ViewBag.state = registration.State;
}
List <string[]> tmp = new Advance(constring).GetTen();
List <AdvanceModel> result = new List <AdvanceModel>();
int i = 1;
foreach (var item in tmp)
{
AdvanceModel model = new AdvanceModel();
model.ID = i++;
model.Name = item[0];
model.Reason = item[1];
model.LendTime = item[2];
model.ReturnTime = item[3];
result.Add(model);
}
return(View(result));
}
public ActionResult FindAdvance(string name, string beginTime, string endTime, string page)
{
string constring = ConfigurationManager.AppSettings["connectionString"];
if (beginTime == string.Empty)
{
beginTime = "2000.1.1 00:00";
}
if (endTime == string.Empty)
{
endTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
}
List <string[]> data = new Advance(constring).FindPage(name, beginTime, endTime, page);
List <AdvanceModel> result = new List <AdvanceModel>();
foreach (var item in data)
{
AdvanceModel model = new AdvanceModel();
model.ID = int.Parse(item[0]);
model.Name = item[1];
model.Reason = item[2];
model.LendTime = item[3];
model.ReturnTime = item[4];
result.Add(model);
}
return(Json(result));
}
