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