Member IQueryManager.queryMember(int id)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
Member t1 = sd.getMember(id);
return(t1);
}
public Member getAncestor(int mapid)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member m1 = dBUtil.getAncestor(mapid);
return(m1);
}
public List <Member> getMemberList(int mapid)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
List <Member> m1 = dBUtil.getMemberList(mapid);
return(m1);
}
public int getFatherId(string name)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
Member father = sd.getMember(name);
return(father.Id);
}
public int getMapid(int id)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
Map map = sd.getMap(id);
return(map.Id);
}
Map IQueryManager.queryMap(int id)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
Map t2 = sd.getMap(id);
return(t2);
}
public void modifyUserPerLevel(string username, int perLevel)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User user = dBUtil.getUser(username);
user.PerLevel = perLevel;
dBUtil.modifyUser(username, 5, user);
}
public void modifyUserPassword(string username, string pwd)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User user = dBUtil.getUser(username);
user.Pwd = pwd;
dBUtil.modifyUser(username, 2, user);
}
public string getMapName(int id)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member m1 = dBUtil.getMember(id);
Map m2 = dBUtil.getMap(m1.Mapid);
return(m2.Name);
}
/*以下为2.0*/
public int getMemberid(string name)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member m1 = dBUtil.getMember(name);
if (m1 == null)
{
return(-1);
}
return(m1.Id);
}
public int getMapid(int id)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
Map map = sd.getMap(id);
if (map == null)
{
return(-1);
}
return(map.Id);
}
public string getMemberName(int id)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member member = dBUtil.getMember(id);
if (member == null)
{
return(null);
}
return(member.Name);
}
/*第二版*/
public void deleteMember(string name)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
List <Partner> list1 = dBUtil.getPartnerList(name);
for (int i = 0; i < list1.Count; i++)
{
dBUtil.deletePartner(list1[i].Name);
}
dBUtil.deleteMember(name);
}
public string getPartnerName(int id)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member m1 = dBUtil.getMember(id);
List <Partner> list1 = dBUtil.getPartnerList(m1.Name);
if (list1.Count == 0)
{
return(null);
}
return(list1[0].Name);
}
public int getMapid(string name)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User u1 = dBUtil.getUser(name);
Map m2 = dBUtil.getMap(u1.Mapid);
if (m2 == null)
{
return(-1);
}
return(m2.Id);
}
public bool verifyUser(string username, string email)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User user = dBUtil.getUser(username);
if (user.Email == email)
{
return(true);
}
else
{
return(false);
}
}
public bool hasUser(string username)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User user = dBUtil.getUser(username);
if (user == null)
{
return(false);
}
else
{
return(true);
}
}
public bool isLogin(string username, string pwd)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User user = dBUtil.getUser(username);
if (pwd != user.Pwd)
{
return(false);
}
else
{
return(true);
}
}
public int getPerLevel(string username)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
User user = dBUtil.getUser(username);
if (user == null)
{
return(-1);
}
else
{
return(user.PerLevel);
}
}
public int[] getRelativeId(int num, int id)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member m1 = dBUtil.getMember(id);
int[] a = new int[10];
for (int i = 0; i < 10; i++)
{
a[i] = 0;
}
if (num == 1)
{
a[0] = m1.Fatherid;
}
else if (num == 2)
{
List <Member> l1 = dBUtil.getChildList(m1.Fatherid);
for (int i = 0; i < l1.Count; i++)
{
if (l1[i].Sex == '男' && l1[i].Id != id)
{
a[i] = l1[i].Id;
}
}
}
else if (num == 3)
{
List <Member> l1 = dBUtil.getChildList(m1.Fatherid);
for (int i = 0; i < l1.Count; i++)
{
if (l1[i].Sex == '女' && l1[i].Id != id)
{
a[i] = l1[i].Id;
}
}
}
else if (num == 4)
{
List <Member> l1 = dBUtil.getChildList(m1.Id);
{
for (int i = 0; i < l1.Count; i++)
{
a[i] = l1[i].Id;
}
}
}
return(a);
}
public Partner getMother(int id)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
Member m1 = dBUtil.getMember(id);
Member f1 = dBUtil.getMember(m1.Fatherid);
List <Partner> p1 = dBUtil.getPartnerList(f1.Name);
if (p1.Count != 0)
{
return(p1[0]);
}
else
{
return(null);
}
}
/*第二版*/
public void deleteMap(int mapid)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
dBUtil.deleteMap(mapid);
List <Member> list1 = dBUtil.getMemberList(mapid);
for (int i = 0; i < list1.Count; i++)
{
List <Partner> list2 = dBUtil.getPartnerList(list1[i].Name);
for (int j = 0; j < list2.Count; j++)
{
dBUtil.deletePartner(list2[j].Name);
}
dBUtil.deleteMember(list1[i].Name);
}
}
public User queryUser(string username)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
return(dBUtil.getUser(username));
}
public void addMember(Member member)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
sd.addMember(member);
}
public void modifyMap(int id, Map map)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
dBUtil.modifyMap(id, 0, map);
}
public Member queryMember(string name)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
return(dBUtil.getMember(name));
}
public void modifyUser(string username, User user)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
dBUtil.modifyUser(username, 0, user);
}
public void addUser(User user)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
dBUtil.addUser(user);
}
public void modifyMember(int id, Member member)
{
IDBUtil dBUtil = DBUtilFactory.getDBUtil("DBUtilImpl");
dBUtil.modifyMember(id, 0, member);
}
public void addPartner(Partner partner)
{
IDBUtil sd = DBUtilFactory.getDBUtil("DBUtilImpl");
sd.addPartner(partner);
}
