/// <summary> /// 查找从id之前的消息 /// </summary> /// <param name="userID"></param> /// <param name="id"></param> /// <returns></returns> public List <Message> QueryUserLatestMessages(string userID, long id) { if (id < 0) { id = long.MaxValue; } DataTable dt = LanIMStore.Instance.Query(Sql.QUERY_USER_LATEST_MESSAGE, new SQLiteParameter("@USER_ID", userID), new SQLiteParameter("@ID", id)); ModelConvert <Message> convert = new ModelConvert <Message>(); IInstanceCreater <Message> ic = new MessageInstanceCreater("C_TYPE"); List <Message> list = convert.Convert(dt, ic, new ColumnMapping("C_ID", "ID"), new ColumnMapping("C_TIME", "Time"), new ColumnMapping("C_FROM_USER_ID", "FromUserId"), new ColumnMapping("C_TO_USER_ID", "ToUserId"), new ColumnMapping("C_CONTENT", "Content"), new ColumnMapping("C_FLAG", "Flag")); //按发送顺序 list.Reverse(); foreach (Message m in list) { if (m is IPost) { (m as IPost).Post(); } } return(list); }
public List <Contacter> Query() { DataTable dt = LanIMStore.Instance.Query(Sql.QUERY_CONTACTER); ModelConvert <Contacter> convert = new ModelConvert <Contacter>(); IInstanceCreater <Contacter> ic = new CommonInstanceCreater <Contacter>(); List <Contacter> cs = convert.Convert(dt, ic, new ColumnMapping("C_ID", "ID"), new ColumnMapping("C_NICK_NAME", "NickName"), new ColumnMapping("C_MAC", "MAC"), new ColumnMapping("C_IP", "IP"), new ColumnMapping("C_PORT", "Port"), new ColumnMapping("C_MEMO", "Memo")); return(cs); }