/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_oauth GetModel(int id) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); Model.user_oauth model = new Model.user_oauth(); //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); foreach (PropertyInfo p in pros) { str1.Append(p.Name + ",");//拼接字段 } strSql.Append("select top 1 " + str1.ToString().Trim(',')); strSql.Append(" from " + databaseprefix + "user_oauth"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; DataTable dt = DbHelperSQL.Query(strSql.ToString(), parameters).Tables[0]; if (dt.Rows.Count > 0) { return(DataRowToModel(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 根据开放平台和openid返回一个实体 /// </summary> public Model.user_oauth GetModel(string oauth_name, string oauth_openid) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); Model.user_oauth model = new Model.user_oauth(); //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); foreach (PropertyInfo p in pros) { str1.Append(p.Name + ",");//拼接字段 } strSql.Append("select top 1 " + str1.ToString().Trim(',')); strSql.Append(" from " + databaseprefix + "user_oauth"); strSql.Append(" where oauth_name=@oauth_name and oauth_openid=@oauth_openid"); SqlParameter[] parameters = { new SqlParameter("@oauth_name", SqlDbType.NVarChar, 100), new SqlParameter("@oauth_openid", SqlDbType.NVarChar, 100) }; parameters[0].Value = oauth_name; parameters[1].Value = oauth_openid; DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_oauth model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_oauth("); strSql.Append("user_id,user_name,oauth_name,oauth_access_token,oauth_openid,add_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@oauth_name,@oauth_access_token,@oauth_openid,@add_time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int,4), new SqlParameter("@user_name", SqlDbType.NVarChar,100), new SqlParameter("@oauth_name", SqlDbType.NVarChar,50), new SqlParameter("@oauth_access_token", SqlDbType.NVarChar,500), new SqlParameter("@oauth_openid", SqlDbType.NVarChar,255), new SqlParameter("@add_time", SqlDbType.DateTime)}; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.oauth_name; parameters[3].Value = model.oauth_access_token; parameters[4].Value = model.oauth_openid; parameters[5].Value = model.add_time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return 0; } else { return Convert.ToInt32(obj); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_oauth model) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); List <SqlParameter> paras = new List <SqlParameter>(); strSql.Append("update " + databaseprefix + "user_oauth set "); foreach (PropertyInfo pi in pros) { //如果不是主键则追加sql字符串 if (!pi.Name.Equals("id")) { //判断属性值是否为空 if (pi.GetValue(model, null) != null) { str1.Append(pi.Name + "=@" + pi.Name + ","); //声明参数 paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值 } } } strSql.Append(str1.ToString().Trim(',')); strSql.Append(" where id=@id"); paras.Add(new SqlParameter("@id", model.id)); return(DbHelperSQL.ExecuteSql(strSql.ToString(), paras.ToArray()) > 0); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_oauth GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,oauth_name,oauth_access_token,oauth_openid,add_time from " + databaseprefix + "user_oauth "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.user_oauth model = new Model.user_oauth(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "") { model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString()); } if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "") { model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); } if (ds.Tables[0].Rows[0]["oauth_name"] != null && ds.Tables[0].Rows[0]["oauth_name"].ToString() != "") { model.oauth_name = ds.Tables[0].Rows[0]["oauth_name"].ToString(); } if (ds.Tables[0].Rows[0]["oauth_access_token"] != null && ds.Tables[0].Rows[0]["oauth_access_token"].ToString() != "") { model.oauth_access_token = ds.Tables[0].Rows[0]["oauth_access_token"].ToString(); } if (ds.Tables[0].Rows[0]["oauth_openid"] != null && ds.Tables[0].Rows[0]["oauth_openid"].ToString() != "") { model.oauth_openid = ds.Tables[0].Rows[0]["oauth_openid"].ToString(); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_oauth model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_oauth set "); strSql.Append("user_id=@user_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("oauth_name=@oauth_name,"); strSql.Append("oauth_access_token=@oauth_access_token,"); strSql.Append("oauth_openid=@oauth_openid,"); strSql.Append("add_time=@add_time,"); strSql.Append("naem=@naem,"); strSql.Append("Image=@Image,"); strSql.Append("gender=@gender"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@user_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@oauth_name", SqlDbType.NVarChar, 50), new SqlParameter("@oauth_access_token", SqlDbType.NVarChar, 500), new SqlParameter("@oauth_openid", SqlDbType.NVarChar, 255), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@naem", SqlDbType.NVarChar, 100), new SqlParameter("@Image", SqlDbType.NVarChar, 255), new SqlParameter("@gender", SqlDbType.NVarChar, 10), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.oauth_name; parameters[3].Value = model.oauth_access_token; parameters[4].Value = model.oauth_openid; parameters[5].Value = model.add_time; parameters[6].Value = model.naem; parameters[7].Value = model.Image; parameters[8].Value = model.gender; parameters[9].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_oauth DataRowToModel(DataRow row) { Model.user_oauth model = new Model.user_oauth(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["user_name"] != null) { model.user_name = row["user_name"].ToString(); } if (row["oauth_name"] != null) { model.oauth_name = row["oauth_name"].ToString(); } if (row["oauth_access_token"] != null) { model.oauth_access_token = row["oauth_access_token"].ToString(); } if (row["oauth_openid"] != null) { model.oauth_openid = row["oauth_openid"].ToString(); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = DateTime.Parse(row["add_time"].ToString()); } if (row["naem"] != null && row["naem"].ToString() != "") { model.naem = row["naem"].ToString(); } if (row["Image"] != null && row["Image"].ToString() != "") { model.Image = row["Image"].ToString(); } if (row["gender"] != null && row["gender"].ToString() != "") { model.gender = row["gender"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_oauth model) { int newId; using (OleDbConnection conn = new OleDbConnection(DbHelperOleDb.connectionString)) { conn.Open(); using (OleDbTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "user_oauth("); strSql.Append("user_id,user_name,oauth_name,oauth_access_token,oauth_openid,add_time)"); strSql.Append(" values ("); strSql.Append("@user_id,@user_name,@oauth_name,@oauth_access_token,@oauth_openid,@add_time)"); OleDbParameter[] parameters = { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@oauth_name", OleDbType.VarChar, 50), new OleDbParameter("@oauth_access_token", OleDbType.VarChar, 500), new OleDbParameter("@oauth_openid", OleDbType.VarChar, 255), new OleDbParameter("@add_time", OleDbType.Date) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.oauth_name; parameters[3].Value = model.oauth_access_token; parameters[4].Value = model.oauth_openid; parameters[5].Value = model.add_time; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(newId); }
/// <summary> /// 将对象转换实体 /// </summary> public Model.user_oauth DataRowToModel(DataRow row) { Model.user_oauth model = new Model.user_oauth(); if (row != null) { //利用反射获得属性的所有公共属性 Type modelType = model.GetType(); for (int i = 0; i < row.Table.Columns.Count; i++) { //查找实体是否存在列表相同的公共属性 PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName); if (proInfo != null && row[i] != DBNull.Value) { proInfo.SetValue(model, row[i], null);//用索引值设置属性值 } } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_oauth model) { StringBuilder strSql = new StringBuilder(); StringBuilder str1 = new StringBuilder(); //数据字段 StringBuilder str2 = new StringBuilder(); //数据参数 //利用反射获得属性的所有公共属性 PropertyInfo[] pros = model.GetType().GetProperties(); List <SqlParameter> paras = new List <SqlParameter>(); strSql.Append("insert into " + databaseprefix + "user_oauth("); foreach (PropertyInfo pi in pros) { //如果不是主键则追加sql字符串 if (!pi.Name.Equals("id")) { //判断属性值是否为空 if (pi.GetValue(model, null) != null) { str1.Append(pi.Name + ","); //拼接字段 str2.Append("@" + pi.Name + ","); //声明参数 paras.Add(new SqlParameter("@" + pi.Name, pi.GetValue(model, null))); //对参数赋值 } } } strSql.Append(str1.ToString().Trim(',')); strSql.Append(") values ("); strSql.Append(str2.ToString().Trim(',')); strSql.Append(") "); strSql.Append(";select @@IDENTITY;"); object obj = DbHelperSQL.GetSingle(strSql.ToString(), paras.ToArray()); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_oauth model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "user_oauth set "); strSql.Append("user_id=@user_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("oauth_name=@oauth_name,"); strSql.Append("oauth_access_token=@oauth_access_token,"); strSql.Append("oauth_openid=@oauth_openid,"); strSql.Append("add_time=@add_time"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@user_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@oauth_name", OleDbType.VarChar, 50), new OleDbParameter("@oauth_access_token", OleDbType.VarChar, 500), new OleDbParameter("@oauth_openid", OleDbType.VarChar, 255), new OleDbParameter("@add_time", OleDbType.Date), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.user_id; parameters[1].Value = model.user_name; parameters[2].Value = model.oauth_name; parameters[3].Value = model.oauth_access_token; parameters[4].Value = model.oauth_openid; parameters[5].Value = model.add_time; parameters[6].Value = model.id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.user_oauth DataRowToModel(DataRow row) { Model.user_oauth model = new Model.user_oauth(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["user_name"] != null) { model.user_name = row["user_name"].ToString(); } if (row["oauth_name"] != null) { model.oauth_name = row["oauth_name"].ToString(); } if (row["oauth_access_token"] != null) { model.oauth_access_token = row["oauth_access_token"].ToString(); } if (row["oauth_openid"] != null) { model.oauth_openid = row["oauth_openid"].ToString(); } if (row["add_time"] != null && row["add_time"].ToString() != "") { model.add_time = DateTime.Parse(row["add_time"].ToString()); } } return model; }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.user_oauth GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,oauth_name,oauth_access_token,oauth_openid,add_time from " + databaseprefix + "user_oauth "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.user_oauth model = new Model.user_oauth(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["user_id"] != null && ds.Tables[0].Rows[0]["user_id"].ToString() != "") { model.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString()); } if (ds.Tables[0].Rows[0]["user_name"] != null && ds.Tables[0].Rows[0]["user_name"].ToString() != "") { model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); } if (ds.Tables[0].Rows[0]["oauth_name"] != null && ds.Tables[0].Rows[0]["oauth_name"].ToString() != "") { model.oauth_name = ds.Tables[0].Rows[0]["oauth_name"].ToString(); } if (ds.Tables[0].Rows[0]["oauth_access_token"] != null && ds.Tables[0].Rows[0]["oauth_access_token"].ToString() != "") { model.oauth_access_token = ds.Tables[0].Rows[0]["oauth_access_token"].ToString(); } if (ds.Tables[0].Rows[0]["oauth_openid"] != null && ds.Tables[0].Rows[0]["oauth_openid"].ToString() != "") { model.oauth_openid = ds.Tables[0].Rows[0]["oauth_openid"].ToString(); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } return model; } else { return null; } }
private void user_oauth_bind(HttpContext context) { //检查URL参数 if (context.Session["oauth_name"] == null) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:授权参数不正确!\"}"); return; } //获取授权信息 string result = Vincent._DTcms.Utils.UrlExecute(siteConfig.webpath + "api/oauth/" + context.Session["oauth_name"].ToString() + "/result_json.aspx"); if (result.Contains("error")) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:请检查URL是否正确!\"}"); return; } //反序列化JSON Dictionary <string, object> dic = JsonMapper.ToObject <Dictionary <string, object> >(result); if (dic["ret"].ToString() != "0") { context.Response.Write("{\"status\": 0, \"msg\": \"错误代码:" + dic["ret"] + ",描述:" + dic["msg"] + "\"}"); return; } //检查用户名密码 string username = Vincent._DTcms.DTRequest.GetString("txtUserName"); string password = Vincent._DTcms.DTRequest.GetString("txtPassword"); if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { context.Response.Write("{\"status\": 0, \"msg\": \"温馨提示:请输入用户名或密码!\"}"); return; } BLL.users bll = new BLL.users(); Model.users model = bll.GetModel(username, password, userConfig.emaillogin, userConfig.mobilelogin, true); if (model == null) { context.Response.Write("{\"status\":0, \"msg\":\"错误提示:用户名或密码错误!\"}"); return; } //开始绑定 Model.user_oauth oauthModel = new Model.user_oauth(); oauthModel.oauth_name = dic["oauth_name"].ToString(); oauthModel.user_id = model.id; oauthModel.user_name = model.user_name; oauthModel.oauth_access_token = dic["oauth_access_token"].ToString(); oauthModel.oauth_openid = dic["oauth_openid"].ToString(); int newId = new BLL.user_oauth().Add(oauthModel); if (newId < 1) { context.Response.Write("{\"status\":0, \"msg\":\"错误提示:绑定过程中出错,请重新获取!\"}"); return; } context.Session[Vincent._DTcms.DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; //记住登录状态,防止Session提前过期 Vincent._DTcms.Utils.WriteCookie(Vincent._DTcms.DTKeys.COOKIE_USER_NAME_REMEMBER, "BuysingooShop", model.user_name); Vincent._DTcms.Utils.WriteCookie(Vincent._DTcms.DTKeys.COOKIE_USER_PWD_REMEMBER, "BuysingooShop", model.password); //写入登录日志 new BLL.user_login_log().Add(model.id, model.user_name, "会员登录"); //返回URL context.Response.Write("{\"status\":1, \"msg\":\"会员登录成功!\"}"); return; }
private void user_oauth_register(HttpContext context) { //检查URL参数 if (context.Session["oauth_name"] == null) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:授权参数不正确!\"}"); return; } //获取授权信息 string result = Vincent._DTcms.Utils.UrlExecute(siteConfig.webpath + "api/oauth/" + context.Session["oauth_name"].ToString() + "/result_json.aspx"); if (result.Contains("error")) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:请检查URL是否正确!\"}"); return; } //反序列化JSON Dictionary <string, object> dic = JsonMapper.ToObject <Dictionary <string, object> >(result); if (dic["ret"].ToString() != "0") { context.Response.Write("{\"status\": 0, \"msg\": \"错误代码:" + dic["ret"] + "," + dic["msg"] + "\"}"); return; } string password = Vincent._DTcms.DTRequest.GetFormString("txtPassword").Trim(); string email = Vincent._DTcms.Utils.ToHtml(Vincent._DTcms.DTRequest.GetFormString("txtEmail").Trim()); string mobile = Vincent._DTcms.Utils.ToHtml(Vincent._DTcms.DTRequest.GetFormString("txtMobile").Trim()); string userip = Vincent._DTcms.DTRequest.GetIP(); BLL.users bll = new BLL.users(); Model.users model = new Model.users(); //检查默认组别是否存在 Model.user_groups modelGroup = new BLL.user_groups().GetDefault(); if (modelGroup == null) { context.Response.Write("{\"status\":0, \"msg\":\"用户尚未分组,请联系管理员!\"}"); return; } //保存注册信息 model.group_id = modelGroup.id; model.user_name = bll.GetRandomName(10); //随机用户名 model.salt = Vincent._DTcms.Utils.GetCheckCode(6); //获得6位的salt加密字符串 model.password = _DESEncrypt.Encrypt(password, model.salt); model.email = email; model.mobile = mobile; if (!string.IsNullOrEmpty(dic["nick"].ToString())) { model.nick_name = dic["nick"].ToString(); } if (dic["avatar"].ToString().StartsWith("http://")) { model.avatar = dic["avatar"].ToString(); } if (!string.IsNullOrEmpty(dic["sex"].ToString())) { model.sex = dic["sex"].ToString(); } if (!string.IsNullOrEmpty(dic["birthday"].ToString())) { model.birthday = Vincent._DTcms.Utils.StrToDateTime(dic["birthday"].ToString()); } model.reg_ip = userip; model.reg_time = DateTime.Now; model.status = 0; //设置为正常状态 int newId = bll.Add(model); if (newId < 1) { context.Response.Write("{\"status\":0, \"msg\":\"注册失败,请联系网站管理员!\"}"); return; } model = bll.GetModel(newId); //赠送积分金额 if (modelGroup.point > 0) { new BLL.user_point_log().Add(model.id, model.user_name, modelGroup.point, "注册赠送积分", false); } if (modelGroup.amount > 0) { new BLL.user_amount_log().Add(model.id, model.user_name, Vincent._DTcms.DTEnums.AmountTypeEnum.SysGive.ToString(), modelGroup.amount, "注册赠送金额", 1); } //判断是否发送欢迎消息 if (userConfig.regmsgstatus == 1) //站内短消息 { new BLL.user_message().Add(1, "", model.user_name, "欢迎您成为本站会员", userConfig.regmsgtxt); } else if (userConfig.regmsgstatus == 2) //发送邮件 { //取得邮件模板内容 Model.mail_template mailModel = new BLL.mail_template().GetModel("welcomemsg"); if (mailModel != null) { //替换标签 string mailTitle = mailModel.maill_title; mailTitle = mailTitle.Replace("{username}", model.user_name); string mailContent = mailModel.content; mailContent = mailContent.Replace("{webname}", siteConfig.webname); mailContent = mailContent.Replace("{weburl}", siteConfig.weburl); mailContent = mailContent.Replace("{webtel}", siteConfig.webtel); mailContent = mailContent.Replace("{username}", model.user_name); //发送邮件 _Email.SendMail(siteConfig.emailsmtp, siteConfig.emailusername, siteConfig.emailpassword, siteConfig.emailnickname, siteConfig.emailfrom, model.email, mailTitle, mailContent); } } else if (userConfig.regmsgstatus == 3 && mobile != "") //发送短信 { Model.sms_template smsModel = new BLL.sms_template().GetModel("welcomemsg"); //取得短信内容 if (smsModel != null) { //替换标签 string msgContent = smsModel.content; msgContent = msgContent.Replace("{webname}", siteConfig.webname); msgContent = msgContent.Replace("{weburl}", siteConfig.weburl); msgContent = msgContent.Replace("{webtel}", siteConfig.webtel); msgContent = msgContent.Replace("{username}", model.user_name); //发送短信 string tipMsg = string.Empty; new BLL.sms_message().Send(model.mobile, msgContent, 2, out tipMsg); } } //绑定到对应的授权类型 Model.user_oauth oauthModel = new Model.user_oauth(); oauthModel.oauth_name = dic["oauth_name"].ToString(); oauthModel.user_id = model.id; oauthModel.user_name = model.user_name; oauthModel.oauth_access_token = dic["oauth_access_token"].ToString(); oauthModel.oauth_openid = dic["oauth_openid"].ToString(); new BLL.user_oauth().Add(oauthModel); context.Session[Vincent._DTcms.DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; //记住登录状态,防止Session提前过期 Vincent._DTcms.Utils.WriteCookie(Vincent._DTcms.DTKeys.COOKIE_USER_NAME_REMEMBER, "BuysingooShop", model.user_name); Vincent._DTcms.Utils.WriteCookie(Vincent._DTcms.DTKeys.COOKIE_USER_PWD_REMEMBER, "BuysingooShop", model.password); //写入登录日志 new BLL.user_login_log().Add(model.id, model.user_name, "会员登录"); //返回URL context.Response.Write("{\"status\":1, \"msg\":\"会员登录成功!\"}"); return; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.user_oauth model) { return(dal.Update(model)); }
private void user_oauth_bind(HttpContext context) { //检查URL参数 if (context.Session["oauth_name"] == null) { context.Response.Write("{\"msg\": 0, \"msgbox\": \"错误提示:授权参数不正确!\"}"); return; } //获取授权信息 string result = Utils.UrlExecute(siteConfig.webpath + "api/oauth/" + context.Session["oauth_name"].ToString() + "/result_json.aspx"); if (result.Contains("error")) { context.Response.Write("{\"msg\": 0, \"msgbox\": \"错误提示:请检查URL是否正确!\"}"); return; } //反序列化JSON Dictionary<string, object> dic = JsonMapper.ToObject<Dictionary<string, object>>(result); if (dic["ret"].ToString() != "0") { context.Response.Write("{\"msg\": 0, \"msgbox\": \"错误代码:" + dic["ret"] + ",描述:" + dic["msg"] + "\"}"); return; } //检查用户名密码 string username = DTRequest.GetString("txtUserName"); string password = DTRequest.GetString("txtPassword"); if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { context.Response.Write("{\"msg\": 0, \"msgbox\": \"温馨提示:请输入用户名或密码!\"}"); return; } BLL.users bll = new BLL.users(); Model.users model = bll.GetModel(username, DESEncrypt.Encrypt(password), userConfig.emaillogin); if (model == null) { context.Response.Write("{\"msg\":0, \"msgbox\":\"错误提示:用户名或密码错误,请重试!\"}"); return; } //开始绑定 Model.user_oauth oauthModel = new Model.user_oauth(); oauthModel.oauth_name = dic["oauth_name"].ToString(); oauthModel.user_id = model.id; oauthModel.user_name = model.user_name; oauthModel.oauth_access_token = dic["oauth_access_token"].ToString(); oauthModel.oauth_openid = dic["oauth_openid"].ToString(); int newId = new BLL.user_oauth().Add(oauthModel); if (newId < 1) { context.Response.Write("{\"msg\":0, \"msgbox\":\"错误提示:绑定过程中出现错误,请重新登录授权!\"}"); return; } context.Session[DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; //记住登录状态,防止Session提前过期 Utils.WriteCookie(DTKeys.COOKIE_USER_NAME_REMEMBER, "DTcms", model.user_name); Utils.WriteCookie(DTKeys.COOKIE_USER_PWD_REMEMBER, "DTcms", model.password); //写入登录日志 new BLL.user_login_log().Add(model.id, model.user_name, "会员登录", DTRequest.GetIP()); //返回URL context.Response.Write("{\"msg\":1, \"msgbox\":\"会员登录成功!\"}"); return; }
private void user_oauth_register(HttpContext context) { //检查URL参数 if (context.Session["oauth_name"] == null) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:授权参数不正确!\"}"); return; } //获取授权信息 string result = Utils.UrlExecute(siteConfig.webpath + "api/oauth/" + context.Session["oauth_name"].ToString() + "/result_json.aspx"); if (result.Contains("error")) { context.Response.Write("{\"status\": 0, \"msg\": \"错误提示:请检查URL是否正确!\"}"); return; } string password = DTRequest.GetFormString("txtPassword").Trim(); string email = Utils.ToHtml(DTRequest.GetFormString("txtEmail").Trim()); string mobile = Utils.ToHtml(DTRequest.GetFormString("txtMobile").Trim()); string userip = DTRequest.GetIP(); //反序列化JSON Dictionary<string, object> dic = JsonHelper.DataRowFromJSON(result); if (dic["ret"].ToString() != "0") { context.Response.Write("{\"status\": 0, \"msg\": \"错误代码:" + dic["ret"] + "," + dic["msg"] + "\"}"); return; } BLL.users bll = new BLL.users(); Model.users model = new Model.users(); //如果开启手机登录要验证手机 if (userConfig.mobilelogin == 1 && !string.IsNullOrEmpty(mobile)) { if (bll.ExistsMobile(mobile)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,该手机号码已被使用!\"}"); return; } } //如果开启邮箱登录要验证邮箱 if (userConfig.emaillogin == 1 && !string.IsNullOrEmpty(email)) { if (bll.ExistsEmail(email)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,该电子邮箱已被使用!\"}"); return; } } //检查默认组别是否存在 Model.user_groups modelGroup = new BLL.user_groups().GetDefault(); if (modelGroup == null) { context.Response.Write("{\"status\":0, \"msg\":\"用户尚未分组,请联系管理员!\"}"); return; } //保存注册信息 model.group_id = modelGroup.id; model.user_name = bll.GetRandomName(10); //随机用户名 model.salt = Utils.GetCheckCode(6); //获得6位的salt加密字符串 model.password = DESEncrypt.Encrypt(password, model.salt); model.email = email; model.mobile = mobile; if (!string.IsNullOrEmpty(dic["nick"].ToString())) { model.nick_name = dic["nick"].ToString(); } if (dic["avatar"].ToString().StartsWith("http://")) { model.avatar = dic["avatar"].ToString(); } if (!string.IsNullOrEmpty(dic["sex"].ToString())) { model.sex = dic["sex"].ToString(); } if (!string.IsNullOrEmpty(dic["birthday"].ToString())) { model.birthday = Utils.StrToDateTime(dic["birthday"].ToString()); } model.reg_ip = userip; model.reg_time = DateTime.Now; model.status = 0; //设置为正常状态 model.id = bll.Add(model); //保存数据 if (model.id < 1) { context.Response.Write("{\"status\":0, \"msg\":\"注册失败,请联系网站管理员!\"}"); return; } //赠送积分金额 if (modelGroup.point > 0) { new BLL.user_point_log().Add(model.id, model.user_name, modelGroup.point, "注册赠送积分", false); } if (modelGroup.amount > 0) { new BLL.user_amount_log().Add(model.id, model.user_name, modelGroup.amount, "注册赠送金额"); } //判断是否发送欢迎消息 if (userConfig.regmsgstatus == 1) //站内短消息 { new BLL.user_message().Add(1, "", model.user_name, "欢迎您成为本站会员", userConfig.regmsgtxt); } else if (userConfig.regmsgstatus == 2) //发送邮件 { //取得邮件模板内容 Model.mail_template mailModel = new BLL.mail_template().GetModel("welcomemsg"); if (mailModel != null) { //替换标签 string mailTitle = mailModel.maill_title; mailTitle = mailTitle.Replace("{username}", model.user_name); string mailContent = mailModel.content; mailContent = mailContent.Replace("{webname}", siteConfig.webname); mailContent = mailContent.Replace("{weburl}", siteConfig.weburl); mailContent = mailContent.Replace("{webtel}", siteConfig.webtel); mailContent = mailContent.Replace("{username}", model.user_name); //发送邮件 DTMail.sendMail(siteConfig.emailsmtp, siteConfig.emailssl, siteConfig.emailusername, siteConfig.emailpassword, siteConfig.emailnickname, siteConfig.emailfrom, model.email, mailTitle, mailContent); } } else if (userConfig.regmsgstatus == 3 && mobile != "") //发送短信 { Model.sms_template smsModel = new BLL.sms_template().GetModel("welcomemsg"); //取得短信内容 if (smsModel != null) { //替换标签 string msgContent = smsModel.content; msgContent = msgContent.Replace("{webname}", siteConfig.webname); msgContent = msgContent.Replace("{weburl}", siteConfig.weburl); msgContent = msgContent.Replace("{webtel}", siteConfig.webtel); msgContent = msgContent.Replace("{username}", model.user_name); //发送短信 string tipMsg = string.Empty; new BLL.sms_message().Send(model.mobile, msgContent, 2, out tipMsg); } } //绑定到对应的授权类型 Model.user_oauth oauthModel = new Model.user_oauth(); oauthModel.oauth_name = dic["oauth_name"].ToString(); oauthModel.user_id = model.id; oauthModel.user_name = model.user_name; oauthModel.oauth_access_token = dic["oauth_access_token"].ToString(); oauthModel.oauth_openid = dic["oauth_openid"].ToString(); new BLL.user_oauth().Add(oauthModel); context.Session[DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; //记住登录状态,防止Session提前过期 Utils.WriteCookie(DTKeys.COOKIE_USER_NAME_REMEMBER, "DTcms", model.user_name); Utils.WriteCookie(DTKeys.COOKIE_USER_PWD_REMEMBER, "DTcms", model.password); //写入登录日志 new BLL.user_login_log().Add(model.id, model.user_name, "会员登录"); //返回URL context.Response.Write("{\"status\":1, \"msg\":\"会员登录成功!\"}"); return; }
private void user_oauth_register(HttpContext context) { //检查URL参数 if (context.Session["oauth_name"] == null) { context.Response.Write("{\"msg\": 0, \"msgbox\": \"错误提示:授权参数不正确!\"}"); return; } //获取授权信息 string result = Utils.UrlExecute(siteConfig.webpath + "api/oauth/" + context.Session["oauth_name"].ToString() + "/result_json.aspx"); if (result.Contains("error")) { context.Response.Write("{\"msg\": 0, \"msgbox\": \"错误提示:请检查URL是否正确!\"}"); return; } //反序列化JSON Dictionary<string, object> dic = JsonMapper.ToObject<Dictionary<string, object>>(result); if (dic["ret"].ToString() != "0") { context.Response.Write("{\"msg\": 0, \"msgbox\": \"错误代码:" + dic["ret"] + "," + dic["msg"] + "\"}"); return; } string password = DTRequest.GetFormString("txtPassword").Trim(); string email = DTRequest.GetFormString("txtEmail").Trim(); string userip = DTRequest.GetIP(); //检查用户名 BLL.users bll = new BLL.users(); Model.users model = new Model.users(); //检查默认组别是否存在 Model.user_groups modelGroup = new BLL.user_groups().GetDefault(); if (modelGroup == null) { context.Response.Write("{\"msg\":0, \"msgbox\":\"系统尚未分组,请联系管理员设置会员分组!\"}"); return; } //保存注册信息 model.group_id = modelGroup.id; model.user_name = bll.GetRandomName(10); model.password = DESEncrypt.Encrypt(password); model.email = email; if (!string.IsNullOrEmpty(dic["nick"].ToString())) { model.nick_name = dic["nick"].ToString(); } if (dic["avatar"].ToString().StartsWith("http://")) { model.avatar = dic["avatar"].ToString(); } if (!string.IsNullOrEmpty(dic["sex"].ToString())) { model.sex = dic["sex"].ToString(); } if (!string.IsNullOrEmpty(dic["birthday"].ToString())) { model.birthday = DateTime.Parse(dic["birthday"].ToString()); } model.reg_ip = userip; model.reg_time = DateTime.Now; model.is_lock = 0; //设置为对应状态 int newId = bll.Add(model); if (newId < 1) { context.Response.Write("{\"msg\":0, \"msgbox\":\"系统故障,注册失败,请联系网站管理员!\"}"); return; } model = bll.GetModel(newId); //赠送积分金额 if (modelGroup.point > 0) { new BLL.point_log().Add(model.id, model.user_name, modelGroup.point, "注册赠送积分"); } if (modelGroup.amount > 0) { new BLL.amount_log().Add(model.id, model.user_name, DTEnums.AmountTypeEnum.SysGive.ToString(), modelGroup.amount, "注册赠送金额", 1); } //判断是否发送站内短消息 if (userConfig.regmsgstatus == 1) { new BLL.user_message().Add(1, "", model.user_name, "欢迎您成为本站会员", userConfig.regmsgtxt); } //绑定到对应的授权类型 Model.user_oauth oauthModel = new Model.user_oauth(); oauthModel.oauth_name = dic["oauth_name"].ToString(); oauthModel.user_id = model.id; oauthModel.user_name = model.user_name; oauthModel.oauth_access_token = dic["oauth_access_token"].ToString(); oauthModel.oauth_openid = dic["oauth_openid"].ToString(); new BLL.user_oauth().Add(oauthModel); context.Session[DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; //记住登录状态,防止Session提前过期 Utils.WriteCookie(DTKeys.COOKIE_USER_NAME_REMEMBER, "DTcms", model.user_name); Utils.WriteCookie(DTKeys.COOKIE_USER_PWD_REMEMBER, "DTcms", model.password); //写入登录日志 new BLL.user_login_log().Add(model.id, model.user_name, "会员登录", DTRequest.GetIP()); //返回URL context.Response.Write("{\"msg\":1, \"msgbox\":\"会员登录成功!\"}"); return; }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.user_oauth model) { return(dal.Add(model)); }