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); }