/// <summary> /// 获取实体 /// </summary> /// <param name="userid">编号</param> /// <returns></returns> public Eyousoft_yhq.Model.WXBind GetWXBindByOpenid(string openid) { Eyousoft_yhq.Model.WXBind model = null; string StrSql = "select * from tbl_WeiXinBind where OpenId=@OpenId"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "OpenId", DbType.AnsiStringFixedLength, openid); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.WXBind(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.CustomerId = dr.GetString(dr.GetOrdinal("CustomerId")); model.CustomerName = dr.GetString(dr.GetOrdinal("CustomerName")); model.MobilePhone = dr.GetString(dr.GetOrdinal("MobilePhone")); model.OpenId = openid; model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.BindTime = dr.IsDBNull(dr.GetOrdinal("BindTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("BindTime")); model.SubscribeTime = dr.IsDBNull(dr.GetOrdinal("SubscribeTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("SubscribeTime")); model.Country = dr.GetString(dr.GetOrdinal("Country")); model.Province = dr.GetString(dr.GetOrdinal("Province")); model.City = dr.GetString(dr.GetOrdinal("City")); model.Language = dr.GetString(dr.GetOrdinal("Language")); } } return(model); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int updateWXBind(Eyousoft_yhq.Model.WXBind model) { if (model.Id < 1) { return(0); } return(dal.updateWXBind(model)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int AddWXBind(Eyousoft_yhq.Model.WXBind model) { if (string.IsNullOrEmpty(model.CustomerId)) { return(0); } return(dal.Add(model)); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns></returns> public int updateWXBind(Eyousoft_yhq.Model.WXBind model) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE tbl_WeiXinBind SET CustomerId=@CustomerId, OpenId = @OpenId , NickName = @NickName , Sex = @Sex WHERE Id=@Id)"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "Id", System.Data.DbType.String, model.Id); this._db.AddInParameter(cmd, "CustomerId", System.Data.DbType.String, model.CustomerId); this._db.AddInParameter(cmd, "OpenId", System.Data.DbType.String, model.OpenId); this._db.AddInParameter(cmd, "NickName", System.Data.DbType.String, model.NickName); this._db.AddInParameter(cmd, "Sex", System.Data.DbType.String, model.Sex); return(DbHelper.ExecuteSql(cmd, this._db)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Eyousoft_yhq.Model.WXBind model) { StringBuilder strSql = new StringBuilder(); strSql.Append("INSERT INTO tbl_WeiXinBind( CustomerId , CustomerName , MobilePhone , OpenId , NickName , Sex , SubscribeTime , Country , Province , City , Language ) VALUES ( @CustomerId , @CustomerName , @MobilePhone , @OpenId , @NickName , @Sex , @SubscribeTime , @Country , @Province , @City , @LANGUAGE )"); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "CustomerId", System.Data.DbType.String, model.CustomerId); this._db.AddInParameter(cmd, "CustomerName", System.Data.DbType.String, model.CustomerName); this._db.AddInParameter(cmd, "MobilePhone", System.Data.DbType.String, model.MobilePhone); this._db.AddInParameter(cmd, "OpenId", System.Data.DbType.String, model.OpenId); this._db.AddInParameter(cmd, "NickName", System.Data.DbType.String, model.NickName); this._db.AddInParameter(cmd, "Sex", System.Data.DbType.String, model.Sex); this._db.AddInParameter(cmd, "SubscribeTime", System.Data.DbType.String, model.SubscribeTime); this._db.AddInParameter(cmd, "Province", System.Data.DbType.String, model.Province); this._db.AddInParameter(cmd, "City", System.Data.DbType.String, model.City); this._db.AddInParameter(cmd, "Language", System.Data.DbType.String, model.Language); return(DbHelper.ExecuteSql(cmd, this._db)); }
/// <summary> /// 获取实体 /// </summary> /// <param name="userid">编号</param> /// <returns></returns> public Eyousoft_yhq.Model.WXBind GetWXBindByOpenid(string openid) { Eyousoft_yhq.Model.WXBind model = null; string StrSql = "select * from tbl_WeiXinBind where OpenId=@OpenId"; DbCommand dc = this._db.GetSqlStringCommand(StrSql); this._db.AddInParameter(dc, "OpenId", DbType.AnsiStringFixedLength, openid); using (IDataReader dr = DbHelper.ExecuteReader(dc, this._db)) { if (dr.Read()) { model = new Eyousoft_yhq.Model.WXBind(); model.Id = dr.GetInt32(dr.GetOrdinal("Id")); model.CustomerId = dr.GetString(dr.GetOrdinal("CustomerId")); model.CustomerName = dr.GetString(dr.GetOrdinal("CustomerName")); model.MobilePhone = dr.GetString(dr.GetOrdinal("MobilePhone")); model.OpenId = openid; model.NickName = dr.GetString(dr.GetOrdinal("NickName")); model.Sex = dr.GetString(dr.GetOrdinal("Sex")); model.BindTime = dr.IsDBNull(dr.GetOrdinal("BindTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("BindTime")); model.SubscribeTime = dr.IsDBNull(dr.GetOrdinal("SubscribeTime")) ? DateTime.MinValue : dr.GetDateTime(dr.GetOrdinal("SubscribeTime")); model.Country = dr.GetString(dr.GetOrdinal("Country")); model.Province = dr.GetString(dr.GetOrdinal("Province")); model.City = dr.GetString(dr.GetOrdinal("City")); model.Language = dr.GetString(dr.GetOrdinal("Language")); } } return model; }