public ActionResult Edit(string id) { SecUser user = new SecUser(); if (id != null) { user = _userService.Get(id); string strSql = @"SELECT Name FROM Sec_Organization WHERE OrganizationId=#OrganizationId#"; string orgName = _dba.ExecuteScalar <string>(strSql, new { OrganizationId = user.OrganizationId }); ViewBag.OrgName = orgName; } return(View(user)); }
public ActionResult Edit(string id, string ParentId) { ViewBag.ParentName = _dba.ExecuteScalar <string>("SELECT Name FROM Sec_Menu WHERE MenuId=#MenuId#", new { MenuId = ParentId }); SecMenu model = new SecMenu(); model.ParentId = ParentId; if (id != null) { model = _menuService.Get(id); } return(View(model)); }
public ActionResult Edit(string id, string ParentId) { ViewBag.ParentName = _dba.ExecuteScalar <string>("SELECT Name FROM dbo.Sec_Organization WHERE OrganizationId=#OrganizationId#", new { OrganizationId = ParentId }); SecOrganization model = new SecOrganization(); model.ParentId = ParentId; if (id != null) { model = _organizationService.Get(id); } return(View(model)); }
public void EvnValParameterTest() { var date = _dba.ExecuteScalar <string>("select '{{date}}'"); Console.WriteLine(date); Assert.AreEqual <string>(DateTime.Now.ToString("yyyy-MM-dd"), date); var datetime = _dba.ExecuteScalar <string>("select '{{datetime:yyyyMMddHHmmss}}'"); Console.WriteLine(datetime); Assert.AreEqual <string>(DateTime.Now.ToString("yyyyMMddHHmmss"), datetime); var guid = _dba.ExecuteScalar <string>("select '{{guid}}'"); Console.WriteLine(guid); Assert.AreEqual <int>(Guid.NewGuid().ToString().Length, guid.Length); }