public List <TalkContent> GetTalkCustomer(DateTime start, DateTime end, string fnick, TalkObjType otype)
{
string nick = fnick.IndexOf(":") >= 0 ? fnick.Substring(0, fnick.IndexOf(':')) : fnick;
string sql = SQL_SELECT_TALKCONTENT_CUSTOMER.Replace("@tableName", DBHelper.GetRealTable("TalkContent", DataHelper.Encrypt(nick)));
if (otype == TalkObjType.Out)
{
sql += " AND FromId='" + fnick + "'";
}
List <TalkContent> list = new List <TalkContent>();
SqlParameter[] param = new[]
{
new SqlParameter("@start", start.ToShortDateString()),
new SqlParameter("@end", end.ToShortDateString())
};
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
foreach (DataRow dr in dt.Rows)
{
list.Add(new TalkContent {
ToNick = dr["ToId"].ToString()
});
}
return(list);
}
public List <TalkContent> GetTalkUser(DateTime start, DateTime end, string nick, TalkObjType otype)
{
string sql = SQL_SELECT_TALKCONTENT_USER.Replace("@tableName", DBHelper.GetRealTable("TalkContent", DataHelper.Encrypt(nick)));
List <TalkContent> list = new List <TalkContent>();
SqlParameter[] param = new[]
{
new SqlParameter("@start", start.ToShortDateString()),
new SqlParameter("@end", end.ToShortDateString())
};
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
foreach (DataRow dr in dt.Rows)
{
list.Add(new TalkContent {
FromNick = dr["FromId"].ToString()
});
}
return(list);
}
