/// <summary>获得数据列表
///
/// </summary>
public DataSet GetList(string strWhere)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
DataSet ds = new DataSet();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM Bse_Menu ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
h.CreateCommand(strSql.ToString());
DataTable dt = h.ExecuteQuery();
ds.Tables.Add(dt);
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
/// <summary>获得数据列表
///
/// </summary>
public DataSet GetList(string Realname, string Number, string Name, string Sex, string Role_Id)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM dbo.Bse_User A INNER JOIN Bse_User_Role B ON A.User_Id=B.UserId WHERE A.State=1 and ( A.Realname LIKE '%" + Realname + "%' OR '" + Realname + "'='') AND ( A.Number LIKE '%" + Number + "%' OR '" + Number + "'='') AND ( A.UserName LIKE '%" + Name + "%' OR '" + Name + "'='') AND ( A.Sex LIKE '%" + Sex + "%' OR '" + Sex + "'='') AND B.RoleId=" + Role_Id + "");
h.CreateCommand(strSql.ToString());
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>获得用户所属机构
///
/// </summary>
public DataSet GetListUserOrganize(string strWhere)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT b.Name as BlockName,c.Name as CompanyName ,d.Name as DeptName FROM dbo.Bse_User a INNER JOIN dbo.Bse_Organize b ON a.Bloc_Id=b.Organize_Id INNER JOIN dbo.Bse_Organize c ON a.Company_Id=c.Organize_Id INNER JOIN dbo.Bse_Organize d ON a.Dept_Id=d.Organize_Id ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
h.CreateCommand(strSql.ToString());
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>获得用户所属角色
///
/// </summary>
public DataSet GetListUserRoleIds(string strWhere)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
StringBuilder strSql = new StringBuilder();
strSql.Append(" SELECT CAST ( f.Role_Id as VARCHAR) Role_Id INTO #TEMP FROM dbo.Bse_User a INNER JOIN dbo.Bse_User_Role e ON e.UserId=a.User_Id INNER JOIN dbo.Bse_Role f ON f.Role_Id=e.RoleId ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" EXEC [Sp_TableToString] 'Role_Id','#TEMP','' DROP TABLE #TEMP");
h.CreateCommand(strSql.ToString());
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>分页获取数据列表
///
/// </summary>
public DataSet GetList(string fileds, string order, string ordertype, int PageSize, int PageIndex, string strWhere)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
h.CreateStoredCommand("[proc_SplitPage]");
h.AddParameter("@tblName", "Bse_Role_Menu");
h.AddParameter("@strFields", fileds);
h.AddParameter("@strOrder", order);
h.AddParameter("@strOrderType", ordertype);
h.AddParameter("@PageSize", PageSize);
h.AddParameter("@PageIndex", PageIndex);
h.AddParameter("@strWhere", strWhere);
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>获得数据列表
///
/// </summary>
public DataSet GetUserByOrganizeId(string strWhere)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
StringBuilder strSql = new StringBuilder();
strSql.Append("select a.User_Organize_Id,b.* ");
strSql.Append(" FROM Bse_User_Organize a inner join Bse_User b on a.User_Id=B.User_Id");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
h.CreateCommand(strSql.ToString());
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>获得数据列表
///
/// </summary>
public DataSet GetList(string strWhere, string Filds)
{
IMsSqlDataAccessService h = ServiceHelper.GetMsSqlDataAccessService();
StringBuilder strSql = new StringBuilder();
strSql.Append("select " + Filds + " ");
strSql.Append(" FROM Bse_Role_Menu ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
h.CreateCommand(strSql.ToString());
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
