public List <ChatRoom> GetChatRoomByUid(string uid)
{
string sql = $"select c.systemid,c.maincode,c.mainid,c.subject,c.creator,c.creatorid,c.createtime,c.lasttime,c.lastuid,c.lastuname,c.unread, c.name as uname, r.content as lastmsg from(select r.*, u.unread,u.name from \"user\" u, chatroom r where u.systemid = r.systemid and u.maincode = r.maincode and u.mainid = r.mainid and \"id\" = '{uid}') c left join(select * from record a where a.date = (select max(b.date) from record b where a.systemid = b.systemid and a.maincode = b.maincode and a.mainid = b.mainid)) r on c.systemid = r.systemid and c.maincode = r.maincode and c.mainid = r.mainid";
DataSet dataSet = DbAccess.ExecuteQuery(ConnString, CommandType.Text, sql);
return(ModelConvert.DataSetToIList <ChatRoom>(dataSet, 0).ToList());
}
public IList <Record> GetAll(string system, string maincode, string mainid)
{
string sql = string.Format("select * from record where systemid='{0}' and maincode='{1}' and mainid='{2}'", system, maincode, mainid);
DataSet dataSet = DbAccess.ExecuteQuery(ConnString, CommandType.Text, sql, null);
IList <Record> patInfos = ModelConvert.DataSetToIList <Record>(dataSet, 0);
return(patInfos);
}
public IList <User> GetUser(User user)
{
string sql = string.Format("select * from \"user\" where systemid='{0}' and maincode='{1}' and mainid='{2}' and \"id\"='{3}'",
user.System, user.MainCode, user.MainID, user.ID);
DataSet dataSet = DbAccess.ExecuteQuery(ConnString, CommandType.Text, sql, null);
IList <User> patInfos = ModelConvert.DataSetToIList <User>(dataSet, 0);
return(patInfos);
}
