/// <summary>
/// 查询群组人员
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <param name="userAccount"></param>
/// <param name="userName"></param>
/// <param name="personType"></param>
/// <returns></returns>
public DataSet QueryPersons(int pageIndex, int pageSize, out int rowCount, string userAccount, string userName, string personType, string groupID)
{
string strSql = @" SELECT TBLPERSON.oid ,
TBLPERSON.personaccount ,
TBLPERSON.personname ,
TBLPERSON.personsex ,
TBLPERSON.personstatus ,
TBLPERSON.personofficephone ,
TBLPERSON.personmobilephone ,
TBLPERSON.personemail ,
TBLPERSON.personmemo ,
persontype
FROM TBLGroupPersonMap
INNER JOIN TBLPERSON ON TBLGroupPersonMap.PersonID = TBLPERSON.oid
WHERE 1 = 1 ";
if (!string.IsNullOrEmpty(userAccount))
{
strSql += " and personaccount like @PersonAccount ";
}
if (!string.IsNullOrEmpty(userName))
{
strSql += " and personname like @PersonName ";
}
if (!string.IsNullOrEmpty(personType))
{
strSql += " and persontype = @PersonType ";
}
if (!string.IsNullOrEmpty(groupID))
{
strSql += " AND TBLGroupPersonMap.groupID=@GroupID ";
}
string[] paramNames = new string[4];
object[] paramValues = new object[4];
paramNames[0] = "PersonAccount";
paramNames[1] = "PersonName";
paramNames[2] = "PersonType";
paramNames[3] = "GroupID";
paramValues[0] = "%" + userAccount + "%";
paramValues[1] = "%" + userName + "%";
paramValues[2] = personType;
paramValues[3] = groupID;
SqlDBBroker broker = new SqlDBBroker();
broker.Open();
DataSet dst = broker.QueryPageFromSql(strSql, paramNames, paramValues, pageIndex, pageSize, out rowCount);
broker.Close();
return dst;
}
public DataSet QueryPersons(int pageIndex,int pageSize,out int rowCount,string userAccount,string userName)
{
string strSql = @" SELECT oid ,
personaccount ,
personname ,
personsex ,
personofficephone ,
personmobilephone ,
personemail ,
personmemo
FROM TBLPERSON where 1=1 ";
if (!string.IsNullOrEmpty(userAccount))
{
strSql += " and personaccount like @PersonAccount ";
}
if (!string.IsNullOrEmpty(userName))
{
strSql += " and personname like @PersonName ";
}
string[] paramNames = new string[2];
object[] paramValues = new object[2];
paramNames[0] = "PersonAccount";
paramNames[1] = "PersonName";
paramValues[0] = "%" + userAccount + "%";
paramValues[1] = "%" + userName + "%";
SqlDBBroker broker = new SqlDBBroker();
broker.Open();
DataSet dst = broker.QueryPageFromSql(strSql,paramNames,paramValues,pageIndex,pageSize,out rowCount);
broker.Close();
return dst;
}
public DataSet QueryGroupPermissions(int pageIndex, int pageSize, out int rowCount, string groupCode, string groupName)
{
string strSql = @" SELECT * FROM TBLPermissionGroup WHERE 1=1 ";
if (!string.IsNullOrEmpty(groupCode))
{
strSql += " and groupcode like @GroupCode ";
}
if (!string.IsNullOrEmpty(groupName))
{
strSql += " and groupname like @GroupName ";
}
string[] paramNames = new string[2];
object[] paramValues = new object[2];
paramNames[0] = "GroupCode";
paramNames[1] = "GroupName";
paramValues[0] = "%" + groupCode + "%";
paramValues[1] = "%" + groupName + "%";
SqlDBBroker broker = new SqlDBBroker();
broker.Open();
DataSet dst = broker.QueryPageFromSql(strSql, paramNames, paramValues, pageIndex, pageSize, out rowCount);
broker.Close();
return dst;
}