public int UpdateSession(TopNickSessionInfo sessionInfo)
{
SqlParameter[] param = Getparameter(sessionInfo);
string sql = SQL_UPDATE + ",ShopId='" + sessionInfo.ShopId + "'";
if (sessionInfo.LastGetOrderTime != DateTime.MinValue)
sql += ",LastGetOrderTime='" + sessionInfo.LastGetOrderTime + "'";
sql += " WHERE nick=@nick AND ServiceId=" + (int)sessionInfo.ServiceId;
return DBHelper.ExecuteNonQuery(sql, param);
}
protected void Btn_Upload_Click(object sender, EventArgs e)
{
//try
//{
//获取cookie
string nickNo = Request.Cookies["nick"].Value;
string topsession = Request.Cookies["nicksession"].Value;
if (string.IsNullOrEmpty(nickNo))
{
Page.RegisterStartupScript("error", "<script>alert('非法用户!');</script>");
}
//Rijndael_ encode = new Rijndael_("tetesoft");
////解密得到真实nick
//string realNickNo = encode.Encrypt(nickNo);
string name = FUp_Img.FileName;
string type = name.Substring(name.LastIndexOf(".") + 1).ToLower();
if (type == "jpg" || type == "png" || type == "bmp" || type == "gif" || type == "jpeg")
{
try
{
//图片名称统一用md5加密后的，后缀为jpg格式
String ReName = DataHelper.Encrypt(HttpUtility.UrlDecode(nickNo)) + ".jpg"; //图片重命名
String Ipath = Server.MapPath("~/Images/nickimgs") + "\\" + ReName; //文件实际路径
FUp_Img.SaveAs(Ipath); //上传到图片目录
TopNickSessionInfo info = new TopNickSessionInfo();
info.Nick = nickNo;
info.NickState = true;
info.JoinDate = DateTime.Now;
info.Session = topsession;
//new NickSessionService().AddSession(info);
}
catch (Exception ex)
{
Page.RegisterStartupScript("error", "<script>alert('图片上传失败,请重试!" + ex.Message.ToString() + "');</script>");
}
TA_Code.Value = "<img src=\"" + DataHelper.GetAppSetings("hostname") + "GetData.ashx?nick=" + nickNo + "\" border=\"0\" />";
}
else
{
Page.RegisterStartupScript("error", "<script>alert('图片格式不对!');</script>");
}
//}
//catch(Exception ex)
//{
// Page.RegisterStartupScript("error", "<script>alert('图片上传失败,请重试"+ex.Message+"!');</script>");
//}
}
private static SqlParameter[] Getparameter(TopNickSessionInfo sessionInfo)
{
SqlParameter[] param = new[]
{
new SqlParameter("@nick",sessionInfo.Nick),
new SqlParameter("@session",sessionInfo.Session),
new SqlParameter("@JoinDate",sessionInfo.JoinDate),
new SqlParameter("@NickState",sessionInfo.NickState),
new SqlParameter("@LastGetOrderTime", sessionInfo.LastGetOrderTime)
};
return param;
}
//public int InsertSerssion(TopNickSessionInfo sessionInfo)
//{
// SqlParameter[] param = Getparameter(sessionInfo);
// return DBHelper.ExecuteNonQuery(SQL_INSERT, param);
//}
/// <summary>
/// 正式使用的插入用户信息
/// </summary>
/// <param name="sessionInfo"></param>
/// <returns></returns>
public int InsertSerssionNew(TopNickSessionInfo sessionInfo)
{
SqlParameter[] param = Getparameter(sessionInfo);
List<SqlParameter> plist = new List<SqlParameter>();
foreach (SqlParameter p in param)
plist.Add(p);
plist.Add(new SqlParameter("@ServiceID", (int)sessionInfo.ServiceId));
plist.Add(new SqlParameter("@ShopId", sessionInfo.ShopId));
plist.Add(new SqlParameter("@RefreshToken", sessionInfo.RefreshToken));
return DBHelper.ExecuteNonQuery(SQL_INSERT_NEW, plist.ToArray());
}
private TopNickSessionInfo GetSessionInfo(string session)
{
SqlParameter param = new SqlParameter("@session", session);
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT, param);
TopNickSessionInfo info = null;
foreach (DataRow dr in dt.Rows)
{
info = new TopNickSessionInfo();
info.Nick = dr["nick"].ToString();
info.LastGetOrderTime = DateTime.Parse(dr["LastGetOrderTime"].ToString()); ;
info.NickState = (bool)dr["NickState"];
}
return info;
}
/// <summary>
/// 插入session
/// </summary>
private void InsertSession()
{
TopNickSessionInfo info = new TopNickSessionInfo();
info.Nick = nick;
info.Session = top_session;
info.NickState = true;
DateTime now = DateTime.Now;
info.JoinDate = now;
info.LastGetOrderTime = now;
info.ShopId = shopId;
info.ServiceId = Enum.TopTaoBaoService.YingXiaoJueCe;
info.RefreshToken = refreshToken;
//有则不添加
if (CacheCollection.GetNickSessionList().Where(o => o.Nick == nick && o.ServiceId == Enum.TopTaoBaoService.YingXiaoJueCe).ToList().Count == 0)
{
//先添加后删除缓存
new NickSessionService().InsertSerssionNew(info);
CacheCollection.RemoveCacheByKey(CacheCollection.KEY_ALLNICKSESSIONINFO);
}
else
{
//新session赋值
CacheCollection.GetNickSessionList().Where(o => o.Nick == nick && o.ServiceId == Enum.TopTaoBaoService.YingXiaoJueCe).ToList()[0].Session = top_session;
}
//修改缓存后读取店铺信息
//info.ShopId = TaoBaoAPI.GetShopInfo(nick, top_session);
//更新店铺信息
//new NickSessionService().UpdateSession(info);
//更新缓存
//CacheCollection.GetNickSessionList().Where(o => o.Nick == nick && o.ServiceId == Enum.TopTaoBaoService.YingXiaoJueCe).ToList()[0].ShopId = info.ShopId;
HttpCookie cookie = new HttpCookie("nick", HttpUtility.UrlEncode(nick));
HttpCookie cooksession = new HttpCookie("nicksession", top_session);
HttpCookie cookietongji = new HttpCookie("istongji", "1");
cookie.Expires = DateTime.Now.AddDays(1);
cooksession.Expires = DateTime.Now.AddDays(1);
cookietongji.Expires = DateTime.Now.AddDays(1);
Response.Cookies.Add(cookie);
Response.Cookies.Add(cooksession);
Response.Cookies.Add(cookietongji);
}
public IList<TopNickSessionInfo> GetAllNickSession()
{
IList<TopNickSessionInfo> list = new List<TopNickSessionInfo>();
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_NICKNO);
foreach (DataRow dr in dt.Rows)
{
TopNickSessionInfo info = new TopNickSessionInfo();
info.Nick = dr["nick"].ToString();
info.Session = dr["session"].ToString();
info.NickState = (bool)dr["NickState"];
info.LastGetOrderTime = dr["LastGetOrderTime"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(dr["LastGetOrderTime"].ToString());
info.ServiceId = (Enum.TopTaoBaoService)int.Parse(dr["ServiceID"].ToString());
info.ShopId = dr["ShopId"].ToString();
list.Add(info);
}
return list;
}
/// <summary>
/// 搜索订购指定服务的用户信息
/// </summary>
/// <param name="serviceId"></param>
/// <returns></returns>
public IList <TopNickSessionInfo> GetAllNickSession(TopTaoBaoService serviceId)
{
SqlParameter param = new SqlParameter("@ServiceID", (int)serviceId);
IList <TopNickSessionInfo> list = new List <TopNickSessionInfo>();
using (SqlDataReader dr = ServiceDBHelper.CreateReader(SQL_SELECT_NICKNO, param))
{
if (dr != null)
{
while (dr.Read())
{
TopNickSessionInfo info = new TopNickSessionInfo();
info.Nick = dr["nick"].ToString();
info.Session = dr["session"].ToString();
info.NickState = (bool)dr["NickState"];
info.LastGetOrderTime = dr["LastGetOrderTime"] == DBNull.Value ? DateTime.MinValue : DateTime.Parse(dr["LastGetOrderTime"].ToString());
info.ShopId = dr["ShopId"].ToString();
list.Add(info);
}
}
}
return(list);
}
