public ActionResult NewInvoice() { if (Session["username"] == null || Session["username"].Equals("")) { return(RedirectToAction("Index", "Session")); } NewInvoiceViewModel vm = new NewInvoiceViewModel(); using (var db = new ProjectManagementEntities()) { //Get Project DataTable dtPro = new DataTable(); dtPro.Columns.Add(new DataColumn("ID", typeof(string))); dtPro.Columns.Add(new DataColumn("Name", typeof(string))); var proArr = db.Project; foreach (var pro in proArr) { var dtProRow = dtPro.NewRow(); dtProRow["ID"] = pro.ID; dtProRow["Name"] = String.Format("(代码:{0}) {1}", pro.ID, pro.Name); dtPro.Rows.Add(dtProRow); } vm.Project = dtPro; //GetPartyB DataTable dtPartyB = new DataTable(); dtPartyB.Columns.Add(new DataColumn("ID", typeof(string))); dtPartyB.Columns.Add(new DataColumn("Name", typeof(string))); var partyBArr = db.PartyB; foreach (var partyB in partyBArr) { var dtPartyBRow = dtPartyB.NewRow(); dtPartyBRow["ID"] = partyB.ID; dtPartyBRow["Name"] = "(代码:" + partyB.ID + ") " + partyB.Name; dtPartyB.Rows.Add(dtPartyBRow); } vm.PartyB = dtPartyB; } return(View(vm)); }
public NewInvoicePage() { InitializeComponent(); BindingContext = viewModel = new NewInvoiceViewModel(); }