/// <summary> /// 验证用户token是否有用 /// </summary> /// <param name="memberid"></param> /// <returns></returns> public static string getUserToke(string memberid) { string membertoken = ""; System.Model.t_custom tc = _bll.tcbll.GetModel(Utility.Helper.gerInt(memberid)); if (tc != null) { membertoken = tc.id.ToString(); } return(membertoken); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Model.t_custom model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_custom set "); strSql.Append(" phone = @phone , "); strSql.Append(" pwd = @pwd , "); strSql.Append(" nicheng = @nicheng , "); strSql.Append(" img = @img , "); strSql.Append(" name = @name , "); strSql.Append(" pudate = @pudate , "); strSql.Append(" yqm = @yqm , "); strSql.Append(" syMoney = @syMoney , "); strSql.Append(" syJf = @syJf "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@phone", SqlDbType.NVarChar, 50), new SqlParameter("@pwd", SqlDbType.NVarChar, 50), new SqlParameter("@nicheng", SqlDbType.NVarChar, 50), new SqlParameter("@img", SqlDbType.NVarChar, 200), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@pudate", SqlDbType.NVarChar, 50), new SqlParameter("@yqm", SqlDbType.NVarChar, 50), new SqlParameter("@syMoney", SqlDbType.Money, 8), new SqlParameter("@syJf", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.phone; parameters[2].Value = model.pwd; parameters[3].Value = model.nicheng; parameters[4].Value = model.img; parameters[5].Value = model.name; parameters[6].Value = model.pudate; parameters[7].Value = model.yqm; parameters[8].Value = model.syMoney; parameters[9].Value = model.syJf; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public System.Model.t_custom GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, phone, pwd, nicheng, img, name, pudate, yqm, syMoney, syJf "); strSql.Append(" from t_custom "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; System.Model.t_custom model = new System.Model.t_custom(); 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()); } model.phone = ds.Tables[0].Rows[0]["phone"].ToString(); model.pwd = ds.Tables[0].Rows[0]["pwd"].ToString(); model.nicheng = ds.Tables[0].Rows[0]["nicheng"].ToString(); model.img = ds.Tables[0].Rows[0]["img"].ToString(); model.name = ds.Tables[0].Rows[0]["name"].ToString(); model.pudate = ds.Tables[0].Rows[0]["pudate"].ToString(); model.yqm = ds.Tables[0].Rows[0]["yqm"].ToString(); if (ds.Tables[0].Rows[0]["syMoney"].ToString() != "") { model.syMoney = decimal.Parse(ds.Tables[0].Rows[0]["syMoney"].ToString()); } if (ds.Tables[0].Rows[0]["syJf"].ToString() != "") { model.syJf = int.Parse(ds.Tables[0].Rows[0]["syJf"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(System.Model.t_custom model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_custom("); strSql.Append("phone,pwd,nicheng,img,name,pudate,yqm,syMoney,syJf"); strSql.Append(") values ("); strSql.Append("@phone,@pwd,@nicheng,@img,@name,@pudate,@yqm,@syMoney,@syJf"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@phone", SqlDbType.NVarChar, 50), new SqlParameter("@pwd", SqlDbType.NVarChar, 50), new SqlParameter("@nicheng", SqlDbType.NVarChar, 50), new SqlParameter("@img", SqlDbType.NVarChar, 200), new SqlParameter("@name", SqlDbType.NVarChar, 50), new SqlParameter("@pudate", SqlDbType.NVarChar, 50), new SqlParameter("@yqm", SqlDbType.NVarChar, 50), new SqlParameter("@syMoney", SqlDbType.Money, 8), new SqlParameter("@syJf", SqlDbType.Int, 4) }; parameters[0].Value = model.phone; parameters[1].Value = model.pwd; parameters[2].Value = model.nicheng; parameters[3].Value = model.img; parameters[4].Value = model.name; parameters[5].Value = model.pudate; parameters[6].Value = model.yqm; parameters[7].Value = model.syMoney; parameters[8].Value = model.syJf; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获得数据列表 /// </summary> public List <System.Model.t_custom> DataTableToList(DataTable dt) { List <System.Model.t_custom> modelList = new List <System.Model.t_custom>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { System.Model.t_custom model; for (int n = 0; n < rowsCount; n++) { model = new System.Model.t_custom(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } model.phone = dt.Rows[n]["phone"].ToString(); model.pwd = dt.Rows[n]["pwd"].ToString(); model.nicheng = dt.Rows[n]["nicheng"].ToString(); model.img = dt.Rows[n]["img"].ToString(); model.name = dt.Rows[n]["name"].ToString(); model.pudate = dt.Rows[n]["pudate"].ToString(); model.yqm = dt.Rows[n]["yqm"].ToString(); if (dt.Rows[n]["syMoney"].ToString() != "") { model.syMoney = decimal.Parse(dt.Rows[n]["syMoney"].ToString()); } if (dt.Rows[n]["syJf"].ToString() != "") { model.syJf = int.Parse(dt.Rows[n]["syJf"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Model.t_custom model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(System.Model.t_custom model) { return(dal.Add(model)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string res = ""; JsonData jsonResult = new JsonData(); try { string phone = Request["phone"] != null?Utility.Helper.Checkstr(Request["phone"]) : ""; string authcode = Request["authcode"] != null?Utility.Helper.Checkstr(Request["authcode"]) : ""; string pushtype = Request["pushtype"] != null?Utility.Helper.Checkstr(Request["pushtype"]) : ""; string token = Request["token"] != null?Utility.Helper.Checkstr(Request["token"]) : ""; #region 登录 //log.setlog("", phone + " " + authcode + " " + pushtype + " " + token); if (!string.IsNullOrEmpty(phone) && !string.IsNullOrEmpty(authcode)) { //判断是否有用户 string memberid = ""; string strwhere = " phone='" + phone + "' "; string authcodeSession = Session["authcode"] as string; string vcodewhere = " verificationMode ='" + phone + "' and code='" + authcode + "' and edate> '" + System.DateTime.Now + "' "; List <System.Model.verification_code> vc = _bll.vcbll.GetModelList(vcodewhere); if (vc.Count > 0) { //if (!string.IsNullOrEmpty(authcodeSession)) //{ List <System.Model.t_custom> tclist = _bll.tcbll.GetModelList(strwhere); if (tclist.Count > 0) { //有 直接登录 添加登录日志 memberid = tclist[0].id.ToString(); System.Model.t_login_log tll = new System.Model.t_login_log(); tll.phone = phone; tll.authcode = authcode; tll.pudate = System.DateTime.Now; _bll.tllbll.Add(tll); } else { //无 添加用户 登录 添加登录日志 System.Model.t_custom tc = new System.Model.t_custom(); tc.img = ""; tc.name = ""; tc.nicheng = ""; tc.phone = phone; tc.pudate = System.DateTime.Now.ToString(); tc.pwd = ""; tc.syJf = 0; tc.syMoney = 0; tc.yqm = Utility.Helper.rnds(6); _bll.tcbll.Add(tc); List <System.Model.t_custom> tclist1 = _bll.tcbll.GetModelList(strwhere); if (tclist1.Count > 0) { memberid = tclist1[0].id.ToString(); System.Model.t_login_log tll = new System.Model.t_login_log(); tll.phone = phone; tll.authcode = authcode; tll.pudate = System.DateTime.Now; _bll.tllbll.Add(tll); } } #region 判断token是否有用 if (!string.IsNullOrEmpty(pushtype) && !string.IsNullOrEmpty(token)) { addpushtoken(memberid, pushtype, token); } #endregion strwhere = " customId='" + memberid + "' and device='" + pushtype + "' "; List <System.Model.apush_token> at = _bll.atbll.GetModelList(strwhere); int ispush = 0; if (at.Count > 0) { ispush = at[0].isstartusing; } jsonResult["res"] = (int)MyEnum.ResultEnum.成功; jsonResult["msg"] = "登录成功"; jsonResult["memberid"] = memberid; jsonResult["phone"] = phone; jsonResult["ispust"] = ispush; jsonResult["code"] = ""; } else { jsonResult["res"] = (int)MyEnum.ResultEnum.失败; jsonResult["msg"] = "登录失败"; jsonResult["memberid"] = ""; jsonResult["code"] = "验证码失效"; } } else { jsonResult["res"] = (int)MyEnum.ResultEnum.失败; jsonResult["msg"] = "登录失败"; jsonResult["memberid"] = ""; jsonResult["code"] = "参数缺失"; } #endregion } catch (Exception ex) { jsonResult["result"] = (int)MyEnum.ResultEnum.系统错误; jsonResult["msg"] = "服务器繁忙,请稍后再试"; jsonResult["code"] = ex.Message; } res = JsonMapper.ToJson(jsonResult); res = MyString.UnicodeToString(res); Response.Write(res); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string res = ""; JsonData jsonResult = new JsonData(); try { string memberid = _bll.getUserToke(Utility.Helper.gerString(Request["memberid"])); if (!string.IsNullOrEmpty(memberid)) { //判断是否有用户 System.Model.t_custom tclist = _bll.tcbll.GetModel(Utility.Helper.gerInt(memberid)); if (tclist != null) { string strwhere = " customId='" + memberid + "' "; List <System.Model.apush_token> at = _bll.atbll.GetModelList(strwhere); int ispush = 0; if (at.Count > 0) { ispush = at[0].isstartusing; } jsonResult["res"] = (int)MyEnum.ResultEnum.成功; jsonResult["msg"] = "登录成功"; jsonResult["memberid"] = memberid; jsonResult["phone"] = tclist.phone; jsonResult["ispust"] = ispush; jsonResult["code"] = ""; } else { jsonResult["res"] = (int)MyEnum.ResultEnum.失败; jsonResult["msg"] = "未找到用户"; jsonResult["memberid"] = ""; jsonResult["code"] = "用户信息有误"; } } else { jsonResult["res"] = (int)MyEnum.ResultEnum.失败; jsonResult["msg"] = "登录失败"; jsonResult["memberid"] = ""; jsonResult["code"] = "参数缺失"; } } catch (Exception ex) { jsonResult["result"] = (int)MyEnum.ResultEnum.系统错误; jsonResult["msg"] = "服务器繁忙,请稍后再试"; jsonResult["code"] = ex.Message; } res = JsonMapper.ToJson(jsonResult); res = MyString.UnicodeToString(res); Response.Write(res); } }