/// <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;
}
