private void ShowInfo(int _id) { BLL.orders bll = new BLL.orders(); model = bll.GetModel(_id); payModel = new BLL.payment().GetModel(model.payment_id); userModel = new BLL.users().GetModel(model.user_id); if (userModel != null) { groupModel = new BLL.user_groups().GetModel(userModel.group_id); } if (payModel == null) { payModel = new Model.payment(); } this.rptList.DataSource = model.order_goods; this.rptList.DataBind(); //订单状态 if (model.status == 1) { if (payModel != null && payModel.type == 1) { if (model.payment_status > 1) { this.lbtnConfirm.Enabled = true; } } else { this.lbtnConfirm.Enabled = true; } } else if (model.status == 2 && model.distribution_status == 1) { this.lbtnSend.Enabled = true; } else if (model.status == 2 && model.distribution_status == 2) { this.lbtnComplete.Enabled = true; } if (model.status < 3) { this.btnCancel.Visible = true; } //如果订单为已完成时,不能取消订单 if (model.status == 3) { this.btnInvalid.Visible = true; } }
/// <summary> /// 将在Init事件执行 /// </summary> protected void shopping_Init(object sender, EventArgs e) { int group_id = 0; userModel = GetUserInfo(); if (userModel != null) { group_id = userModel.group_id; } if (action == "confirm" && userModel == null) { //自动跳转URL HttpContext.Current.Response.Redirect(linkurl("login1", HttpContext.Current.Request.RawUrl)); } cartModel = Web.UI.ShopCart.GetTotal(group_id); }
/// <summary> /// OnInit事件,检查用户是否登录 /// </summary> void UserPage_Init(object sender, EventArgs e) { if (!IsUserLogin()) { //跳转URL HttpContext.Current.Response.Redirect(linkurl("login")); return; } //获得登录用户信息 userModel = GetUserInfo(); groupModel = new BLL.user_groups().GetModel(userModel.group_id); if (groupModel == null) { groupModel = new Model.user_groups(); } InitPage(); }
private bool DoAdd() { bool result = false; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); model.group_id = int.Parse(ddlGroupId.SelectedValue); model.status = int.Parse(rblStatus.SelectedValue); //检测用户名是否重复 if (bll.Exists(txtUserName.Text.Trim())) { return false; } model.user_name = Utils.DropHTML(txtUserName.Text.Trim()); //获得6位的salt加密字符串 model.salt = Utils.GetCheckCode(6); //以随机生成的6位字符串做为密钥加密 model.password = DESEncrypt.Encrypt(txtPassword.Text.Trim(), model.salt); model.email = Utils.DropHTML(txtEmail.Text); model.nick_name = Utils.DropHTML(txtNickName.Text); model.avatar = Utils.DropHTML(txtAvatar.Text); model.sex = rblSex.SelectedValue; DateTime _birthday; if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) { model.birthday = _birthday; } model.telphone = Utils.DropHTML(txtTelphone.Text.Trim()); model.mobile = Utils.DropHTML(txtMobile.Text.Trim()); model.qq = Utils.DropHTML(txtQQ.Text); model.msn = Utils.DropHTML(txtMsn.Text); model.address = Utils.DropHTML(txtAddress.Text.Trim()); model.amount = decimal.Parse(txtAmount.Text.Trim()); model.point = int.Parse(txtPoint.Text.Trim()); model.exp = int.Parse(txtExp.Text.Trim()); model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加用户:" + model.user_name); //记录日志 result = true; } return result; }
private bool DoAdd() { bool result = true; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); model.group_id = int.Parse(ddlGroupId.SelectedValue); model.is_lock = int.Parse(rblIsLock.SelectedValue); int number = bll.GetOnlyCodeNumber(); model.user_name = "sxzh" + number.ToString();//txtUserName.Text.Trim(); model.password = DESEncrypt.Encrypt(txtPassword.Text); model.email = txtEmail.Text; model.nick_name = txtNickName.Text; model.avatar = txtAvatar.Text; model.sex = rblSex.SelectedValue; DateTime _birthday; if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) { model.birthday = _birthday; } model.telphone = txtTelphone.Text.Trim(); model.mobile = txtMobile.Text.Trim(); model.qq = txtQQ.Text; model.address = txtAddress.Text.Trim(); model.amount = decimal.Parse(txtAmount.Text.Trim()); model.point = int.Parse(txtPoint.Text.Trim()); model.exp = 0;// int.Parse(txtExp.Text.Trim()); model.reg_time = DateTime.Now; model.reg_equ = txtRegEqu.Text.Trim(); model.guid_card = txtGuidCard.Text.Trim(); model.card = txtCard.Text.Trim(); model.age = int.Parse(txtAge.Text.Trim()); model.work_type = int.Parse(rblWorkType.SelectedValue); model.description = Utils.ToHtml(txtContent.Text.Trim()); model.work_age = ddlWorkAge.SelectedValue.ToString(); if (bll.Add(model) < 1) { result = false; } return result; }
/// <summary> /// 将在Init事件执行 /// </summary> protected void shopping_Init(object sender, EventArgs e) { int group_id = 0; userModel = GetUserInfo(); if (userModel != null) { group_id = userModel.group_id; } if (action == "confirm" && userModel == null) { userModel = new Model.users(); if (orderConfig.anonymous == 0) { //自动跳转URL HttpContext.Current.Response.Redirect(linkurl("login")); } } cartModel = Web.UI.ShopCart.GetTotal(group_id); }
/// <summary> /// 将在Init事件执行 /// </summary> protected void shopping_Init(object sender, EventArgs e) { int group_id = 0; //会员组ID userModel = GetUserInfo(); //获取会员信息 if (userModel == null) { //如果不支持匿名购物则跳转到登录页面 if (orderConfig.anonymous == 0) { HttpContext.Current.Response.Redirect(linkurl("login")); //自动跳转URL } } else { group_id = userModel.group_id; } //获取商品列表 if (string.IsNullOrEmpty(goodsJsonValue)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("对不起,无法获取您要购买的商品!"))); return; } try { List<Model.cart_keys> ls = (List<Model.cart_keys>)JsonHelper.JSONToObject<List<Model.cart_keys>>(goodsJsonValue); goodsList = ShopCart.ToList(ls, group_id); //商品列表 goodsTotal = ShopCart.GetTotal(goodsList); //商品统计 } catch { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("对不起,商品的传输参数有误!"))); return; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users model) { return(dal.Update(model)); }
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; }
/// <summary> /// 发送短信修改密码 /// </summary> private void user_changepassword(HttpContext context) { string outmsg = "{\"status\":0, \"msg\":\"获取失败,请重新获取!\"}"; var mobile = _Request.GetString("mobile", ""); users bll = new users(); if (!bll.ExistsMobile(mobile)) { HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write("{\"status\":0, \"msg\":\"手机号不存在!\"}"); HttpContext.Current.Response.End(); return; } //生成密码 Random ro = new Random(); var no = ro.Next(100000, 999999); //随机一个数 string password = no.ToString(); Model.users model = bll.GetModelMobile(mobile); //写短信数据,发SMS var message_name = _Utility.GetConfigAppSetting("message_name"); var message_pwd = _Utility.GetConfigAppSetting("message_pwd"); var message_content = _Utility.GetConfigAppSetting("message_changepassword"); message_content = message_content.Replace("num", password); message_content = message_content.Replace("username", model.user_name); /* * >0 成功,系统生成的任务编号,long类型 * 0 失败 * -1 用户名或者密码不正确 * -2 必填选项为空 * -3 短信内容0个字节 * -4 0个有效号码 * -5 余额不够 * -6 含有一级敏感词 * -7 含有二级敏感词,人工审核 * -8 提交频率太快,退避重发 * -9 数据格式错误 * -10 用户被禁用 * -11 短信内容过长 * */ var MessageNum = Vincent._MobileMessage.SendMessageCode(message_content, mobile); Model.userconfig userConfig = new BLL.userconfig().loadConfig(); if (MessageNum > 0) { outmsg = "{\"status\":1, \"msg\":\"修改成功,稍后请注意查收您的短信!\"}"; } else { //记录日志 //_Log.SaveMessage("手机:" + mobile + ",原因:" + AppCode.Utility.NumToMsg(MessageNum)); } //注:如果以上都处理成功,返回"Y",处理失败,返回"N" HttpContext.Current.Response.Clear(); HttpContext.Current.Response.Write(outmsg); HttpContext.Current.Response.End(); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,isVip,group_id,user_name,password,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,is_lock,reg_time,endTime,reg_ip,dianming,dianmiaoshu,congye,gongsi,fuwuquyu,shuxishequ,fuwutechang,jingli,zhengshu,note,isDonePoints,isHirePoints,isAd,isMac from dt_users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.users model = new Model.users(); 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]["group_id"] != null && ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_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]["password"] != null && ds.Tables[0].Rows[0]["password"].ToString() != "") { model.password = ds.Tables[0].Rows[0]["password"].ToString(); } if (ds.Tables[0].Rows[0]["email"] != null && ds.Tables[0].Rows[0]["email"].ToString() != "") { model.email = ds.Tables[0].Rows[0]["email"].ToString(); } if (ds.Tables[0].Rows[0]["nick_name"] != null && ds.Tables[0].Rows[0]["nick_name"].ToString() != "") { model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); } if (ds.Tables[0].Rows[0]["avatar"] != null && ds.Tables[0].Rows[0]["avatar"].ToString() != "") { model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); } if (ds.Tables[0].Rows[0]["sex"] != null && ds.Tables[0].Rows[0]["sex"].ToString() != "") { model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); } if (ds.Tables[0].Rows[0]["birthday"] != null && ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } if (ds.Tables[0].Rows[0]["telphone"] != null && ds.Tables[0].Rows[0]["telphone"].ToString() != "") { model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); } if (ds.Tables[0].Rows[0]["mobile"] != null && ds.Tables[0].Rows[0]["mobile"].ToString() != "") { model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); } if (ds.Tables[0].Rows[0]["qq"] != null && ds.Tables[0].Rows[0]["qq"].ToString() != "") { model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); } if (ds.Tables[0].Rows[0]["address"] != null && ds.Tables[0].Rows[0]["address"].ToString() != "") { model.address = ds.Tables[0].Rows[0]["address"].ToString(); } if (ds.Tables[0].Rows[0]["safe_question"] != null && ds.Tables[0].Rows[0]["safe_question"].ToString() != "") { model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); } if (ds.Tables[0].Rows[0]["safe_answer"] != null && ds.Tables[0].Rows[0]["safe_answer"].ToString() != "") { model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); } if (ds.Tables[0].Rows[0]["amount"] != null && ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"] != null && ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"] != null && ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["isDonePoints"] != null && ds.Tables[0].Rows[0]["isDonePoints"].ToString() != "") { model.isDonePoints = int.Parse(ds.Tables[0].Rows[0]["isDonePoints"].ToString()); } if (ds.Tables[0].Rows[0]["isHirePoints"] != null && ds.Tables[0].Rows[0]["isHirePoints"].ToString() != "") { model.isHirePoints = int.Parse(ds.Tables[0].Rows[0]["isHirePoints"].ToString()); } if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "") { model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString()); } if (ds.Tables[0].Rows[0]["isVip"] != null && ds.Tables[0].Rows[0]["isVip"].ToString() != "") { model.isVip = int.Parse(ds.Tables[0].Rows[0]["isVip"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"] != null && ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } if (ds.Tables[0].Rows[0]["endTime"] != null && ds.Tables[0].Rows[0]["endTime"].ToString() != "") { model.endtime = DateTime.Parse(ds.Tables[0].Rows[0]["endTime"].ToString()); } if (ds.Tables[0].Rows[0]["reg_ip"] != null && ds.Tables[0].Rows[0]["reg_ip"].ToString() != "") { model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); } if (ds.Tables[0].Rows[0]["dianming"] != null && ds.Tables[0].Rows[0]["dianming"].ToString() != "") { model.dianming = ds.Tables[0].Rows[0]["dianming"].ToString(); } if (ds.Tables[0].Rows[0]["dianmiaoshu"] != null && ds.Tables[0].Rows[0]["dianmiaoshu"].ToString() != "") { model.dianmiaoshu = ds.Tables[0].Rows[0]["dianmiaoshu"].ToString(); } if (ds.Tables[0].Rows[0]["congye"] != null && ds.Tables[0].Rows[0]["congye"].ToString() != "") { model.congye = ds.Tables[0].Rows[0]["congye"].ToString(); } if (ds.Tables[0].Rows[0]["gongsi"] != null && ds.Tables[0].Rows[0]["gongsi"].ToString() != "") { model.gongsi = ds.Tables[0].Rows[0]["gongsi"].ToString(); } if (ds.Tables[0].Rows[0]["fuwuquyu"] != null && ds.Tables[0].Rows[0]["fuwuquyu"].ToString() != "") { model.fuwuquyu = ds.Tables[0].Rows[0]["fuwuquyu"].ToString(); } if (ds.Tables[0].Rows[0]["shuxishequ"] != null && ds.Tables[0].Rows[0]["shuxishequ"].ToString() != "") { model.shuxishequ = ds.Tables[0].Rows[0]["shuxishequ"].ToString(); } if (ds.Tables[0].Rows[0]["fuwutechang"] != null && ds.Tables[0].Rows[0]["fuwutechang"].ToString() != "") { model.fuwutechang = ds.Tables[0].Rows[0]["fuwutechang"].ToString(); } if (ds.Tables[0].Rows[0]["jingli"] != null && ds.Tables[0].Rows[0]["jingli"].ToString() != "") { model.jingli = ds.Tables[0].Rows[0]["jingli"].ToString(); } if (ds.Tables[0].Rows[0]["zhengshu"] != null && ds.Tables[0].Rows[0]["zhengshu"].ToString() != "") { model.zhengshu = ds.Tables[0].Rows[0]["zhengshu"].ToString(); } if (ds.Tables[0].Rows[0]["note"] != null && ds.Tables[0].Rows[0]["note"].ToString() != "") { model.note = ds.Tables[0].Rows[0]["note"].ToString(); } if (ds.Tables[0].Rows[0]["isAd"] != null && ds.Tables[0].Rows[0]["isAd"].ToString() != "") { model.isAd = int.Parse(ds.Tables[0].Rows[0]["isAd"].ToString()); } if (ds.Tables[0].Rows[0]["isMac"] != null && ds.Tables[0].Rows[0]["isMac"].ToString() != "") { model.isMac = int.Parse(ds.Tables[0].Rows[0]["isMac"].ToString()); } return(model); } else { return(null); } }
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; }
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; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "users set "); strSql.Append("group_id=@group_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("salt=@salt,"); strSql.Append("[password]=@password,"); strSql.Append("mobile=@mobile,"); strSql.Append("email=@email,"); strSql.Append("avatar=@avatar,"); strSql.Append("nick_name=@nick_name,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("telphone=@telphone,"); strSql.Append("area=@area,"); strSql.Append("address=@address,"); strSql.Append("qq=@qq,"); strSql.Append("msn=@msn,"); strSql.Append("amount=@amount,"); strSql.Append("point=@point,"); strSql.Append("exp=@exp,"); strSql.Append("status=@status,"); strSql.Append("reg_time=@reg_time,"); strSql.Append("reg_ip=@reg_ip"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@group_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@salt", OleDbType.VarChar, 20), new OleDbParameter("@password", OleDbType.VarChar, 100), new OleDbParameter("@mobile", OleDbType.VarChar, 20), new OleDbParameter("@email", OleDbType.VarChar, 50), new OleDbParameter("@avatar", OleDbType.VarChar, 255), new OleDbParameter("@nick_name", OleDbType.VarChar, 100), new OleDbParameter("@sex", OleDbType.VarChar, 20), new OleDbParameter("@birthday", OleDbType.Date), new OleDbParameter("@telphone", OleDbType.VarChar, 50), new OleDbParameter("@area", OleDbType.VarChar, 255), new OleDbParameter("@address", OleDbType.VarChar, 255), new OleDbParameter("@qq", OleDbType.VarChar, 20), new OleDbParameter("@msn", OleDbType.VarChar, 100), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@point", OleDbType.Integer, 4), new OleDbParameter("@exp", OleDbType.Integer, 4), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@reg_time", OleDbType.Date), new OleDbParameter("@reg_ip", OleDbType.VarChar, 20), new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.salt; parameters[3].Value = model.password; parameters[4].Value = model.mobile; parameters[5].Value = model.email; parameters[6].Value = model.avatar; parameters[7].Value = model.nick_name; parameters[8].Value = model.sex; if (model.birthday != null) { parameters[9].Value = model.birthday; } else { parameters[9].Value = DBNull.Value; } parameters[10].Value = model.telphone; parameters[11].Value = model.area; parameters[12].Value = model.address; parameters[13].Value = model.qq; parameters[14].Value = model.msn; parameters[15].Value = model.amount; parameters[16].Value = model.point; parameters[17].Value = model.exp; parameters[18].Value = model.status; parameters[19].Value = model.reg_time; parameters[20].Value = model.reg_ip; parameters[21].Value = model.id; int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,group_id,user_name,password,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,is_lock,reg_time,reg_ip from dt_users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.users model = new Model.users(); 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]["group_id"] != null && ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_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]["password"] != null && ds.Tables[0].Rows[0]["password"].ToString() != "") { model.password = ds.Tables[0].Rows[0]["password"].ToString(); } if (ds.Tables[0].Rows[0]["email"] != null && ds.Tables[0].Rows[0]["email"].ToString() != "") { model.email = ds.Tables[0].Rows[0]["email"].ToString(); } if (ds.Tables[0].Rows[0]["nick_name"] != null && ds.Tables[0].Rows[0]["nick_name"].ToString() != "") { model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); } if (ds.Tables[0].Rows[0]["avatar"] != null && ds.Tables[0].Rows[0]["avatar"].ToString() != "") { model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); } if (ds.Tables[0].Rows[0]["sex"] != null && ds.Tables[0].Rows[0]["sex"].ToString() != "") { model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); } if (ds.Tables[0].Rows[0]["birthday"] != null && ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } if (ds.Tables[0].Rows[0]["telphone"] != null && ds.Tables[0].Rows[0]["telphone"].ToString() != "") { model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); } if (ds.Tables[0].Rows[0]["mobile"] != null && ds.Tables[0].Rows[0]["mobile"].ToString() != "") { model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); } if (ds.Tables[0].Rows[0]["qq"] != null && ds.Tables[0].Rows[0]["qq"].ToString() != "") { model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); } if (ds.Tables[0].Rows[0]["address"] != null && ds.Tables[0].Rows[0]["address"].ToString() != "") { model.address = ds.Tables[0].Rows[0]["address"].ToString(); } if (ds.Tables[0].Rows[0]["safe_question"] != null && ds.Tables[0].Rows[0]["safe_question"].ToString() != "") { model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); } if (ds.Tables[0].Rows[0]["safe_answer"] != null && ds.Tables[0].Rows[0]["safe_answer"].ToString() != "") { model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); } if (ds.Tables[0].Rows[0]["amount"] != null && ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"] != null && ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"] != null && ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["is_lock"] != null && ds.Tables[0].Rows[0]["is_lock"].ToString() != "") { model.is_lock = int.Parse(ds.Tables[0].Rows[0]["is_lock"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"] != null && ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } if (ds.Tables[0].Rows[0]["reg_ip"] != null && ds.Tables[0].Rows[0]["reg_ip"].ToString() != "") { model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); } return model; } else { return null; } }
protected void Page_Load(object sender, EventArgs e) { string url = ""; string mid = "1038690"; string MerchantID = Request["MerchantID"]; string MerchantTradeNo = Request["MerchantTradeNo"]; string PaymentDate = Request["PaymentDate"]; string PaymentType = Request["PaymentType"]; string PaymentTypeChargeFee = Request["PaymentTypeChargeFee"]; string RtnCode = Request["RtnCode"]; string RtnMsg = Request["RtnMsg"]; string SimulatePaid = Request["SimulatePaid"]; string TradeAmt = Request["TradeAmt"]; string TradeDate = Request["TradeDate"]; string TradeNo = Request["TradeNo"]; string CheckMacValue = Request["CheckMacValue"]; StringBuilder sb = new StringBuilder(); sb.Append("HashKey=7RswcwBgLcqnMjy5"); sb.Append("&MerchantID=" + Request["MerchantID"] + ""); sb.Append("&MerchantTradeNo=" + Request["MerchantTradeNo"] + ""); sb.Append("&PaymentDate=" + Request["PaymentDate"] + ""); sb.Append("&PaymentType=" + Request["PaymentType"] + ""); sb.Append("&PaymentTypeChargeFee=" + Request["PaymentTypeChargeFee"] + ""); sb.Append("&RtnCode=" + Request["RtnCode"] + ""); sb.Append("&RtnMsg=" + Request["RtnMsg"] + ""); sb.Append("&SimulatePaid=" + Request["SimulatePaid"] + ""); sb.Append("&TradeAmt=" + Request["TradeAmt"] + ""); sb.Append("&TradeDate=" + Request["TradeDate"] + ""); sb.Append("&TradeNo=" + Request["TradeNo"] + ""); sb.Append("&HashIV=IA0pz3lNuyui52iZ"); url = sb.ToString(); url = getstr(url).ToLower(); string CMValue = DTcms.BLL.Function.Instance.MD5(url, 32); // Response.Write(CMValue); // Response.End(); // && CheckMacValue == CMValue if (MerchantID == mid && RtnCode == "1" && !string.IsNullOrEmpty(MerchantTradeNo) && CheckMacValue == CMValue) { int Uid = WEBUserCurrent.UserID; BLL.users bllUser = new BLL.users(); int bk = bllUser.UpFee(Uid, 1); if (bk > 0) { Model.users User = new Model.users(); User = bllUser.GetModel(Uid); if (User != null) { int point = 0; int Groupid = User.group_id; string Introduce_UserName = User.dianming; if (Session["GroupName"] != null && Session["Type"] != null) { string type = Session["Type"].ToString(); Groupid = Utils.StringToNum(Session["GroupName"].ToString()); bllUser.UpdateField(Uid, " group_id=" + Groupid + " ,endTime=" + User.endtime.AddYears(2) + " "); } switch (Groupid) { case 1: point = 0; bllUser.UpPoint(Introduce_UserName, point); break; case 2: point = 50; bllUser.UpPoint(Introduce_UserName, point); break; case 3: point = 100; bllUser.UpPoint(Introduce_UserName, point); break; case 4: point = 150; bllUser.UpPoint(Introduce_UserName, point); break; } } Response.Write("1|OK"); Response.End(); } else { Response.Write("0|ErrorMessage"); Response.End(); } } else { Response.Write("0|ErrorMessage"); Response.End(); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //获取用户旧数据 Model.users model = GetModel(id); if (model == null) { return(false); } Hashtable sqllist = new Hashtable(); //删除积分记录 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "user_point_log "); strSql1.Append(" where user_id=@id"); MySqlParameter[] parameters1 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters1[0].Value = id; sqllist.Add(strSql1.ToString(), parameters1); //删除金额记录 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "user_amount_log "); strSql2.Append(" where user_id=@id"); MySqlParameter[] parameters2 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters2[0].Value = id; sqllist.Add(strSql2.ToString(), parameters2); //删除附件购买记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "user_attach_log"); strSql3.Append(" where user_id=@id"); MySqlParameter[] parameters3 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters3[0].Value = id; sqllist.Add(strSql3.ToString(), parameters3); //删除短消息 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_message "); strSql4.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); MySqlParameter[] parameters4 = { new MySqlParameter("@post_user_name", MySqlDbType.VarChar, 100), new MySqlParameter("@accept_user_name", MySqlDbType.VarChar, 100) }; parameters4[0].Value = model.user_name; parameters4[1].Value = model.user_name; sqllist.Add(strSql4.ToString(), parameters4); //删除申请码 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "user_code "); strSql5.Append(" where user_id=@id"); MySqlParameter[] parameters5 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters5[0].Value = id; sqllist.Add(strSql5.ToString(), parameters5); //删除登录日志 StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete from " + databaseprefix + "user_login_log "); strSql6.Append(" where user_id=@id"); MySqlParameter[] parameters6 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters6[0].Value = id; sqllist.Add(strSql6.ToString(), parameters6); //删除OAuth授权用户信息 StringBuilder strSql8 = new StringBuilder(); strSql8.Append("delete from " + databaseprefix + "user_oauth "); strSql8.Append(" where user_id=@id"); MySqlParameter[] parameters8 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters8[0].Value = id; sqllist.Add(strSql8.ToString(), parameters8); //删除用户充值表 StringBuilder strSql9 = new StringBuilder(); strSql9.Append("delete from " + databaseprefix + "user_recharge "); strSql9.Append(" where user_id=@id"); MySqlParameter[] parameters9 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters9[0].Value = id; sqllist.Add(strSql9.ToString(), parameters9); //删除用户主表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users "); strSql.Append(" where id=@id"); MySqlParameter[] parameters = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters[0].Value = id; sqllist.Add(strSql.ToString(), parameters); bool result = DbHelperMySql.ExecuteSqlTran(sqllist); if (result) { return(true); } else { return(false); } }
/// <summary> /// 通过微信端注册的用户 /// 第一个用户,是设定是初始值加1 /// </summary> /// <param name="openId"></param> /// <param name="tel"></param> /// <param name="username"></param> /// <param name="sex"></param> /// <returns></returns> public int InsertUserByWX(int wid,string openId, string tel, string username, string sex, out decimal cardno) { //计算会员卡的最大号 decimal MaxCard = 0; string sqlStr = "select top 1 wxCard from dt_users where wid="+wid+" and wxCard is not null order by wxCard desc"; DataSet ds = DbHelperSQL.Query(sqlStr); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0 && ds.Tables[0].Rows[0]["wxCard"].ToString().Trim() != "0" && ds.Tables[0].Rows[0]["wxCard"].ToString().Trim() != "") { MaxCard = decimal.Parse(ds.Tables[0].Rows[0]["wxCard"].ToString()) + 1; } else { //如果还没有 //暂时注释掉 ----------2014-2-8 start----------- //BLL.wx_UCard_Sys ucardSysBll = new wx_UCard_Sys(); //IList<Model.wx_UCard_Sys> ucardSys = ucardSysBll.GetModelList("1=1 order by id desc"); //if (ucardSys != null) //{ // MaxCard = ucardSys[0].minCardNum.Value + 1; //} //else //{ // cardno = 0; // return 0; //} //暂时注释掉 ----------2014-2-8 end----------- } cardno = MaxCard; Model.users user = new Model.users(); user.isweixin = 1; user.group_id = 3; user.reg_ip = "127.0.0.1"; user.user_name = username; user.telphone = tel; user.email = "*****@*****.**"; user.password = tel; user.wxOpenId = openId; user.sex = sex; user.wxCard = MaxCard; if (ExistsOpenid(wid,openId)) { this.Update(user); return 1; } else { return this.Add(user); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.users model = new Model.users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_id"].ToString()); } if (ds.Tables[0].Rows[0]["express_id"].ToString() != "") { model.express_id = int.Parse(ds.Tables[0].Rows[0]["express_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.password = ds.Tables[0].Rows[0]["password"].ToString(); model.salt = ds.Tables[0].Rows[0]["salt"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); if (ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); model.wechat = ds.Tables[0].Rows[0]["wechat"].ToString(); model.companyaddress = ds.Tables[0].Rows[0]["companyaddress"].ToString(); model.companyid = ds.Tables[0].Rows[0]["companyid"].ToString(); model.companyname = ds.Tables[0].Rows[0]["companyname"].ToString(); model.taxid = ds.Tables[0].Rows[0]["taxid"].ToString(); return(model); } else { return(null); } }
//確認註册 protected void btnlogin_Click(object sender, ImageClickEventArgs e) { bool result = true; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); model.id = WEBUserCurrent.UserID; //model.is_lock = int.Parse(rblIsLock.SelectedValue); model.user_name = txtusername.Text.Trim(); model.password = DESEncrypt.Encrypt(txtpassword.Value); model.email = txtemall.Value; model.nick_name = txtName.Value; if (fileUpImage.HasFile) { string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.')); string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName; if (!System.IO.Directory.Exists(Server.MapPath("upload/user/"))) { System.IO.Directory.CreateDirectory(Server.MapPath("upload/user/")); } fileUpImage.SaveAs(Server.MapPath("upload/user/" + filename)); model.avatar = filename; } else { model.avatar = ViewState["file"] == null ? "" : ViewState["file"].ToString(); } //DateTime _birthday; //if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) //{ // model.birthday = _birthday; //} model.telphone = txtphone.Value.Trim(); //model.qq = ""; model.address = txtAddress.Value.Trim(); model.amount = 0; model.point = 0; model.exp = 0; model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); if (ddlGroup.SelectedValue == "0") { model.group_id = 1; } else { model.group_id = 5; // model.dianming = dianming.Value; //model.dianmiaoshu = dianmiaoshu.Value; //model.congye = congye.Value; //model.gongsi = gongsi.Value; //model.fuwuquyu = fuwuquyu.Value; //model.shuxishequ = shuxishequ.Value; //model.fuwutechang = fuwutechang.Value; //model.jingli = jingli.Value; //model.zhengshu = zhengshu.Value; model.note = note.Value; } if (bll.Update(model)) { this.Page.ClientScript.RegisterStartupScript(GetType(), "<script>alert('網路異常,請重試')</script>", ""); } else { if (model.group_id == 5) { Response.Redirect("userSJ.aspx"); } else { Response.Redirect("user.aspx"); } } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,group_id,user_name,password,salt,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip,user_type,user_status,province,city,district,purchase,purchase_mobile,parent_id,branch_id,real_name from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Model.users model = new Model.users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.password = ds.Tables[0].Rows[0]["password"].ToString(); model.salt = ds.Tables[0].Rows[0]["salt"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); model.real_name = ds.Tables[0].Rows[0]["real_name"].ToString(); model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); if (ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); if (ds.Tables[0].Rows[0]["user_type"] != null && ds.Tables[0].Rows[0]["user_type"].ToString() != "") { model.user_type = int.Parse(ds.Tables[0].Rows[0]["user_type"].ToString()); } if (ds.Tables[0].Rows[0]["user_status"] != null && ds.Tables[0].Rows[0]["user_status"].ToString() != "") { model.user_status = int.Parse(ds.Tables[0].Rows[0]["user_status"].ToString()); } if (ds.Tables[0].Rows[0]["province"] != null && ds.Tables[0].Rows[0]["province"].ToString() != "") { model.province = int.Parse(ds.Tables[0].Rows[0]["province"].ToString()); } if (ds.Tables[0].Rows[0]["city"] != null && ds.Tables[0].Rows[0]["city"].ToString() != "") { model.city = int.Parse(ds.Tables[0].Rows[0]["city"].ToString()); } if (ds.Tables[0].Rows[0]["district"] != null && ds.Tables[0].Rows[0]["district"].ToString() != "") { model.district = int.Parse(ds.Tables[0].Rows[0]["district"].ToString()); } model.purchase = ds.Tables[0].Rows[0]["purchase"].ToString(); model.purchase_mobile = ds.Tables[0].Rows[0]["purchase_mobile"].ToString(); if (ds.Tables[0].Rows[0]["parent_id"] != null && ds.Tables[0].Rows[0]["parent_id"].ToString() != "") { model.parent_id = int.Parse(ds.Tables[0].Rows[0]["parent_id"].ToString()); } if (ds.Tables[0].Rows[0]["branch_id"] != null && ds.Tables[0].Rows[0]["branch_id"].ToString() != "") { model.branch_id = int.Parse(ds.Tables[0].Rows[0]["branch_id"].ToString()); } return model; } else { return null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "users set "); strSql.Append("group_id=@group_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("password=@password,"); strSql.Append("salt=@salt,"); strSql.Append("email=@email,"); strSql.Append("nick_name=@nick_name,"); strSql.Append("avatar=@avatar,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("telphone=@telphone,"); strSql.Append("mobile=@mobile,"); strSql.Append("qq=@qq,"); strSql.Append("address=@address,"); strSql.Append("safe_question=@safe_question,"); strSql.Append("safe_answer=@safe_answer,"); strSql.Append("amount=@amount,"); strSql.Append("point=@point,"); strSql.Append("exp=@exp,"); strSql.Append("status=@status,"); strSql.Append("reg_time=@reg_time,"); strSql.Append("reg_ip=@reg_ip,"); strSql.Append("isweixin=@isweixin,"); strSql.Append("wid=@wid,"); strSql.Append("wxOpenId=@wxOpenId,"); strSql.Append("wxName=@wxName"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@salt", SqlDbType.NVarChar, 20), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@isweixin", SqlDbType.TinyInt, 1), new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@wxOpenId", SqlDbType.NVarChar, 100), new SqlParameter("@wxName", SqlDbType.NVarChar, 150) }; parameters[0].Value = model.id; parameters[1].Value = model.group_id; parameters[2].Value = model.user_name; parameters[3].Value = model.password; parameters[4].Value = model.salt; parameters[5].Value = model.email; parameters[6].Value = model.nick_name; parameters[7].Value = model.avatar; parameters[8].Value = model.sex; parameters[9].Value = model.birthday; parameters[10].Value = model.telphone; parameters[11].Value = model.mobile; parameters[12].Value = model.qq; parameters[13].Value = model.address; parameters[14].Value = model.safe_question; parameters[15].Value = model.safe_answer; parameters[16].Value = model.amount; parameters[17].Value = model.point; parameters[18].Value = model.exp; parameters[19].Value = model.status; parameters[20].Value = model.reg_time; parameters[21].Value = model.reg_ip; parameters[22].Value = model.isweixin; parameters[23].Value = model.wid; parameters[24].Value = model.wxOpenId; parameters[25].Value = model.wxName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users 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 + "users("); strSql.Append("group_id,user_name,salt,[password],mobile,email,avatar,nick_name,sex,birthday,telphone,area,address,qq,msn,amount,point,exp,status,reg_time,reg_ip)"); strSql.Append(" values ("); strSql.Append("@group_id,@user_name,@salt,@password,@mobile,@email,@avatar,@nick_name,@sex,@birthday,@telphone,@area,@address,@qq,@msn,@amount,@point,@exp,@status,@reg_time,@reg_ip)"); OleDbParameter[] parameters = { new OleDbParameter("@group_id", OleDbType.Integer, 4), new OleDbParameter("@user_name", OleDbType.VarChar, 100), new OleDbParameter("@salt", OleDbType.VarChar, 20), new OleDbParameter("@password", OleDbType.VarChar, 100), new OleDbParameter("@mobile", OleDbType.VarChar, 20), new OleDbParameter("@email", OleDbType.VarChar, 50), new OleDbParameter("@avatar", OleDbType.VarChar, 255), new OleDbParameter("@nick_name", OleDbType.VarChar, 100), new OleDbParameter("@sex", OleDbType.VarChar, 20), new OleDbParameter("@birthday", OleDbType.Date), new OleDbParameter("@telphone", OleDbType.VarChar, 50), new OleDbParameter("@area", OleDbType.VarChar, 255), new OleDbParameter("@address", OleDbType.VarChar, 255), new OleDbParameter("@qq", OleDbType.VarChar, 20), new OleDbParameter("@msn", OleDbType.VarChar, 100), new OleDbParameter("@amount", OleDbType.Decimal, 5), new OleDbParameter("@point", OleDbType.Integer, 4), new OleDbParameter("@exp", OleDbType.Integer, 4), new OleDbParameter("@status", OleDbType.Integer, 4), new OleDbParameter("@reg_time", OleDbType.Date), new OleDbParameter("@reg_ip", OleDbType.VarChar, 20) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.salt; parameters[3].Value = model.password; parameters[4].Value = model.mobile; parameters[5].Value = model.email; parameters[6].Value = model.avatar; parameters[7].Value = model.nick_name; parameters[8].Value = model.sex; if (model.birthday != null) { parameters[9].Value = model.birthday; } else { parameters[9].Value = DBNull.Value; } parameters[10].Value = model.telphone; parameters[11].Value = model.area; parameters[12].Value = model.address; parameters[13].Value = model.qq; parameters[14].Value = model.msn; parameters[15].Value = model.amount; parameters[16].Value = model.point; parameters[17].Value = model.exp; parameters[18].Value = model.status; parameters[19].Value = model.reg_time; parameters[20].Value = model.reg_ip; DbHelperOleDb.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID newId = GetMaxId(conn, trans); trans.Commit(); } catch { trans.Rollback(); return(-1); } } } return(newId); }
/// <summary> /// 添加分配账户员工 /// </summary> /// <param name="context"></param> private void dealing_users(HttpContext context) { string username = DTRequest.GetString("username"); string password = DTRequest.GetString("psd"); string phone = DTRequest.GetString("phone"); string email = DTRequest.GetString("email"); string real_name = DTRequest.GetString("real_name"); int branch = DTRequest.GetFormInt("branch_id"); Model.users model = new Model.users(); BLL.users bll = new BLL.users(); Model.users model1 = new BasePage().GetUserInfo(); if (model1 == null) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,请重新登录!\"}"); return; } if (bll.Exists(username)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,该账户名已存在!\"}"); return; } model.user_name = username; model.password = password; model.telphone = phone; model.real_name = real_name; model.email = email; model.branch_id = branch; model.user_status = 3; model.user_type = 1; model.parent_id = model1.id; model.group_id = 1; if (bll.Add(model) > 0) { context.Response.Write("{\"status\":1, \"msg\":\"添加员工成功!\"}"); return; } else { context.Response.Write("{\"status\":0, \"msg\":\"对不起,添加员工失败!\"}"); return; } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Model.users DataRowToModel(DataRow row) { Model.users model = new Model.users(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["group_id"] != null && row["group_id"].ToString() != "") { model.group_id = int.Parse(row["group_id"].ToString()); } if (row["user_name"] != null) { model.user_name = row["user_name"].ToString(); } if (row["salt"] != null) { model.salt = row["salt"].ToString(); } if (row["password"] != null) { model.password = row["password"].ToString(); } if (row["mobile"] != null) { model.mobile = row["mobile"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["avatar"] != null) { model.avatar = row["avatar"].ToString(); } if (row["nick_name"] != null) { model.nick_name = row["nick_name"].ToString(); } if (row["sex"] != null) { model.sex = row["sex"].ToString(); } if (row["birthday"] != null && row["birthday"].ToString() != "") { model.birthday = DateTime.Parse(row["birthday"].ToString()); } if (row["telphone"] != null) { model.telphone = row["telphone"].ToString(); } if (row["area"] != null) { model.area = row["area"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["qq"] != null) { model.qq = row["qq"].ToString(); } if (row["msn"] != null) { model.msn = row["msn"].ToString(); } if (row["amount"] != null && row["amount"].ToString() != "") { model.amount = decimal.Parse(row["amount"].ToString()); } if (row["point"] != null && row["point"].ToString() != "") { model.point = int.Parse(row["point"].ToString()); } if (row["exp"] != null && row["exp"].ToString() != "") { model.exp = int.Parse(row["exp"].ToString()); } if (row["status"] != null && row["status"].ToString() != "") { model.status = int.Parse(row["status"].ToString()); } if (row["reg_time"] != null && row["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(row["reg_time"].ToString()); } if (row["reg_ip"] != null) { model.reg_ip = row["reg_ip"].ToString(); } } return model; }
/// <summary> /// 将在Init事件执行 /// </summary> protected void payment_Init(object sender, EventArgs e) { //取得处事类型 action = DTRequest.GetString("action"); order_type = DTRequest.GetString("order_type"); order_no = DTRequest.GetString("order_no"); switch (action) { case "confirm": if (string.IsNullOrEmpty(action) || string.IsNullOrEmpty(order_type) || string.IsNullOrEmpty(order_no)) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,URL传输参数有误!")); return; } //检查用户是否登录 userModel = new Web.UI.BasePage().GetUserInfo(); if (userModel == null) { //用户未登录 HttpContext.Current.Response.Redirect(linkurl("payment", "login")); return; } //检查订单的类型(充值或购物) if (order_type == DTEnums.AmountTypeEnum.Recharge.ToString()) //充值 { amountModel = new BLL.amount_log().GetModel(order_no); if (amountModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } //检查订单号是否已支付 if (amountModel.status == 1) { HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, amountModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(amountModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!")); return; } //检查是否线上支付 if (payModel.type == 2) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,账户充值不允许线下支付!")); return; } order_amount = amountModel.value; //订单金额 } else if (order_type == DTEnums.AmountTypeEnum.BuyGoods.ToString()) //购物 { //检查订单是否存在 orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } //检查是否已支付过 if (orderModel.payment_status == 2) { HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, orderModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(orderModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!")); return; } //检查是否线下付款 if (payModel.type == 2) { HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, orderModel.order_no)); return; } //检查是否积分换购,直接跳转成功页面 if (orderModel.order_amount == 0) { //修改订单状态 bool result = new BLL.orders().UpdateField(orderModel.order_no, "payment_status=2,payment_time='" + DateTime.Now + "'"); if (!result) { HttpContext.Current.Response.Redirect(linkurl("payment", "error")); return; } HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, orderModel.order_no)); return; } order_amount = orderModel.order_amount; //订单金额 } else { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!")); return; } break; case "succeed": //检查订单的类型(充值或购物) if (order_type == DTEnums.AmountTypeEnum.Recharge.ToString()) //充值 { amountModel = new BLL.amount_log().GetModel(order_no); if (amountModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } } else if (order_type == DTEnums.AmountTypeEnum.BuyGoods.ToString()) //购物 { orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } } else { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!")); return; } break; } }
/// <summary> /// 将在Init事件执行 /// </summary> protected void payment_Init(object sender, EventArgs e) { //取得处事类型 action = DTRequest.GetString("action"); order_type = DTRequest.GetString("order_type"); order_no = DTRequest.GetString("order_no"); switch (action) { case "confirm": if (string.IsNullOrEmpty(action) || string.IsNullOrEmpty(order_type) || string.IsNullOrEmpty(order_no)) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,URL传输参数有误!")); return; } //检查用户是否登录 userModel = new Web.UI.BasePage().GetUserInfo(); if (userModel == null) { //用户未登录 HttpContext.Current.Response.Redirect(linkurl("payment", "login")); return; } //检查订单的类型(充值或购物) if (order_type == DTEnums.AmountTypeEnum.Recharge.ToString()) //充值 { amountModel = new BLL.amount_log().GetModel(order_no); if (amountModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } //检查订单号是否已支付 if (amountModel.status == 1) { HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, amountModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(amountModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!")); return; } //检查是否线上支付 if (payModel.type == 2) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,账户充值不允许线下支付!")); return; } order_amount = amountModel.value; //订单金额 } else if (order_type == DTEnums.AmountTypeEnum.BuyGoods.ToString()) //购物 { //检查订单是否存在 orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } //检查是否已支付过 if (orderModel.payment_status == 2) { HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, orderModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(orderModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!")); return; } //检查是否线下付款 if (payModel.type == 2) { HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, orderModel.order_no)); return; } //检查是否积分换购,直接跳转成功页面 if (orderModel.order_amount == 0) { //修改订单状态 bool result = new BLL.orders().UpdateField(orderModel.order_no, "payment_status=2,payment_time='" + DateTime.Now + "'"); if (!result) { HttpContext.Current.Response.Redirect(linkurl("payment", "error")); return; } HttpContext.Current.Response.Redirect(linkurl("payment1", "succeed", order_type, orderModel.order_no)); return; } order_amount = orderModel.order_amount; //订单金额 } else { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!")); return; } break; case "succeed": //检查订单的类型(充值或购物) if (order_type == DTEnums.AmountTypeEnum.Recharge.ToString()) //充值 { amountModel = new BLL.amount_log().GetModel(order_no); if (amountModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } } else if (order_type == DTEnums.AmountTypeEnum.BuyGoods.ToString()) //购物 { orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!")); return; } } else { HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!")); return; } break; } }
private bool DoAdd() { bool result = true; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); model.group_id = int.Parse(ddlGroupId.SelectedValue); model.is_lock = int.Parse(rblIsLock.SelectedValue); model.user_name = txtUserName.Text.Trim(); model.password = DESEncrypt.Encrypt(txtPassword.Text); model.email = txtEmail.Text; model.nick_name = txtNickName.Text; model.avatar = txtAvatar.Text; model.sex = rblSex.SelectedValue; DateTime _birthday; if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) { model.birthday = _birthday; } model.telphone = txtTelphone.Text.Trim(); model.mobile = txtMobile.Text.Trim(); model.qq = txtQQ.Text; model.address = txtAddress.Text.Trim(); model.amount = decimal.Parse(txtAmount.Text.Trim()); model.point = int.Parse(txtPoint.Text.Trim()); model.exp = int.Parse(txtExp.Text.Trim()); model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); if (bll.Add(model) < 1) { result = false; } return result; }
void ToPay(int Uid) { Utils.WriteCookie("LoginUserID", Uid.ToString()); webUrl = "http://" + Utils.GetHomeUrl(); paymenttype = "1"; if (!string.IsNullOrEmpty(paymenttype)) { if (paymenttype == "lian") { ptype = "Credit"; } if (paymenttype == "1") { ptype = "Credit"; } if (paymenttype == "2") { ptype = "WebATM"; } if (paymenttype == "") { ptype = "ATM"; } if (paymenttype == "3") { ptype = "CVS"; } if (paymenttype == "barcode") { ptype = "BARCODE"; } if (paymenttype == "alipay") { ptype = "Alipay"; } if (paymenttype == "") { ptype = "Tenpay"; } } else { ptype = "ALL"; } string Fee = "0"; BLL.users bllUser = new BLL.users(); User = bllUser.GetModel(Uid); int Groupid = Utils.StringToNum(DTRequest.GetFormString("ctl00$ContentPlaceHolder1$ddlGroup")); switch (Groupid) { case 2: Fee = "100"; break; case 3: Fee = "200"; break; case 4: Fee = "300"; break; } if (Uid == -1) { Uid = 1; } orderNo = DateTime.Now.ToString("yyyyMMddhhssmm") + Uid.ToString() + Groupid.ToString(); string ok_urlall = webUrl + "/Regpay_ok.aspx"; //返回地址 StringBuilder sb = new StringBuilder(); StringBuilder sbHtml = new StringBuilder(); if (!string.IsNullOrEmpty(ptype) && User != null) { string merchantid = "1038690"; string url = ""; //url sb.Append("HashKey=7RswcwBgLcqnMjy5"); if (ptype == "Alipay") { sb.Append("&AlipayItemCounts=1"); sb.Append("&AlipayItemName=" + orderNo + ""); sb.Append("&AlipayItemPrice=1"); } sb.Append("&ChoosePayment=" + ptype + ""); if (ptype == "Alipay") { sb.Append("&Email=" + User.email + ""); } sb.Append("&ItemName=" + orderNo + ""); sb.Append("&MerchantID=" + merchantid + ""); string time = User.reg_time.ToString("yyyy/MM/dd HH:mm:ss").Replace("-", "/"); sb.Append("&MerchantTradeDate=" + User.reg_time.ToString("yyyy/MM/dd HH:mm:ss").Replace("-", "/") + ""); sb.Append("&MerchantTradeNo=" + orderNo + ""); sb.Append("&OrderResultURL=" + ok_urlall + ""); sb.Append("&PaymentType=aio"); if (ptype == "Alipay") { sb.Append("&PhoneNo=" + User.mobile + ""); } sb.Append("&Remark=" + orderNo + ""); sb.Append("&ReturnURL=" + ok_urlall + ""); sb.Append("&TotalAmount=" + Fee + ""); sb.Append("&TradeDesc=" + orderNo + ""); if (ptype == "Credit") { if (paymenttype == "1") { sb.Append("&UnionPay=0"); } if (paymenttype == "lian") { sb.Append("&UnionPay=1"); } } if (ptype == "Alipay") { sb.Append("&UserName="******""); } sb.Append("&HashIV=IA0pz3lNuyui52iZ"); url = sb.ToString(); url = getstr(url).ToLower(); sb.Append("&CheckMacValue=" + BLL.Function.Instance.MD5(url, 32) + ""); string CheckMacValue = BLL.Function.Instance.MD5(url, 32); // Response.Write(CheckMacValue); //Atm缴费http://payment-stage.allpay.com.tw/Cashier/AioCheckOut sbHtml.Append("<form id='paysubmit' name='ecbanksubmit' action='https://payment.allpay.com.tw/Cashier/AioCheckOut' target='_blank' method='post'>"); if (ptype == "Alipay") { sbHtml.Append("<input type='hidden' name='AlipayItemCounts' value='1'/>"); sbHtml.Append("<input type='hidden' name='AlipayItemName' value='" + orderNo + "'/>"); sbHtml.Append("<input type='hidden' name='AlipayItemPrice' value='1'/>"); } sbHtml.Append("<input type='hidden' name='ChoosePayment' value='" + ptype + "'/>"); if (ptype == "Alipay") { sbHtml.Append("<input type='hidden' name='Email' value='" + User.email + "'/>"); } sbHtml.Append("<input type='hidden' name='ItemName' value='" + orderNo + "'/>"); sbHtml.Append("<input type='hidden' name='MerchantID' value='" + merchantid + "'/>"); sbHtml.Append("<input type='hidden' name='MerchantTradeDate' value='" + User.reg_time.ToString("yyyy/MM/dd HH:mm:ss").Replace("-", "/") + "'/>"); sbHtml.Append("<input type='hidden' name='MerchantTradeNo' value='" + orderNo + "'/>"); sbHtml.Append("<input type='hidden' name='OrderResultURL' value='" + ok_urlall + "'/>"); sbHtml.Append("<input type='hidden' name='PaymentType' value='aio'/>"); if (ptype == "Alipay") { sbHtml.Append("<input type='hidden' name='PhoneNo' value='" + User.mobile + "'/>"); } sbHtml.Append("<input type='hidden' name='Remark' value='" + orderNo + "'/>"); sbHtml.Append("<input type='hidden' name='ReturnURL' value='" + ok_urlall + "'/>"); sbHtml.Append("<input type='hidden' name='TotalAmount' value='" + Fee + "'/>"); sbHtml.Append("<input type='hidden' name='TradeDesc' value='" + orderNo + "'/>"); if (ptype == "Credit") { if (paymenttype == "1") { sbHtml.Append("<input type='hidden' name='UnionPay' value='0'/>"); } if (paymenttype == "lian") { sbHtml.Append("<input type='hidden' name='UnionPay' value='1'/>"); } } if (ptype == "Alipay") { sbHtml.Append("<input type='hidden' name='UserName' value='" + User.user_name + "' />"); } sbHtml.Append("<input type='hidden' name='CheckMacValue' value='" + CheckMacValue + "'/>"); sbHtml.Append("<input type='submit=Submit' style='display:none;'></form>"); sbHtml.Append("<script>document.forms['paysubmit'].submit();</script>"); Response.Write(sbHtml); Response.End(); } //atm转帐 if (paymenttype == "atm") { Response.Redirect("ordershow.aspx?id=" + id); } //銀行匯款 if (paymenttype == "hui") { Response.Redirect("ordershow.aspx?id=" + id); } //宅配貨到付款 if (paymenttype == "dao") { Response.Redirect("ordershow.aspx?id=" + id); } //到店取货 if (paymenttype == "dian") { Response.Redirect("ordershow.aspx?id=" + id); } }
private void user_register(HttpContext context) { string code = Vincent._DTcms.DTRequest.GetFormString("txtCode").Trim(); string salt = Vincent._DTcms.DTRequest.GetFormString("txtSalt").Trim(); string username = Vincent._DTcms.Utils.ToHtml(Vincent._DTcms.DTRequest.GetFormString("txtName").Trim()); string password = Vincent._DTcms.DTRequest.GetFormString("txtPwd").Trim(); //string mobile = Vincent._DTcms.Utils.ToHtml(Vincent._DTcms.DTRequest.GetFormString("txtMobile").Trim()); string userip = Vincent._DTcms.DTRequest.GetIP(); string saltstring = ""; #region 检查各项并提示 BLL.users bll = new BLL.users(); Model.users model = new Model.users(); //if (bll.ExistsMobile(username)) //{ // HttpContext.Current.Response.Clear(); // HttpContext.Current.Response.Write("{\"status\":0, \"msg\":\"该手机号已经注册!\"}"); // HttpContext.Current.Response.End(); // return; //} if (salt != "") { saltstring = bll.GetSalt(salt); } if (bll.Exists(username.Trim())) { context.Response.Write("{\"status\":0, \"msg\":\"该用户名已被注册!\"}"); return; } //检查是否开启会员功能 if (siteConfig.memberstatus == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,会员功能已关闭,无法注册!\"}"); return; } if (userConfig.regstatus == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,系统暂不允许注册新用户!\"}"); return; } if (code.ToLower() != (_Cookie.GetCookie(Vincent._DTcms.DTKeys.SESSION_SMS_CODE).ToString()).ToLower()) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,你的手机验证码不正确!\"}"); return; } #endregion //保存注册信息 model.group_id = 1; //普通用户注册 model.user_name = username; model.salt = Vincent._DTcms.Utils.GetCheckCode(6); //获得6位的salt加密字符串 model.password = _DESEncrypt.Encrypt(password, model.salt); model.mobile = username; model.reg_ip = userip; model.parentSalt = saltstring; model.reg_time = DateTime.Now; model.isMobile = 1; model.strcode = Vincent._DTcms.Utils.GetCheckCode(20);//生成随机码 //设置对应的状态 switch (userConfig.regverify) { case 0: model.status = 0; //正常 break; case 3: model.status = 2; //人工审核 break; default: model.status = 1; //待验证 break; } int newId = bll.Add(model); if (newId < 1) { context.Response.Write("{\"status\":0, \"msg\":\"系统故障,请联系网站管理员!\"}"); return; } model = bll.GetModel(newId); if (model != null) { 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, "会员登录"); context.Response.Write("{\"status\":1, \"msg\":\"注册成功,欢迎成为本站会员!\"}"); } else { context.Response.Write("{\"status\":0, \"msg\":\"注册失败!\"}"); } }
protected void reg() { type = DTRequest.GetFormInt("ctl00$ContentPlaceHolder1$type"); bool result = true; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); //model.is_lock = int.Parse(rblIsLock.SelectedValue); model.user_name = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtusername"); model.password = DESEncrypt.Encrypt(DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtpassword")); model.email = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtemall"); model.nick_name = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtName"); //if (fileUpImage.HasFile) //{ // string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.')); // string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName; // if (!System.IO.Directory.Exists(Server.MapPath("upload/user/"))) // { // System.IO.Directory.CreateDirectory(Server.MapPath("upload/user/")); // } // fileUpImage.SaveAs(Server.MapPath("upload/user/" + filename)); // model.avatar = filename; //} //model.sex = rblSex.SelectedValue; //DateTime _birthday; //if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) //{ // model.birthday = _birthday; //} model.mobile = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtphone"); //model.qq = ""; model.address = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtAddress"); model.amount = 0; model.point = 0; switch (type) { case 1: model.amount = 0; break; case 2: model.amount = 100; break; case 3: model.amount = 200; break; case 4: model.amount = 300; break; } model.exp = 0; model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); //if (ddlGroup.SelectedValue == "0") //{ // model.group_id = 1; //} //else //{ model.group_id = Utils.StringToNum(DTRequest.GetFormString("ctl00$ContentPlaceHolder1$ddlGroup")); model.dianming = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtIntroduce"); //model.dianmiaoshu = dianmiaoshu.Value; //model.congye = congye.Value; model.gongsi = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$gongsi"); model.fuwuquyu = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$CompanyName"); //model.fuwuquyu = fuwuquyu.Value; //model.shuxishequ = shuxishequ.Value; //model.fuwutechang = fuwutechang.Value; //model.jingli = jingli.Value; //model.zhengshu = zhengshu.Value; model.note = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$note"); model.is_lock = 1; //} int bk = bll.Add(model); if (bk < 1) { this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('網路異常,請重試')</script>"); } else { setEmail(); Utils.WriteCookie("LoginUserID", bk.ToString()); //ToFirstPay(bk); //this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('註冊成功,請登入');window.location.href='login.aspx'</script>"); } }
private void weixin_user_login(HttpContext context) { var urlReferrer = HttpContext.Current.Request.UrlReferrer; var cart = Vincent._DTcms.DTRequest.GetQueryInt("cart", 0); var id = Vincent._DTcms.DTRequest.GetQueryInt("id", 0); var state = Vincent._DTcms.DTRequest.GetString("state"); _Log.SaveMessage(string.Format("UrlReferrer: {0}, Id: {1}, State: {2}", urlReferrer, id, state)); BuysingooShop.BLL.users bll = new BuysingooShop.BLL.users(); Model.users model = null; try { model = bll.GetModel(id); } catch (Exception ex) { context.Response.Write(ex.ToString()); return; } if (model == null) { context.Response.Write("微信授权登陆失败,请重试!"); return; } //检查用户是否通过验证 if (model.status == 1) //待验证 { context.Response.Write("{\"status\":0, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=sendmail&username="******"\", \"msg\":\"你的账号未激活,请激活后再使用!\"}"); return; } else if (model.status == 2) //待审核 { context.Response.Write("{\"status\":0, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=verify&username="******"\", \"msg\":\"你的账号未审核!请等待管理员的审核!\"}"); return; } context.Session[Vincent._DTcms.DTKeys.SESSION_USER_INFO] = model; context.Session.Timeout = 45; ////记住登录状态下次自动登录 //if (remember.ToLower() == "true") //{ // Vincent._DTcms.Utils.WriteCookie(Vincent._DTcms.DTKeys.COOKIE_USER_NAME_REMEMBER, "BuysingooShop", model.user_name, 43200); // Vincent._DTcms.Utils.WriteCookie(Vincent._DTcms.DTKeys.COOKIE_USER_PWD_REMEMBER, "BuysingooShop", model.password, 43200); //} //else //{ // //防止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); //} //防止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, "会员登录"); if (cart == 0) { HttpContext.Current.Response.Redirect("http://www.mijianghu.com"); } else { HttpContext.Current.Response.Redirect("http://www.mijianghu.com/goods/cart.html"); } return; }
protected void btnlogin_Click(object sender, ImageClickEventArgs e) { bool result = true; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); model.user_name = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtusername"); model.password = DESEncrypt.Encrypt(DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtpassword")); model.email = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtemall"); model.nick_name = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtName"); if (fileUpImage.HasFile) { string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.')); string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName; if (!System.IO.Directory.Exists(Server.MapPath("upload/user/"))) { System.IO.Directory.CreateDirectory(Server.MapPath("upload/user/")); } fileUpImage.SaveAs(Server.MapPath("upload/user/" + filename)); model.avatar = filename; } //model.sex = rblSex.SelectedValue; //DateTime _birthday; //if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) //{ // model.birthday = _birthday; //} model.telphone = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtTel"); model.mobile = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtphone"); //model.qq = ""; model.address = model.address = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtcity") + "|" + DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtcity1") + "|" + txtZip.Text + "|" + DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtAddress");; model.amount = 0; model.point = 0; //switch (type) //{ // case 1: // model.amount = 0; // break; // case 2: // model.amount = 100; // break; // case 3: // model.amount = 200; // break; // case 4: // model.amount = 300; // break; //} model.exp = 0; model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); //if (ddlGroup.SelectedValue == "0") //{ // model.group_id = 1; //} //else //{ model.group_id = Utils.StringToNum(DTRequest.GetFormString("ctl00$ContentPlaceHolder1$ddlGroup")); model.dianming = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$txtIntroduce"); //model.dianmiaoshu = dianmiaoshu.Value; //model.congye = congye.Value; model.gongsi = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$gongsi"); model.fuwuquyu = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$CompanyName"); //model.fuwuquyu = fuwuquyu.Value; //model.shuxishequ = shuxishequ.Value; //model.fuwutechang = fuwutechang.Value; //model.jingli = jingli.Value; //model.zhengshu = zhengshu.Value; model.note = DTRequest.GetFormString("ctl00$ContentPlaceHolder1$note"); model.is_lock = 1; //} int bk = bll.Add(model); if (bk < 1) { this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('網路異常,請重試')</script>"); } else { setEmail(bk); this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('註冊完成,請查收電子郵件並依照步驟完成帳戶啟動');window.location.href='index.aspx'</script>"); } }
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> /// 将在Init事件执行 /// </summary> protected void payment_Init(object sender, EventArgs e) { //取得处事类型 action = AXRequest.GetString("action"); order_no = AXRequest.GetString("order_no"); if (order_no.ToUpper().StartsWith("R")) //充值订单 { order_type = AXEnums.AmountTypeEnum.Recharge.ToString().ToLower(); } else if (order_no.ToUpper().StartsWith("B")) //商品订单 { order_type = AXEnums.AmountTypeEnum.BuyGoods.ToString().ToLower(); } switch (action) { case "confirm": if (string.IsNullOrEmpty(action) || string.IsNullOrEmpty(order_no)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,URL传输参数有误!"))); return; } //是否需要支持匿名购物 userModel = new Web.UI.BasePage().GetUserInfo(); //取得用户登录信息 if (orderConfig.anonymous == 0 || order_no.ToUpper().StartsWith("R")) { if (userModel == null) { //用户未登录 HttpContext.Current.Response.Redirect(linkurl("payment", "login")); return; } } else if (userModel == null) { userModel = new Model.users(); } //检查订单的类型(充值或购物) if (order_no.ToUpper().StartsWith("R")) //充值订单 { amountModel = new BLL.user_amount_log().GetModel(order_no); if (amountModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } //检查订单号是否已支付 if (amountModel.status == 1) { HttpContext.Current.Response.Redirect(linkurl("payment", "succeed", amountModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(amountModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!"))); return; } //检查是否线上支付 if (payModel.type == 2) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,账户充值不允许线下支付!"))); return; } order_amount = amountModel.value; //" + Resources.lang.amount+ " } else if (order_no.ToUpper().StartsWith("B")) //商品订单 { //检查订单是否存在 orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } //检查是否已支付过 if (orderModel.payment_status == 2) { HttpContext.Current.Response.Redirect(linkurl("payment", "succeed", orderModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(orderModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!"))); return; } //检查是否线下付款 if (orderModel.payment_status == 0) { HttpContext.Current.Response.Redirect(linkurl("payment", "succeed", orderModel.order_no)); return; } //检查是否积分换购,直接跳转成功页面 if (orderModel.order_amount == 0) { //修改" + Resources.lang.orderStatus+ " bool result = new BLL.orders().UpdateField(orderModel.order_no, "status=2,payment_status=2,payment_time='" + DateTime.Now + "'"); if (!result) { HttpContext.Current.Response.Redirect(linkurl("payment", "error")); return; } HttpContext.Current.Response.Redirect(linkurl("payment", "succeed", orderModel.order_no)); return; } order_amount = orderModel.order_amount; //" + Resources.lang.amount+ " } else { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!"))); return; } break; case "succeed": //检查订单的类型(充值或购物) if (order_no.ToUpper().StartsWith("R")) //充值订单 { amountModel = new BLL.user_amount_log().GetModel(order_no); if (amountModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } } else if (order_no.ToUpper().StartsWith("B")) //商品订单 { orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } } else { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!"))); return; } break; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users model) { return(dal.Add(model)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,group_id,user_name,password,salt,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip,isweixin,wid,wxOpenId,wxName from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Model.users model = new Model.users(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["group_id"].ToString() != "") { model.group_id = int.Parse(ds.Tables[0].Rows[0]["group_id"].ToString()); } model.user_name = ds.Tables[0].Rows[0]["user_name"].ToString(); model.password = ds.Tables[0].Rows[0]["password"].ToString(); model.salt = ds.Tables[0].Rows[0]["salt"].ToString(); model.email = ds.Tables[0].Rows[0]["email"].ToString(); model.nick_name = ds.Tables[0].Rows[0]["nick_name"].ToString(); model.avatar = ds.Tables[0].Rows[0]["avatar"].ToString(); model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); if (ds.Tables[0].Rows[0]["birthday"].ToString() != "") { model.birthday = DateTime.Parse(ds.Tables[0].Rows[0]["birthday"].ToString()); } model.telphone = ds.Tables[0].Rows[0]["telphone"].ToString(); model.mobile = ds.Tables[0].Rows[0]["mobile"].ToString(); model.qq = ds.Tables[0].Rows[0]["qq"].ToString(); model.address = ds.Tables[0].Rows[0]["address"].ToString(); model.safe_question = ds.Tables[0].Rows[0]["safe_question"].ToString(); model.safe_answer = ds.Tables[0].Rows[0]["safe_answer"].ToString(); if (ds.Tables[0].Rows[0]["amount"].ToString() != "") { model.amount = decimal.Parse(ds.Tables[0].Rows[0]["amount"].ToString()); } if (ds.Tables[0].Rows[0]["point"].ToString() != "") { model.point = int.Parse(ds.Tables[0].Rows[0]["point"].ToString()); } if (ds.Tables[0].Rows[0]["exp"].ToString() != "") { model.exp = int.Parse(ds.Tables[0].Rows[0]["exp"].ToString()); } if (ds.Tables[0].Rows[0]["status"].ToString() != "") { model.status = int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } if (ds.Tables[0].Rows[0]["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(ds.Tables[0].Rows[0]["reg_time"].ToString()); } model.reg_ip = ds.Tables[0].Rows[0]["reg_ip"].ToString(); if (ds.Tables[0].Rows[0]["isweixin"] != null && ds.Tables[0].Rows[0]["isweixin"].ToString() != "") { model.isweixin = int.Parse(ds.Tables[0].Rows[0]["isweixin"].ToString()); } if (ds.Tables[0].Rows[0]["wid"] != null && ds.Tables[0].Rows[0]["wid"].ToString() != "") { model.wid = int.Parse(ds.Tables[0].Rows[0]["wid"].ToString()); } if (ds.Tables[0].Rows[0]["wxOpenId"] != null) { model.wxOpenId = ds.Tables[0].Rows[0]["wxOpenId"].ToString(); } if (ds.Tables[0].Rows[0]["wxName"] != null) { model.wxName = ds.Tables[0].Rows[0]["wxName"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "users("); strSql.Append("group_id,user_name,password,salt,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,status,reg_time,reg_ip,isweixin,wid,wxOpenId,wxName)"); strSql.Append(" values ("); strSql.Append("@group_id,@user_name,@password,@salt,@email,@nick_name,@avatar,@sex,@birthday,@telphone,@mobile,@qq,@address,@safe_question,@safe_answer,@amount,@point,@exp,@status,@reg_time,@reg_ip,@isweixin,@wid,@wxOpenId,@wxName)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@salt", SqlDbType.NVarChar, 20), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@status", SqlDbType.TinyInt, 1), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@isweixin", SqlDbType.TinyInt, 1), new SqlParameter("@wid", SqlDbType.Int, 4), new SqlParameter("@wxOpenId", SqlDbType.NVarChar, 100), new SqlParameter("@wxName", SqlDbType.NVarChar, 150) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.password; parameters[3].Value = model.salt; parameters[4].Value = model.email; parameters[5].Value = model.nick_name; parameters[6].Value = model.avatar; parameters[7].Value = model.sex; parameters[8].Value = model.birthday; parameters[9].Value = model.telphone; parameters[10].Value = model.mobile; parameters[11].Value = model.qq; parameters[12].Value = model.address; parameters[13].Value = model.safe_question; parameters[14].Value = model.safe_answer; parameters[15].Value = model.amount; parameters[16].Value = model.point; parameters[17].Value = model.exp; parameters[18].Value = model.status; parameters[19].Value = model.reg_time; parameters[20].Value = model.reg_ip; parameters[21].Value = model.isweixin; parameters[22].Value = model.wid; parameters[23].Value = model.wxOpenId; parameters[24].Value = model.wxName; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void btnlogin_Click(object sender, ImageClickEventArgs e) { bool result = true; Model.users model = new Model.users(); BLL.users bll = new BLL.users(); //model.is_lock = int.Parse(rblIsLock.SelectedValue); model.user_name = txtusername.Value.Trim(); model.password = DESEncrypt.Encrypt(txtpassword.Value); model.email = txtemall.Value; model.nick_name = txtName.Value; if (fileUpImage.HasFile) { string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.')); string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName; if (!System.IO.Directory.Exists(Server.MapPath("upload/user/"))) { System.IO.Directory.CreateDirectory(Server.MapPath("upload/user/")); } fileUpImage.SaveAs(Server.MapPath("upload/user/" + filename)); model.avatar = filename; } //model.sex = rblSex.SelectedValue; //DateTime _birthday; //if (DateTime.TryParse(txtBirthday.Text.Trim(), out _birthday)) //{ // model.birthday = _birthday; //} model.mobile = txtphone.Value.Trim(); //model.qq = ""; model.address = txtAddress.Value.Trim(); model.amount = 0; model.point = 0; switch (type) { case 1: model.amount = 0; break; case 2: model.amount = 100; break; case 3: model.amount = 200; break; case 4: model.amount = 300; break; } model.exp = 0; model.reg_time = DateTime.Now; model.reg_ip = DTRequest.GetIP(); //if (ddlGroup.SelectedValue == "0") //{ // model.group_id = 1; //} //else //{ model.group_id = Utils.StringToNum(ddlGroup.SelectedValue); model.dianming = txtIntroduce.Value; //model.dianmiaoshu = dianmiaoshu.Value; //model.congye = congye.Value; model.gongsi = gongsi.Value; model.fuwuquyu = CompanyName.Value; //model.fuwuquyu = fuwuquyu.Value; //model.shuxishequ = shuxishequ.Value; //model.fuwutechang = fuwutechang.Value; //model.jingli = jingli.Value; //model.zhengshu = zhengshu.Value; model.note = note.Value; model.is_lock = 1; //} if (bll.Add(model) < 1) { this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('網路異常,請重試')</script>"); } else { login(); //this.Page.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('註冊成功,請登入');window.location.href='login.aspx'</script>"); } }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //获取用户旧数据 Model.users model = GetModel(id); if (model == null) { return(false); } List <CommandInfo> sqllist = new List <CommandInfo>(); //删除积分记录 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "user_point_log "); strSql1.Append(" where user_id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters1[0].Value = id; CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //删除金额记录 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "user_amount_log "); strSql2.Append(" where user_id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //删除短消息 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "user_message "); strSql3.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); SqlParameter[] parameters3 = { new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100) }; parameters3[0].Value = model.user_name; parameters3[1].Value = model.user_name; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //删除申请码 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_code "); strSql4.Append(" where user_id=@id"); SqlParameter[] parameters4 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters4[0].Value = id; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //删除登录日志 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "user_login_log "); strSql5.Append(" where user_id=@id"); SqlParameter[] parameters5 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //删除用户记录 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); int rowsAffected = DbHelperSQL.ExecuteSqlTran(sqllist); if (rowsAffected > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// <param name="typeId"> 1增加团长级别用户 </param> /// </summary> public int Add(Model.users model, int typeId) { return(dal.Add(model, typeId)); }
private void user_register(HttpContext context) { string site = DTRequest.GetQueryString("site").Trim(); //当前站点 string code = DTRequest.GetFormString("txtCode").Trim(); string username = Utils.ToHtml(DTRequest.GetFormString("txtUserName").Trim()); 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(); #region 验证各种参数信息 //检查站点目录是否正确 if (string.IsNullOrEmpty(site)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,网站传输参数有误!\"}"); return; } //检查是否开启会员功能 if (siteConfig.memberstatus == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,会员功能已关闭,无法注册!\"}"); return; } if (userConfig.regstatus == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,系统暂不允许注册新用户!\"}"); return; } //检查用户输入信息是否为空 if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,用户名和密码不能为空!\"}"); return; } //如果开启手机注册则要验证手机 if (userConfig.regstatus == 2 && string.IsNullOrEmpty(mobile)) { context.Response.Write("{\"status\":0, \"msg\":\"错误:手机号码不能为空!\"}"); return; } //如果开启邮箱注册则要验证邮箱 if (userConfig.regstatus == 3 && string.IsNullOrEmpty(email)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,电子邮箱不能为空!\"}"); return; } //检查用户名 BLL.users bll = new BLL.users(); if (bll.Exists(username)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,该用户名已经存在!\"}"); return; } //如果开启手机登录要验证手机 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; } } //检查同一IP注册时隔 if (userConfig.regctrl > 0) { if (bll.Exists(userip, userConfig.regctrl)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,同IP在" + userConfig.regctrl + "小时内禁止重复注册!\"}"); return; } } //检查默认组别是否存在 Model.user_groups modelGroup = new BLL.user_groups().GetDefault(); if (modelGroup == null) { context.Response.Write("{\"status\":0, \"msg\":\"用户尚未分组,请联系网站管理员!\"}"); return; } //检查验证码是否正确 switch (userConfig.regstatus) { case 1: //验证网页验证码 string result1 = verify_code(context, code); if (result1 != "success") { context.Response.Write(result1); return; } break; case 2: //验证手机验证码 string result2 = verify_sms_code(context, code); if (result2 != "success") { context.Response.Write(result2); return; } break; case 4: //验证邀请码 string result4 = verify_invite_reg(username, code); if (result4 != "success") { context.Response.Write(result4); return; } break; } #endregion #region 保存用户注册信息 Model.users model = new Model.users(); model.group_id = modelGroup.id; model.user_name = username; model.salt = Utils.GetCheckCode(6); //获得6位的salt加密字符串 model.password = DESEncrypt.Encrypt(password, model.salt); model.email = email; model.mobile = mobile; model.reg_ip = userip; model.reg_time = DateTime.Now; //设置用户状态 if (userConfig.regstatus == 3) { model.status = 1; //待验证 } else if (userConfig.regverify == 1) { model.status = 2; //待审核 } else { 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, "注册赠送金额"); } #endregion #region 是否发送欢迎消息 if (userConfig.regmsgstatus == 1) //站内短消息 { new BLL.user_message().Add(1, string.Empty, model.user_name, "欢迎您成为本站会员", userConfig.regmsgtxt); } else if (userConfig.regmsgstatus == 2 && !string.IsNullOrEmpty(email)) //发送邮件 { //取得邮件模板内容 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 && !string.IsNullOrEmpty(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); } } #endregion //需要Email验证 if (userConfig.regstatus == 3) { string result2 = send_verify_email(site, model); //发送验证邮件 if (result2 != "success") { context.Response.Write(result2); return; } context.Response.Write("{\"status\":1, \"msg\":\"注册成功,请进入邮箱验证激活账户!\", \"url\":\"" + new Web.UI.BasePage().getlink(site, new Web.UI.BasePage().linkurl("register", "?action=sendmail&username="******"\"}"); } //需要人工审核 else if (userConfig.regverify == 1) { context.Response.Write("{\"status\":1, \"msg\":\"注册成功,请等待审核通过!\", \"url\":\"" + new Web.UI.BasePage().getlink(site, new Web.UI.BasePage().linkurl("register", "?action=verify&username="******"\"}"); } else { 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, "会员登录"); context.Response.Write("{\"status\":1, \"msg\":\"注册成功,欢迎成为本站会员!\", \"url\":\"" + new Web.UI.BasePage().getlink(site, new Web.UI.BasePage().linkurl("usercenter", "index")) + "\"}"); } return; }
public bool UpdateCallBack(Model.users model) { return(dal.UpdateCallBack(model)); }
public void Register(string name, string password, string phoneNum, string authCode, string tourCard, string identityCard, int age, int workAge, int sex, int work, string signature, string headImage, string version, string equType, string equName) { //, byte[] headImage string json = String.Empty; int result = bll_user.CheckRegister(phoneNum, tourCard, identityCard); if (result == 0) { string pass = DESEncrypt.Encrypt(password); //密码加密 string onlyCode = ""; //唯一码 string nickNameStr = ""; //用户登录账号 try { int number = bll_user.GetOnlyCodeNumber(); onlyCode = number.ToString();//.PadLeft(6, '0'); nickNameStr = "sxzh" + number.ToString(); //bll_user.ModifyOnlyCodeStatus(number); } catch (Exception ex) { json = "{\"status\":\"false\",\"data\":\"" + ex.Message + "\"}"; } string nameStr = System.Web.HttpUtility.UrlDecode(name, System.Text.Encoding.UTF8); string sStr = ""; if (signature != "") { sStr = System.Web.HttpUtility.UrlDecode(signature, System.Text.Encoding.UTF8); } try { Model.users model_guide = new Model.users(); model_guide.nick_name = nameStr;//用户姓名 model_guide.user_name = nickNameStr;//用户昵称sxzh_123 唯一用来登录 model_guide.password = pass; model_guide.mobile = phoneNum; model_guide.telphone = phoneNum; model_guide.authcode = authCode; model_guide.guid_card = tourCard; model_guide.card = identityCard; model_guide.age = age; model_guide.work_age = workAge.ToString(); model_guide.sex = sex == 1 ? "男" : "女"; model_guide.work_type = workAge; model_guide.description = sStr; model_guide.onlycode = onlyCode; model_guide.avatar = ""; model_guide.is_lock = 2;//待审核 model_guide.group_id = 2;//默认为五星导游 if (!string.IsNullOrEmpty(headImage)) { UpLoad _uploadHelper = new UpLoad(); //1.定义并实例化一个内存流,以存放提交上来的字节数组。 ///2.定义实际文件对象,保存上载的文件。 model_guide.avatar = _uploadHelper.Base64ToImg(headImage); } int count = bll_user.Add(model_guide); if (count > 0) { json += "{\"status\":\"true\"}"; } else { json += "{\"status\":\"false\"}"; } } catch (Exception ex) { json = "{\"status\":\"false\",\"data\":\"" + ex.Message + "\"}"; } } else if (result == 2) //手机号已注册 { json = "{\"status\":\"false\",\"data\":\"手机号已注册\"}"; } else if (result == 3) //导游证已注册 { json = "{\"status\":\"false\",\"data\":\"导游证已注册\"}"; } else if (result == 4) //身份证已注册 { json = "{\"status\":\"false\",\"data\":\"身份证已注册\"}"; } WriteWebServiceLog(version, equType, equName, "Register", ""); Context.Response.Write(json); Context.Response.End(); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //获取用户旧数据 Model.users model = GetModel(id); if (model == null) { return(false); } List <CommandInfo> sqllist = new List <CommandInfo>(); //删除积分记录 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "user_point_log"); strSql1.Append(" where user_id=@id"); SqlParameter[] parameters1 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters1[0].Value = id; CommandInfo cmd = new CommandInfo(strSql1.ToString(), parameters1); sqllist.Add(cmd); //删除金额记录 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "user_amount_log"); strSql2.Append(" where user_id=@id"); SqlParameter[] parameters2 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters2[0].Value = id; cmd = new CommandInfo(strSql2.ToString(), parameters2); sqllist.Add(cmd); //删除附件购买记录 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "user_attach_log"); strSql3.Append(" where user_id=@id"); SqlParameter[] parameters3 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters3[0].Value = id; cmd = new CommandInfo(strSql3.ToString(), parameters3); sqllist.Add(cmd); //删除短消息 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("delete from " + databaseprefix + "user_message "); strSql4.Append(" where post_user_name=@post_user_name or accept_user_name=@accept_user_name"); SqlParameter[] parameters4 = { new SqlParameter("@post_user_name", SqlDbType.NVarChar, 100), new SqlParameter("@accept_user_name", SqlDbType.NVarChar, 100) }; parameters4[0].Value = model.user_name; parameters4[1].Value = model.user_name; cmd = new CommandInfo(strSql4.ToString(), parameters4); sqllist.Add(cmd); //删除申请码 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "user_code"); strSql5.Append(" where user_id=@id"); SqlParameter[] parameters5 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters5[0].Value = id; cmd = new CommandInfo(strSql5.ToString(), parameters5); sqllist.Add(cmd); //删除登录日志 StringBuilder strSql6 = new StringBuilder(); strSql6.Append("delete from " + databaseprefix + "user_login_log"); strSql6.Append(" where user_id=@id"); SqlParameter[] parameters6 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters6[0].Value = id; cmd = new CommandInfo(strSql6.ToString(), parameters6); sqllist.Add(cmd); //删除用户地址簿 StringBuilder strSql7 = new StringBuilder(); strSql7.Append("delete from " + databaseprefix + "user_addr_book"); strSql7.Append(" where user_id=@id"); SqlParameter[] parameters7 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters7[0].Value = id; cmd = new CommandInfo(strSql7.ToString(), parameters7); sqllist.Add(cmd); //删除OAuth授权用户信息 StringBuilder strSql8 = new StringBuilder(); strSql8.Append("delete from " + databaseprefix + "user_oauth"); strSql8.Append(" where user_id=@id"); SqlParameter[] parameters8 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters8[0].Value = id; cmd = new CommandInfo(strSql8.ToString(), parameters8); sqllist.Add(cmd); //删除用户充值表 StringBuilder strSql9 = new StringBuilder(); strSql9.Append("delete from " + databaseprefix + "user_recharge"); strSql9.Append(" where user_id=@id"); SqlParameter[] parameters9 = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters9[0].Value = id; cmd = new CommandInfo(strSql9.ToString(), parameters9); sqllist.Add(cmd); //删除用户主表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "users"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; cmd = new CommandInfo(strSql.ToString(), parameters); sqllist.Add(cmd); return(DbHelperSQL.ExecuteSqlTran(sqllist) > 0); }
/// <summary> /// 将在Init事件执行 /// </summary> protected void payment_Init(object sender, EventArgs e) { //取得处事类型 action = DTRequest.GetString("action"); order_no = DTRequest.GetString("order_no"); if (order_no.ToUpper().StartsWith("R")) //充值订单 { order_type = DTEnums.AmountTypeEnum.Recharge.ToString().ToLower(); } else if (order_no.ToUpper().StartsWith("B")) //商品订单 { order_type = DTEnums.AmountTypeEnum.BuyGoods.ToString().ToLower(); } switch (action) { case "confirm": if (string.IsNullOrEmpty(action) || string.IsNullOrEmpty(order_no)) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,URL传输参数有误!"))); return; } //是否需要支持匿名购物 userModel = new Web.UI.BasePage().GetUserInfo(); //取得用户登录信息 if (orderConfig.anonymous == 0 || order_no.ToUpper().StartsWith("R")) { if (userModel == null) { //用户未登录 HttpContext.Current.Response.Redirect(linkurl("payment", "?action=login")); return; } } else if (userModel == null) { userModel = new Model.users(); } //检查订单的类型(充值或购物) if (order_no.ToUpper().StartsWith("R")) //充值订单 { rechargeModel = new BLL.user_recharge().GetModel(order_no); if (rechargeModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } //检查订单号是否已支付 if (rechargeModel.status == 1) { HttpContext.Current.Response.Redirect(linkurl("payment", "?action=succeed&order_no=" + rechargeModel.recharge_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(rechargeModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!"))); return; } //检查是否线上支付 if (payModel.type == 2) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,账户充值不允许线下支付!"))); return; } order_amount = rechargeModel.amount; //订单金额 } else if (order_no.ToUpper().StartsWith("B")) //商品订单 { //检查订单是否存在 orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } //检查是否已支付过 if (orderModel.payment_status == 2) { HttpContext.Current.Response.Redirect(linkurl("payment", "?action=succeed&order_no=" + orderModel.order_no)); return; } //检查支付方式 payModel = new BLL.payment().GetModel(orderModel.payment_id); if (payModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,支付方式不存在或已删除!"))); return; } //检查是否线下付款 if (orderModel.payment_status == 0) { HttpContext.Current.Response.Redirect(linkurl("payment", "?action=succeed&order_no=" + orderModel.order_no)); return; } //检查是否积分换购,直接跳转成功页面 if (orderModel.order_amount == 0) { //修改订单状态 bool result = new BLL.orders().UpdateField(orderModel.order_no, "status=2,payment_status=2,payment_time='" + DateTime.Now + "'"); if (!result) { HttpContext.Current.Response.Redirect(linkurl("payment", "?action=error")); return; } HttpContext.Current.Response.Redirect(linkurl("payment", "?action=succeed&order_no=" + orderModel.order_no)); return; } order_amount = orderModel.order_amount; //订单金额 } else { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!"))); return; } break; case "succeed": //检查订单的类型(充值或购物) if (order_no.ToUpper().StartsWith("R")) //充值订单 { rechargeModel = new BLL.user_recharge().GetModel(order_no); if (rechargeModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } } else if (order_no.ToUpper().StartsWith("B")) //商品订单 { orderModel = new BLL.orders().GetModel(order_no); if (orderModel == null) { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,订单号不存在或已删除!"))); return; } } else { HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦,找不到您要提交的订单类型!"))); return; } break; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into dt_users("); strSql.Append("group_id,user_name,password,email,nick_name,avatar,sex,birthday,telphone,mobile,qq,address,safe_question,safe_answer,amount,point,exp,is_lock,reg_time,reg_ip,dianming,dianmiaoshu,congye,gongsi,fuwuquyu,shuxishequ,fuwutechang,jingli,zhengshu,note,isVip)"); strSql.Append(" values ("); strSql.Append("@group_id,@user_name,@password,@email,@nick_name,@avatar,@sex,@birthday,@telphone,@mobile,@qq,@address,@safe_question,@safe_answer,@amount,@point,@exp,@is_lock,@reg_time,@reg_ip,@dianming,@dianmiaoshu,@congye,@gongsi,@fuwuquyu,@shuxishequ,@fuwutechang,@jingli,@zhengshu,@note,@isVip)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@point", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@is_lock", SqlDbType.TinyInt, 1), new SqlParameter("@reg_time", SqlDbType.DateTime), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@dianming", SqlDbType.NVarChar, 255), new SqlParameter("@dianmiaoshu", SqlDbType.NVarChar, 255), new SqlParameter("@congye", SqlDbType.NVarChar, 255), new SqlParameter("@gongsi", SqlDbType.NVarChar, 255), new SqlParameter("@fuwuquyu", SqlDbType.NVarChar, 255), new SqlParameter("@shuxishequ", SqlDbType.NVarChar, 30), new SqlParameter("@fuwutechang", SqlDbType.NVarChar, 255), new SqlParameter("@jingli", SqlDbType.Text), new SqlParameter("@zhengshu", SqlDbType.Text), new SqlParameter("@note", SqlDbType.Text), new SqlParameter("@isVip", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.password; parameters[3].Value = model.email; parameters[4].Value = model.nick_name; parameters[5].Value = model.avatar; parameters[6].Value = model.sex; parameters[7].Value = model.birthday; parameters[8].Value = model.telphone; parameters[9].Value = model.mobile; parameters[10].Value = model.qq; parameters[11].Value = model.address; parameters[12].Value = model.safe_question; parameters[13].Value = model.safe_answer; parameters[14].Value = model.amount; parameters[15].Value = model.point; parameters[16].Value = model.exp; parameters[17].Value = model.is_lock; parameters[18].Value = model.reg_time; parameters[19].Value = model.reg_ip; parameters[20].Value = model.dianming; parameters[21].Value = model.dianmiaoshu; parameters[22].Value = model.congye; parameters[23].Value = model.gongsi; parameters[24].Value = model.fuwuquyu; parameters[25].Value = model.shuxishequ; parameters[26].Value = model.fuwutechang; parameters[27].Value = model.jingli; parameters[28].Value = model.zhengshu; parameters[29].Value = model.note; parameters[30].Value = model.isVip; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
private void user_register(HttpContext context) { string code = DTRequest.GetFormString("txtCode").Trim(); string invitecode = DTRequest.GetFormString("txtInviteCode").Trim(); string username = DTRequest.GetFormString("txtUserName").Trim(); string password = DTRequest.GetFormString("txtPassword").Trim(); string email = DTRequest.GetFormString("txtEmail").Trim(); string userip = DTRequest.GetIP(); #region 检查各项并提示 //检查是否开启会员功能 if (siteConfig.memberstatus == 0) { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,会员功能已被关闭,无法注册新会员!\"}"); return; } if (userConfig.regstatus == 0) { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,系统暂不允许注册新用户!\"}"); return; } //校检验证码 string result = verify_code(context, code); if (result != "success") { context.Response.Write(result); return; } //检查用户输入信息是否为空 if (username == "" || password == "") { context.Response.Write("{\"msg\":0, \"msgbox\":\"用户名和密码不能为空!\"}"); return; } if (email == "") { context.Response.Write("{\"msg\":0, \"msgbox\":\"电子邮箱不能为空!\"}"); return; } //检查用户名 BLL.users bll = new BLL.users(); Model.users model = new Model.users(); if (bll.Exists(username)) { context.Response.Write("{\"msg\":0, \"msgbox\":\"该用户名已经存在!\"}"); return; } //检查同一IP注册时隔 if (userConfig.regctrl > 0) { if (bll.Exists(userip, userConfig.regctrl)) { context.Response.Write("{\"msg\":0, \"msgbox\":\"对不起,同一IP在" + userConfig.regctrl + "小时内不能注册多个用户!\"}"); return; } } //不允许同一Email注册不同用户 if (userConfig.regemailditto == 0) { if (bll.ExistsEmail(email)) { context.Response.Write("{\"msg\":0, \"msgbox\":\"Email不允许重复注册,如果你忘记用户名,请找回密码!\"}"); return; } } //检查默认组别是否存在 Model.user_groups modelGroup = new BLL.user_groups().GetDefault(); if (modelGroup == null) { context.Response.Write("{\"msg\":0, \"msgbox\":\"系统尚未分组,请联系管理员设置会员分组!\"}"); return; } //检查是否通过邀请码注册 if (userConfig.regstatus == 2) { string result1 = verify_invite_reg(username, invitecode); if (result1 != "success") { context.Response.Write(result1); return; } } #endregion //保存注册信息 model.group_id = modelGroup.id; model.user_name = username; model.password = DESEncrypt.Encrypt(password); model.email = email; model.reg_ip = userip; model.reg_time = DateTime.Now; model.is_lock = userConfig.regverify; //设置为对应状态 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); } //需要Email验证 if (userConfig.regverify == 1) { string result2 = verify_email(model); if (result2 != "success") { context.Response.Write(result2); return; } context.Response.Write("{\"msg\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=sendmail&username="******"\", \"msgbox\":\"注册成功,请进入邮箱验证激活账户!\"}"); } //需要人工审核 else if (userConfig.regverify == 2) { context.Response.Write("{\"msg\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=verify&username="******"\", \"msgbox\":\"注册成功,请等待审核通过!\"}"); } else { context.Response.Write("{\"msg\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=succeed&username="******"\", \"msgbox\":\"恭喜您,注册成功啦!\"}"); } return; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.users model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update dt_users set "); strSql.Append("group_id=@group_id,"); strSql.Append("user_name=@user_name,"); strSql.Append("password=@password,"); strSql.Append("email=@email,"); strSql.Append("nick_name=@nick_name,"); strSql.Append("avatar=@avatar,"); strSql.Append("sex=@sex,"); strSql.Append("birthday=@birthday,"); strSql.Append("telphone=@telphone,"); strSql.Append("mobile=@mobile,"); strSql.Append("qq=@qq,"); strSql.Append("address=@address,"); strSql.Append("safe_question=@safe_question,"); strSql.Append("safe_answer=@safe_answer,"); strSql.Append("amount=@amount,"); strSql.Append("isHirePoints=@isHirePoints,"); strSql.Append("exp=@exp,"); strSql.Append("is_lock=@is_lock,"); strSql.Append("isDonePoints=@isDonePoints,"); strSql.Append("reg_ip=@reg_ip,"); strSql.Append("dianming=@dianming,"); strSql.Append("dianmiaoshu=@dianmiaoshu,"); strSql.Append("congye=@congye,"); strSql.Append("gongsi=@gongsi,"); strSql.Append("fuwuquyu=@fuwuquyu,"); strSql.Append("shuxishequ=@shuxishequ,"); strSql.Append("fuwutechang=@fuwutechang,"); strSql.Append("jingli=@jingli,"); strSql.Append("zhengshu=@zhengshu,"); strSql.Append("note=@note,"); strSql.Append("isVip=@isVip,"); strSql.Append("isAd=@isAd,"); strSql.Append("isMac=@isMac"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@group_id", SqlDbType.Int, 4), new SqlParameter("@user_name", SqlDbType.NVarChar, 100), new SqlParameter("@password", SqlDbType.NVarChar, 100), new SqlParameter("@email", SqlDbType.NVarChar, 50), new SqlParameter("@nick_name", SqlDbType.NVarChar, 100), new SqlParameter("@avatar", SqlDbType.NVarChar, 255), new SqlParameter("@sex", SqlDbType.NVarChar, 20), new SqlParameter("@birthday", SqlDbType.DateTime), new SqlParameter("@telphone", SqlDbType.NVarChar, 50), new SqlParameter("@mobile", SqlDbType.NVarChar, 20), new SqlParameter("@qq", SqlDbType.NVarChar, 30), new SqlParameter("@address", SqlDbType.NVarChar, 255), new SqlParameter("@safe_question", SqlDbType.NVarChar, 255), new SqlParameter("@safe_answer", SqlDbType.NVarChar, 255), new SqlParameter("@amount", SqlDbType.Decimal, 5), new SqlParameter("@isHirePoints", SqlDbType.Int, 4), new SqlParameter("@exp", SqlDbType.Int, 4), new SqlParameter("@is_lock", SqlDbType.TinyInt, 1), new SqlParameter("@isDonePoints", SqlDbType.Int, 4), new SqlParameter("@reg_ip", SqlDbType.NVarChar, 30), new SqlParameter("@dianming", SqlDbType.NVarChar, 255), new SqlParameter("@dianmiaoshu", SqlDbType.NVarChar, 255), new SqlParameter("@congye", SqlDbType.NVarChar, 255), new SqlParameter("@gongsi", SqlDbType.NVarChar, 255), new SqlParameter("@fuwuquyu", SqlDbType.NVarChar, 255), new SqlParameter("@shuxishequ", SqlDbType.NVarChar, 30), new SqlParameter("@fuwutechang", SqlDbType.NVarChar, 255), new SqlParameter("@jingli", SqlDbType.Text), new SqlParameter("@zhengshu", SqlDbType.Text), new SqlParameter("@note", SqlDbType.Text), new SqlParameter("@isVip", SqlDbType.TinyInt, 1), new SqlParameter("@isAd", SqlDbType.Int, 4), new SqlParameter("@isMac", SqlDbType.Int, 4), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.group_id; parameters[1].Value = model.user_name; parameters[2].Value = model.password; parameters[3].Value = model.email; parameters[4].Value = model.nick_name; parameters[5].Value = model.avatar; parameters[6].Value = model.sex; parameters[7].Value = model.birthday; parameters[8].Value = model.telphone; parameters[9].Value = model.mobile; parameters[10].Value = model.qq; parameters[11].Value = model.address; parameters[12].Value = model.safe_question; parameters[13].Value = model.safe_answer; parameters[14].Value = model.amount; parameters[15].Value = model.isHirePoints; parameters[16].Value = model.exp; parameters[17].Value = model.is_lock; parameters[18].Value = model.isDonePoints; parameters[19].Value = model.reg_ip; parameters[20].Value = model.dianming; parameters[21].Value = model.dianmiaoshu; parameters[22].Value = model.congye; parameters[23].Value = model.gongsi; parameters[24].Value = model.fuwuquyu; parameters[25].Value = model.shuxishequ; parameters[26].Value = model.fuwutechang; parameters[27].Value = model.jingli; parameters[28].Value = model.zhengshu; parameters[29].Value = model.note; parameters[30].Value = model.isVip; parameters[31].Value = model.isAd; parameters[32].Value = model.isMac; parameters[33].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.users DataRowToModel(DataRow row) { Model.users model = new Model.users(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["group_id"] != null && row["group_id"].ToString() != "") { model.group_id = int.Parse(row["group_id"].ToString()); } if (row["user_name"] != null) { model.user_name = row["user_name"].ToString(); } if (row["salt"] != null) { model.salt = row["salt"].ToString(); } if (row["password"] != null) { model.password = row["password"].ToString(); } if (row["mobile"] != null) { model.mobile = row["mobile"].ToString(); } if (row["email"] != null) { model.email = row["email"].ToString(); } if (row["avatar"] != null) { model.avatar = row["avatar"].ToString(); } if (row["nick_name"] != null) { model.nick_name = row["nick_name"].ToString(); } if (row["sex"] != null) { model.sex = row["sex"].ToString(); } if (row["birthday"] != null && row["birthday"].ToString() != "") { model.birthday = DateTime.Parse(row["birthday"].ToString()); } if (row["telphone"] != null) { model.telphone = row["telphone"].ToString(); } if (row["area"] != null) { model.area = row["area"].ToString(); } if (row["address"] != null) { model.address = row["address"].ToString(); } if (row["qq"] != null) { model.qq = row["qq"].ToString(); } if (row["msn"] != null) { model.msn = row["msn"].ToString(); } if (row["amount"] != null && row["amount"].ToString() != "") { model.amount = decimal.Parse(row["amount"].ToString()); } if (row["point"] != null && row["point"].ToString() != "") { model.point = int.Parse(row["point"].ToString()); } if (row["exp"] != null && row["exp"].ToString() != "") { model.exp = int.Parse(row["exp"].ToString()); } if (row["status"] != null && row["status"].ToString() != "") { model.status = int.Parse(row["status"].ToString()); } if (row["reg_time"] != null && row["reg_time"].ToString() != "") { model.reg_time = DateTime.Parse(row["reg_time"].ToString()); } if (row["reg_ip"] != null) { model.reg_ip = row["reg_ip"].ToString(); } } return(model); }
private void user_register(HttpContext context) { string code = DTRequest.GetFormString("txtCode").Trim(); string invitecode = DTRequest.GetFormString("txtInviteCode").Trim(); string username = Utils.ToHtml(DTRequest.GetFormString("txtUserName").Trim()); 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(); #region 检查各项并提示 //检查是否开启会员功能 if (siteConfig.memberstatus == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,会员功能已关闭,无法注册!\"}"); return; } if (userConfig.regstatus == 0) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,系统暂不允许注册新用户!\"}"); return; } //校检验证码,如果注册使用手机短信则只需验证手机验证码,否则使用网页验证码 if (userConfig.regstatus == 2) //手机验证码 { string result = verify_sms_code(context, code); if (result != "success") { context.Response.Write(result); return; } } else //网页验证码 { string result = verify_code(context, code); if (result != "success") { context.Response.Write(result); return; } } //检查用户输入信息是否为空 if (username == "" || password == "") { context.Response.Write("{\"status\":0, \"msg\":\"错误:用户名和密码不能为空!\"}"); return; } if (userConfig.regemailditto == 0 && email == "") { context.Response.Write("{\"status\":0, \"msg\":\"错误:电子邮箱不能为空!\"}"); return; } if (userConfig.mobilelogin == 1 && mobile == "") { context.Response.Write("{\"status\":0, \"msg\":\"错误:手机号码不能为空!\"}"); return; } //检查用户名 BLL.users bll = new BLL.users(); Model.users model = new Model.users(); if (bll.Exists(username)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,该用户名已经存在!\"}"); return; } //检查同一IP注册时隔 if (userConfig.regctrl > 0) { if (bll.Exists(userip, userConfig.regctrl)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,同IP在" + userConfig.regctrl + "小时内禁止重复注册!\"}"); return; } } //不允许同一Email注册不同用户 if (userConfig.regemailditto == 0 || userConfig.emaillogin == 1) { if (bll.ExistsEmail(email)) { context.Response.Write("{\"status\":0, \"msg\":\"对不起,该邮箱已被注册!\"}"); return; } } //不允许同一手机号码注册不同用户 if (userConfig.mobilelogin == 1) { if (bll.ExistsMobile(mobile)) { 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; } //检查是否通过邀请码注册 if (userConfig.regstatus == 2) { string result1 = verify_invite_reg(username, invitecode); if (result1 != "success") { context.Response.Write(result1); return; } } #endregion //保存注册信息 model.group_id = modelGroup.id; model.user_name = username; model.salt = Utils.GetCheckCode(6); //获得6位的salt加密字符串 model.password = DESEncrypt.Encrypt(password, model.salt); model.email = email; model.mobile = mobile; model.reg_ip = userip; model.reg_time = DateTime.Now; //设置对应的状态 switch (userConfig.regverify) { case 0: model.status = 0; //正常 break; case 3: model.status = 2; //人工审核 break; default: model.status = 1; //待验证 break; } 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, DTEnums.AmountTypeEnum.SysGive.ToString(), modelGroup.amount, "注册赠送金额", 1); } #region 判断是否发送欢迎消息 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.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); } } #endregion //需要Email验证 if (userConfig.regverify == 1) { string result2 = verify_email(model); if (result2 != "success") { context.Response.Write(result2); return; } context.Response.Write("{\"status\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=sendmail&username="******"\", \"msg\":\"注册成功,请进入邮箱验证激活账户!\"}"); } //手机短信验证 else if (userConfig.regverify == 2) { string result3 = verify_mobile(model); if (result3 != "success") { context.Response.Write(result3); return; } context.Response.Write("{\"status\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=sendsms&username="******"\", \"msg\":\"注册成功,请查收短信验证激活账户!\"}"); } //需要人工审核 else if (userConfig.regverify == 3) { context.Response.Write("{\"status\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=verify&username="******"\", \"msg\":\"注册成功,请等待审核通过!\"}"); } else { 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, "会员登录"); context.Response.Write("{\"status\":1, \"url\":\"" + new Web.UI.BasePage().linkurl("register") + "?action=succeed&username="******"\", \"msg\":\"注册成功,欢迎成为本站会员!\"}"); } return; }