public bool SearchGroups(string search, out GroupInfoPackage[] infos)
{
infos = null;
string sql = string.Format
(
"select " +
"SelectedGroup.{2} as GID, " +
"SelectedGroup.{3} as GName, " +
"SelectedGroup.{4} as Describe, " +
"SelectedGroup.{5} as CTime, " +
"SelectedUser.{7} as CID, " +
"SelectedUser.{8} as CName " +
"from {6} as SelectedUser, " +
"(" +
"select * from {1} where {2} like '%{0}%' union " +
"select * from {1} where {3} like '%{0}%' union " +
"select * from {1} where {4} like '%{0}%'" +
") as SelectedGroup " +
"where SelectedUser.{9} = SelectedGroup.{7}",
search, // 0
DBStaticData.DataBaseGroupTableName, // 1
DBStaticData.DataBaseGroupTableGroupIDField, // 2
DBStaticData.DataBaseGroupTableNameField, // 3
DBStaticData.DataBaseGroupTableDescribeField, // 4
DBStaticData.DataBaseGroupTableCreateTimeField, // 5
DBStaticData.DataBaseUserTableName, // 6
DBStaticData.DataBaseUserTableIDField, // 7
DBStaticData.DataBaseUserTableNameField, // 8
DBStaticData.DataBaseGroupTableCreatorIDField // 9
);
if (ExecuteNonDataSet(sql, out DataSet set))
{
if (0 < set.Tables[0].Rows.Count)
{
infos = new GroupInfoPackage[set.Tables[0].Rows.Count];
for (int i = 0; i < infos.Length; ++i)
{
infos[i] = new GroupInfoPackage
{
ID = set.Tables[0].Rows[i].ItemArray[0] as string,
Name = set.Tables[0].Rows[i].ItemArray[1] as string,
Describe = set.Tables[0].Rows[i].ItemArray[2] as string,
Time = (DateTime)set.Tables[i].Rows[0].ItemArray[3],
ManagerID = set.Tables[0].Rows[i].ItemArray[4] as string,
ManagerName = set.Tables[0].Rows[i].ItemArray[5] as string,
}
}
;
return(true);
}
}
return(false);
}
public bool SelectGroupInfos(string[] ids, out GroupInfoPackage[] infos)
{
infos = null;
string sql = string.Format
(
"select {0}.{1} as GID, " +
"{0}.{2} as GName, " +
"{0}.{3} as Describe, " +
"{0}.{4} as CTime, " +
"{5}.{6} as CID, " +
"{5}.{7} as CName " +
"from {0}, {5} " +
"where {0}.{8} = {5}.{6} and {0}.{1} in ('{9}')",
DBStaticData.DataBaseGroupTableName,
DBStaticData.DataBaseGroupTableGroupIDField,
DBStaticData.DataBaseGroupTableNameField,
DBStaticData.DataBaseGroupTableDescribeField,
DBStaticData.DataBaseGroupTableCreateTimeField,
DBStaticData.DataBaseUserTableName,
DBStaticData.DataBaseUserTableIDField,
DBStaticData.DataBaseUserTableNameField,
DBStaticData.DataBaseGroupTableCreatorIDField,
string.Join("', '", ids)
);
if (ExecuteNonDataSet(sql, out DataSet set))
{
if (0 < set.Tables[0].Rows.Count)
{
infos = new GroupInfoPackage[set.Tables[0].Rows.Count];
for (int i = 0; i < infos.Length; ++i)
{
infos[i] = new GroupInfoPackage
{
ID = set.Tables[0].Rows[i].ItemArray[0] as string,
Name = set.Tables[0].Rows[i].ItemArray[1] as string,
Describe = set.Tables[0].Rows[i].ItemArray[2] as string,
Time = (DateTime)set.Tables[i].Rows[0].ItemArray[3],
ManagerID = set.Tables[0].Rows[i].ItemArray[4] as string,
ManagerName = set.Tables[0].Rows[i].ItemArray[5] as string,
}
}
;
return(true);
}
}
return(false);
}
public bool SelectGroupInfo(string id, out GroupInfoPackage info)
{
info = null;
string sql = string.Format
(
"select {0}.{1} as GID, " +
"{0}.{2} as GName, " +
"{0}.{3} as Describe, " +
"{0}.{4} as CTime, " +
"{5}.{6} as CID, " +
"{5}.{7} as CName " +
"from {0}, {5} " +
"where {0}.{8} = {5}.{6} and {0}.{1} = '{9}'",
DBStaticData.DataBaseGroupTableName,
DBStaticData.DataBaseGroupTableGroupIDField,
DBStaticData.DataBaseGroupTableNameField,
DBStaticData.DataBaseGroupTableDescribeField,
DBStaticData.DataBaseGroupTableCreateTimeField,
DBStaticData.DataBaseUserTableName,
DBStaticData.DataBaseUserTableIDField,
DBStaticData.DataBaseUserTableNameField,
DBStaticData.DataBaseGroupTableCreatorIDField,
id
);
if (ExecuteNonDataSet(sql, out DataSet set))
{
if (0 < set.Tables[0].Rows.Count)
{
info = new GroupInfoPackage
{
ID = set.Tables[0].Rows[0].ItemArray[0] as string,
Name = set.Tables[0].Rows[0].ItemArray[1] as string,
Describe = set.Tables[0].Rows[0].ItemArray[2] as string,
Time = (DateTime)set.Tables[0].Rows[0].ItemArray[3],
ManagerID = set.Tables[0].Rows[0].ItemArray[4] as string,
ManagerName = set.Tables[0].Rows[0].ItemArray[5] as string,
};
return(true);
}
}
return(false);
}
