/// <summary> /// 向数据库中插入一条新记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_tb_UsersModel">tb_Users实体</param> /// <returns>新插入记录的编号</returns> public int Insert(SqlTransaction sp, tb_UsersEntity _tb_UsersModel) { string sqlStr = "insert into tb_Users([Phone],[Pwd],[RealName],[Mail],[LocationId],[Addtime],[IdCard],[IdentityType],[OpenID]) values(@Phone,@Pwd,@RealName,@Mail,@LocationId,@Addtime,@IdCard,@IdentityType,@OpenID) select @@identity"; int res; SqlParameter[] _param = { new SqlParameter("@Phone", SqlDbType.VarChar), new SqlParameter("@Pwd", SqlDbType.VarChar), new SqlParameter("@RealName", SqlDbType.VarChar), new SqlParameter("@Mail", SqlDbType.VarChar), new SqlParameter("@LocationId", SqlDbType.Int), new SqlParameter("@Addtime", SqlDbType.DateTime), new SqlParameter("@IdCard", SqlDbType.VarChar), new SqlParameter("@IdentityType", SqlDbType.Int), new SqlParameter("@OpenID", SqlDbType.VarChar) }; _param[0].Value = _tb_UsersModel.Phone; _param[1].Value = _tb_UsersModel.Pwd; _param[2].Value = _tb_UsersModel.RealName; _param[3].Value = _tb_UsersModel.Mail; _param[4].Value = _tb_UsersModel.LocationId; _param[5].Value = _tb_UsersModel.Addtime; _param[6].Value = _tb_UsersModel.IdCard; _param[7].Value = _tb_UsersModel.IdentityType; _param[8].Value = _tb_UsersModel.OpenID; res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param)); return(res); }
protected override void BasePage_Load(tb_UsersEntity user) { if (user != null) { BindData(); } }
/// <summary> /// 向数据表tb_Users更新一条记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_tb_UsersModel">_tb_UsersModel</param> /// <returns>影响的行数</returns> public int Update(SqlTransaction sp, tb_UsersEntity _tb_UsersModel) { string sqlStr = "update tb_Users set [Phone]=@Phone,[Pwd]=@Pwd,[RealName]=@RealName,[Mail]=@Mail,[LocationId]=@LocationId,[Addtime]=@Addtime,[IdCard]=@IdCard,[IdentityType]=@IdentityType,OpenID=@OpenID where UserId=@UserId"; SqlParameter[] _param = { new SqlParameter("@UserId", SqlDbType.Int), new SqlParameter("@Phone", SqlDbType.VarChar), new SqlParameter("@Pwd", SqlDbType.VarChar), new SqlParameter("@RealName", SqlDbType.VarChar), new SqlParameter("@Mail", SqlDbType.VarChar), new SqlParameter("@LocationId", SqlDbType.Int), new SqlParameter("@Addtime", SqlDbType.DateTime), new SqlParameter("@IdCard", SqlDbType.VarChar), new SqlParameter("@IdentityType", SqlDbType.Int), new SqlParameter("@OpenID", SqlDbType.VarChar), }; _param[0].Value = _tb_UsersModel.UserId; _param[1].Value = _tb_UsersModel.Phone; _param[2].Value = _tb_UsersModel.Pwd; _param[3].Value = _tb_UsersModel.RealName; _param[4].Value = _tb_UsersModel.Mail; _param[5].Value = _tb_UsersModel.LocationId; _param[6].Value = _tb_UsersModel.Addtime; _param[7].Value = _tb_UsersModel.IdCard; _param[8].Value = _tb_UsersModel.IdentityType; _param[9].Value = _tb_UsersModel.OpenID; return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param)); }
protected override void BasePage_Load(tb_UsersEntity user) { // PlateNumber = PlateNumber.Replace("+", "%20"); //PlateNumber = System.Web.HttpUtility.UrlDecode(PlateNumber, System.Text.Encoding.GetEncoding("GB2312")); AutoRepair.Entity.T_AutoInfoEntity model = AutoRepair.BLL.T_AutoInfoBLL.GetInstance().Get_CarinDetailOne(PlateNumber); if (model != null) { PlateColor = model.PlateColor; VIN = model.VIN; AutoBrand = model.AutoBrand; AutoType = model.AutoType; UnitName = model.UnitName; LinkMan = model.LinkMan; Phone = model.Phone; EngineNumber = model.EngineNumber; AutoColor = model.AutoColor; ChassisNumber = model.ChassisNumber; CardNumber = model.CardNumber; UnitID = model.UnitID; UploadTime = model.EnforceInsuranceDate; n = 1; } else { n = 0; } }
protected override void BasePage_Load(tb_UsersEntity user) { if (user != null) { DataSet ds = AutoRepair.BLL.tb_EvaluateBLL.GetInstance().GetEvaluationDetail(id); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0) { Isbool = ds.Tables[0].Rows[0]["AssessCount2"].ToString(); rptEvaluation.DataSource = ds; rptEvaluation.DataBind(); } } }
/// <summary> /// 得到 tb_users 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>tb_users 数据实体</returns> public tb_UsersEntity Populate_tb_UsersEntity_FromDr(IDataReader dr) { tb_UsersEntity Obj = new tb_UsersEntity(); Obj.UserId = ((dr["UserId"]) == DBNull.Value)?0:Convert.ToInt32(dr["UserId"]); Obj.Phone = dr["Phone"].ToString(); Obj.Pwd = dr["Pwd"].ToString(); Obj.RealName = dr["RealName"].ToString(); Obj.Mail = dr["Mail"].ToString(); Obj.LocationId = ((dr["LocationId"]) == DBNull.Value)?0:Convert.ToInt32(dr["LocationId"]); Obj.Addtime = ((dr["Addtime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["Addtime"]); Obj.IdCard = dr["IdCard"].ToString(); Obj.IdentityType = ((dr["IdentityType"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["IdentityType"]); Obj.OpenID = dr["OpenID"].ToString(); return(Obj); }
protected override void BasePage_Load(tb_UsersEntity user) { if (user != null) { DataSet ds = AutoRepair.BLL.T_RepairDocumentBLL.GetInstance().GetRepairEvaluationByType(user.OpenID); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows != null && ds.Tables[0].Rows.Count > 0) { rptRepairList.DataSource = ds; rptRepairList.DataBind(); } else { record = "<div style=\"font-size:15px;color:#d5d2d2;position:fixed;top:35%;left:30%;\">没有未完成的评价哦~</div>"; } } }
/// <summary> /// 根据ID,返回一个tb_Users对象 /// </summary> /// <param name="userId">userId</param> /// <returns>tb_Users对象</returns> public tb_UsersEntity Get_tb_UsersEntity(int userId) { tb_UsersEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@UserId", SqlDbType.Int) }; _param[0].Value = userId; string sqlStr = "select * from tb_Users with(nolock) where UserId=@UserId"; using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.AutoRepairRW, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_tb_UsersEntity_FromDr(dr); } } return(_obj); }
protected override void BasePage_Load(tb_UsersEntity user) { if (user != null) { AutoRepair.Entity.T_RepairDocumentEntity model = AutoRepair.BLL.T_RepairDocumentBLL.GetInstance().GetAdminSingle(id); if (model != null) { UnitName = model.UnitName; UnitPhone = model.UnitPhone; UnitAddress = model.UnitAddress; RepairNumber = model.RepairNumber; PlateNumber = model.PlateNumber; CarColor = model.CarColor; AutoType = model.AutoType; SignDate = model.SignDate; FinishDate = model.FinishDate; TotalMoney = model.TotalMoney; } } }
public tb_UsersEntity GetModelByOpenId(string openid) { tb_UsersEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@OpenId", SqlDbType.VarChar) }; _param[0].Value = openid; string sqlStr = "select * from tb_Users with(nolock) where OpenID = @OpenID"; using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.AutoRepairRW, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_tb_UsersEntity_FromDr(dr); } } return(_obj); }
/// <summary> /// 得到 tb_users 数据实体 /// </summary> /// <param name="row">row</param> /// <returns>tb_users 数据实体</returns> public tb_UsersEntity Populate_tb_UsersEntity_FromDr(DataRow row) { tb_UsersEntity Obj = new tb_UsersEntity(); if (row != null) { Obj.UserId = ((row["UserId"]) == DBNull.Value)?0:Convert.ToInt32(row["UserId"]); Obj.Phone = row["Phone"].ToString(); Obj.Pwd = row["Pwd"].ToString(); Obj.RealName = row["RealName"].ToString(); Obj.Mail = row["Mail"].ToString(); Obj.LocationId = ((row["LocationId"]) == DBNull.Value)?0:Convert.ToInt32(row["LocationId"]); Obj.Addtime = ((row["Addtime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["Addtime"]); Obj.IdCard = row["IdCard"].ToString(); Obj.IdentityType = ((row["IdentityType"]) == DBNull.Value)?0:Convert.ToInt32(row["IdentityType"]); Obj.OpenID = row["OpenID"].ToString(); } else { return(null); } return(Obj); }
protected override void OnInit(EventArgs e) { shopid = int.Parse(Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("shopid")); appid = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("appid"); secret = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("secret"); weixincode = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("weixincode"); sitepath = Jnwf.Utils.Config.ConfigurationUtil.GetAppSettingValue("sitepath"); tb_UsersEntity user = null; Jnwf.Model.tb_App_UserEntity app_user = null; //检查cookie string ticket = ""; string disney = CookieHelper.GetCookieValue("disney"); if (!string.IsNullOrEmpty(disney)) { jinru = "cookie"; Jnwf.Utils.Log.Logger.Log4Net.Error("BasePage,jinru:" + jinru); ticket = Jnwf.Utils.Helper.DESEncrypt.Decrypt(disney); //Jnwf.Utils.Log.Logger.Log4Net.Error("basepage,cookie:" + ticket); user = AutoRepair.BLL.tb_UsersBLL.GetInstance().GetModelByOpenId(ticket); app_user = Jnwf.BLL.tb_App_UserBLL.GetInstance().GetModelByOpenId(ticket); if (app_user == null) { try { Response.Redirect("http://mp.weixin.qq.com/s?__biz=MzI4MzE0ODM1Nw==&mid=402172802&idx=1&sn=c66fe86ffd6b8c8cb73bd3033c1d2903#rd"); } catch (System.Threading.ThreadAbortException ex) { } } else if (user == null) { try { Response.Redirect(sitepath + "Registered.aspx"); } catch (System.Threading.ThreadAbortException ex) { } } else { this.OnBasePageLoad(user); } } else if (!string.IsNullOrEmpty(Code)) { jinru = "code"; Jnwf.Utils.Log.Logger.Log4Net.Error("BasePage,jinru:" + jinru); string url = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + appid + "&secret=" + secret + "&code=" + Code + "&grant_type=authorization_code"; string json = Jnwf.Utils.Helper.HttpHelper.LoadPageContent(url); if (json.IndexOf("errcode") >= 0) { Jnwf.Utils.Log.Logger.Log4Net.Error("Results.aspx:" + json); } else { wx_OpenInfoEntity info = Jnwf.Utils.Json.JsonHelper.DeserializeJson <wx_OpenInfoEntity>(json); string str = info.openid; //Jnwf.Utils.Log.Logger.Log4Net.Error("basepage,code:" + str); CookieHelper.SetCookie("disney", Jnwf.Utils.Helper.DESEncrypt.Encrypt(str)); user = AutoRepair.BLL.tb_UsersBLL.GetInstance().GetModelByOpenId(info.openid); app_user = Jnwf.BLL.tb_App_UserBLL.GetInstance().GetModelByOpenId(info.openid); if (app_user == null) { try { Response.Redirect("http://mp.weixin.qq.com/s?__biz=MzI4MzE0ODM1Nw==&mid=402172802&idx=1&sn=c66fe86ffd6b8c8cb73bd3033c1d2903#rd"); } catch (System.Threading.ThreadAbortException ex) { } } else if (user == null) { try { Response.Redirect(sitepath + "Registered.aspx"); } catch (System.Threading.ThreadAbortException ex) { } } else { this.OnBasePageLoad(user); } } } else { jinru = "url"; Jnwf.Utils.Log.Logger.Log4Net.Error("BasePage,jinru:" + jinru); //string host = this.Request.Url.Host; //string path = this.Request.Path; //string redirect_uri = HttpUtility.UrlEncode("http://" + host + path); string redirect_uri = HttpUtility.UrlEncode(this.Request.Url.ToString()); Dictionary <string, string> data = new Dictionary <string, string>(); data.Add("appid", appid); data.Add("redirect_uri", redirect_uri); data.Add("response_type", "code"); data.Add("scope", "snsapi_base"); string temp_url = "https://open.weixin.qq.com/connect/oauth2/authorize?"; foreach (var dic in data) { temp_url += dic.Key + "=" + dic.Value + "&"; } //Jnwf.Utils.Log.Logger.Log4Net.Error("detail:" + temp_url); try { //触发微信返回code码 this.Response.Redirect(temp_url.TrimEnd('&'));//Redirect函数会抛出ThreadAbortException异常,不用处理这个异常 } catch (System.Threading.ThreadAbortException ex) { } } base.OnInit(e); }
protected virtual void BasePage_Load(tb_UsersEntity user) { }
public void Update(tb_UsersEntity tb_UsersEntity) { tb_Usersdal.Update(tb_UsersEntity); }
public int Insert(tb_UsersEntity tb_UsersEntity) { return(tb_Usersdal.Insert(tb_UsersEntity)); }