public ActionResult SearchProject() { var keyStr = "桥梁"; //搜索关键字 //创建数据库实体 var db = new Models.BPMSxEntities(); var data = from p in db.project where p.project_name.Contains(keyStr) select p; return(View(data)); }
// GET: project //显示前n条项目信息 public ActionResult Index() { int n = 50; //显示前50条数据 //创建数据库实体 var db = new Models.BPMSxEntities(); //var data = db.project; //查询所有数据 var data = (from p in db.project select p).Take(n); return(View(data)); }
public ActionResult ProjectDetails(string id) { //创建数据库实体 var db = new Models.BPMSxEntities(); //int option = 1; var data = from p in db.project where p.id == id select p; var data1 = from p in db.contact join p1 in db.project on p.id equals p1.contact_id where p1.id == id select p; //from t in db.tb_projects //from t0 in db.tb_staffs //where // t.resp_staff_no == t0.staff_no && // t0.staff_name == "李鹏" //select new //{ // 项目名称 = t.prj_name, // t0.staff_name //} ViewBag.cnt = data1; var data2 = from p in db.r_project_staff where p.project_id == id select p; ViewBag.r_p_s = data2; var data3 = from p in db.project_money_flow where p.project_id == id select p; ViewBag.p_m_f = data3; return(View(data)); }