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