private DataRow DetailFromId(string id)
{
string strSql = "select * from bas_user where user_id = " + id + "";
DataRow dr = DataBase.ExecuteDataRow(strSql);
return(dr);
}
private DataRow DetailFromCode(string user_code)
{
string strSql = "select * from bas_user where user_code = '" + user_code + "'";
DataRow dr = DataBase.ExecuteDataRow(strSql);
return(dr);
}
/// <summary>
/// 得到一个实体内容
/// </summary>
public BasRole DetailRole(string id)
{
string strSql = "select * from bas_role where id = " + id;
BasRole model = new BasRole();
DataRow dr = DataBase.ExecuteDataRow(strSql);
return(model);
}
//部门详细信息 Added Liangsx 2010-12-15
public Org Detail(int id)
{
string strSql = "select * from bas_org_online where org_id = " + id.ToString();
Org model = new Org();
DataRow dr = DataBase.ExecuteDataRow(strSql);
if (dr == null)
{
return(null);
}
model.Id = int.Parse(dr["org_id"].ToString());
model.OrgName = dr["org_name"].ToString().Trim();
//model.LinkName = dr["link_name"].ToString().Trim();
//model.LinkTel = dr["link_tel"].ToString().Trim();
//model.LinkMobile = dr["link_mobile"].ToString().Trim();
return(model);
}
/// <summary>
/// 得到一个实体内容
/// </summary>
public BasParam ParamDetail(string id)
{
string strSql = "select * from bas_param where id = " + id;
BasParam model = new BasParam();
DataRow dr = DataBase.ExecuteDataRow(strSql);
model.Id = dr["id"].ToString().Trim();
model.ParentId = dr["parent_id"].ToString().Trim();
model.Grade = dr["grade"].ToString().Trim();
model.Code = dr["code"].ToString().Trim();
model.Title = dr["title"].ToString().Trim();
model.Remark = dr["remark"].ToString().Trim();
model.Sort = dr["sort"].ToString().Trim();
model.EnableFlag = dr["enable_flag"].ToString().Trim();
return(model);
}
/// <summary>
/// 获得数据详细信息
/// </summary>
#region 获得数据详细信息
public BasModule BasModuleDetail(string id)
{
BasModule model = new BasModule();
string strSql = " select * from Bas_Module where module_id=" + id;
DataRow dr = DataBase.ExecuteDataRow(strSql);
model.ModuleId = dr["module_id"].ToString().Trim();
model.ModuleFather = dr["module_father"].ToString().Trim();
model.ModuleCode = dr["module_code"].ToString().Trim();
model.ModuleName = dr["module_name"].ToString().Trim();
model.ModuleIcon = dr["module_icon"].ToString().Trim();
model.ModuleWidth = dr["module_width"].ToString().Trim();
model.ModuleHeight = dr["module_height"].ToString().Trim();
model.ModuleUrl = dr["module_url"].ToString().Trim();
model.ModuleSort = dr["module_sort"].ToString().Trim();
model.EnableFlag = dr["enable_flag"].ToString().Trim();
model.ToolbarFlag = dr["toolbar_flag"].ToString().Trim();
model.ModulePurview = dr["module_purview"].ToString().Trim();
return(model);
}