internal Sys_subnav Getsys_subnav(string vurl, string parastr)
{
if (parastr != "" && parastr.IndexOf('?') == -1)
{
parastr = "?" + parastr;
}
string sql = "select * from sys_subnav where subnav_url='" + vurl.ToLower() + parastr.ToLower() + "'";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
using (var reader = cmd.ExecuteReader())
{
Sys_subnav r = null;
if (reader.Read())
{
r = new Sys_subnav
{
id = reader.GetValue <int>("id"),
subnav_name = reader.GetValue <string>("subnav_name"),
subnav_url = reader.GetValue <string>("subnav_url"),
viewcode = reader.GetValue <int>("viewcode"),
sortid = reader.GetValue <int>("sortid"),
actioncolumnid = reader.GetValue <int>("actioncolumnid"),
actionid = reader.GetValue <int>("actionid"),
};
}
return(r);
}
}
internal Sys_subnav Getsyssubnav(int subnavid)
{
string sql = @"SELECT [id]
,[subnav_name]
,[subnav_url]
,[viewcode]
,[sortid]
,[actioncolumnid]
,[actionid]
FROM [sys_subnav] where id=@id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", subnavid);
using (var reader = cmd.ExecuteReader())
{
Sys_subnav m = null;
if (reader.Read())
{
m = new Sys_subnav
{
id = reader.GetValue <int>("id"),
subnav_name = reader.GetValue <string>("subnav_name"),
subnav_url = reader.GetValue <string>("subnav_url"),
viewcode = reader.GetValue <int>("viewcode"),
sortid = reader.GetValue <int>("sortid"),
actioncolumnid = reader.GetValue <int>("actioncolumnid"),
actionid = reader.GetValue <int>("actionid"),
};
}
return(m);
}
}
