/// <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 void UpdateState(Message m)
{
ModelConvert <Message> convert = new ModelConvert <Message>();
SQLiteParameter[] parameters = convert.CreateParameters(m,
new ColumnMapping("C_ID", "ID"),
new ColumnMapping("C_FLAG", "Flag"));
LanIMStore.Instance.Update(Sql.UPDATE_MESSAGE_STATE, parameters);
}
public void UpdateMemo(Contacter c)
{
ModelConvert <Contacter> convert = new ModelConvert <Contacter>();
SQLiteParameter[] parameters = convert.CreateParameters(c,
new ColumnMapping("C_MAC", "MAC"),
new ColumnMapping("C_MEMO", "Memo"));
LanIMStore.Instance.Update(Sql.UPDATE_CONTACTER_MEMO, parameters);
}
public void Update(Contacter m)
{
ModelConvert <Contacter> convert = new ModelConvert <Contacter>();
SQLiteParameter[] parameters = convert.CreateParameters(m,
new ColumnMapping("C_NICK_NAME", "NickName"),
new ColumnMapping("C_MAC", "MAC"),
new ColumnMapping("C_PORT", "Port"),
new ColumnMapping("C_IP", "IP"));
LanIMStore.Instance.Update(Sql.UPDATE_CONTACTER, parameters);
}
public void Add(Contacter c)
{
ModelConvert <Contacter> convert = new ModelConvert <Contacter>();
SQLiteParameter[] parameters = convert.CreateParameters(c,
new ColumnMapping("C_NICK_NAME", "NickName"),
new ColumnMapping("C_MAC", "MAC"),
new ColumnMapping("C_IP", "IP"),
new ColumnMapping("C_PORT", "Port"));
int id = LanIMStore.Instance.Insert(Sql.ADD_CONTACTER, parameters);
c.ID = id;
}
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);
}
public void Add(Message m)
{
if (m is IPrepare)
{
//如果是需要准备的文件，事先准备工作
(m as IPrepare).Prepare();
}
ModelConvert <Message> convert = new ModelConvert <Message>();
SQLiteParameter[] parameters = convert.CreateParameters(m,
new ColumnMapping("C_TYPE", "Type"),
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"));
int id = LanIMStore.Instance.Insert(Sql.ADD_MESSAGE, parameters);
m.ID = id;
}