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); }