public JsonResult SendData(string StaffNumber)
{
StaffArchive staffArchive = new StaffArchive();
var itemStaff = (from p in db.Staffs
where StaffNumber == p.StaffNumber
select p).FirstOrDefault();
//赋值
staffArchive.StaffName = itemStaff.Name;
staffArchive.LeaveDate = itemStaff.LeaveDate;
staffArchive.ReApplyDate= null;
return Json(staffArchive);
}
public ActionResult Test()
{
var temp= from p in db.StaffArchives select new {学生姓名=p.BillTypeName};
StaffArchive sa=new StaffArchive();
//string temp = sa.BillTypeName.;
DataTable dt = new DataTable("StaffArchives");
//db.Database.Connection("");
//DataClasses1DataContext dc = new DataClasses1DataContext();
//var temp = from sa in db.GetTables() select sa;
//foreach (var t in temp) {
//foreach(var tt in t.rowT)
//{
//}}
return View();
}
public JsonResult SendBillTypeNumber(string BillTypeNumber)
{
StaffArchive staffArchive = new StaffArchive();
var item = (from p in db.BillProperties where BillTypeNumber == p.Type select p).FirstOrDefault();
staffArchive.BillTypeName = item.TypeName;
return Json(staffArchive);
}
