public ActionResult Index()
{
ViewData["account"] = sessionService.GetAccount();
string nowYear = DateTime.Now.ToLocalTime().ToString("yyyy");
string command = string.Format("select * from Exemplar where SealedTime like '%{0}%' and Status = '4';", nowYear);
var exemplars = server.Find2SQL(command);
return(View(exemplars));
}
// 查询
public ActionResult Find1(string fclosetime, string fwlno, string fwlname,
string fwllclass, string fsup, string fver, string fvertime, string fstatus)
{
string command = string.Format("select * from Exemplar where SealedTime like '%{0}%' and Code like '%{1}%' and MaterialName like '%{2}%' and MaterialClass like '%{3}%' and Supplier like '%{4}%' and ValidTime like '%{5}%' and SignDate like '%{6}%' and ExemStatus like '%{7}%' and Status = '0';",
fclosetime, fwlno, fwlname, fwllclass, fsup, fver, fvertime, fstatus);
var exemplars = exemplarServer.Find2SQL(command);
return(View("BackHist", exemplars));
}
// 查找
public ActionResult Find(string fclosetime, string fwlno, string fwlname,
string fwllclass, string fsup, string fver, string fvertime)
{
string command = string.Format("select * from Exemplar where SealedTime like '%{0}%' and Code like '%{1}%' and MaterialName like '%{2}%' and MaterialClass like '%{3}%' and Supplier like '%{4}%' and ValidTime like '%{5}%' and SignDate like '%{6}%' and Status = '4';",
fclosetime, fwlno, fwlname, fwllclass, fsup, fver, fvertime);
var _exemplars = server.Find2SQL(command);
var exemplars = from exe in _exemplars
where exe.ExemStatus == "超期"
select exe;
return(View("Index", exemplars));
}
