/// <summary>
/// 得到 wx_users 数据实体
/// </summary>
/// <param name="row">row</param>
/// <returns>wx_users 数据实体</returns>
public wx_UsersEntity Populate_wx_UsersEntity_FromDr(DataRow row)
{
wx_UsersEntity Obj = new wx_UsersEntity();
if (row != null)
{
Obj.UserId = ((row["UserId"]) == DBNull.Value)?0:Convert.ToInt32(row["UserId"]);
Obj.RealName = row["RealName"].ToString();
Obj.Phone = row["Phone"].ToString();
Obj.Weixin = row["Weixin"].ToString();
Obj.Description = row["Description"].ToString();
Obj.OpenId = row["OpenId"].ToString();
Obj.ShopId = ((row["ShopId"]) == DBNull.Value)?0:Convert.ToInt32(row["ShopId"]);
Obj.RoleId = ((row["RoleId"]) == DBNull.Value)?0:Convert.ToInt32(row["RoleId"]);
Obj.Status = ((row["Status"]) == DBNull.Value)?0:Convert.ToInt32(row["Status"]);
Obj.Address = row["Address"].ToString();
Obj.Points = ((row["Points"]) == DBNull.Value)?0:Convert.ToInt32(row["Points"]);
Obj.Wallet = ((row["Wallet"]) == DBNull.Value)?0:Convert.ToDecimal(row["Wallet"]);
Obj.AddTime = ((row["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["AddTime"]);
Obj.UpdateTime = ((row["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["UpdateTime"]);
Obj.ParentId = ((row["ParentId"]) == DBNull.Value)?0:Convert.ToInt32(row["ParentId"]);
}
else
{
return(null);
}
return(Obj);
}
/// <summary>
/// 代理申请后，未付款，可以通过手动点击通过完成代理审核（代理审核通过但未付款）
/// </summary>
/// <param name="openid"></param>
/// <returns></returns>
public int AuditPass(int userid)
{
try
{
wx_UsersEntity model = GetAdminSingle(userid);
model.Status = 1;
model.UpdateTime = DateTime.Now;
Update(model);
return(userid);
}
catch (Exception ex)
{
return(-1);
}
}
public wx_UsersEntity Get_wx_UsersEntity(string openId)
{
wx_UsersEntity _obj = null;
SqlParameter[] _param =
{
new SqlParameter("@OpenId", SqlDbType.VarChar)
};
_param[0].Value = openId;
string sqlStr = "select * from wx_Users with(nolock) where OpenId=@OpenId";
using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.WfxRW, CommandType.Text, sqlStr, _param))
{
while (dr.Read())
{
_obj = Populate_wx_UsersEntity_FromDr(dr);
}
}
return(_obj);
}
/// <summary>
/// 向数据库中插入一条新记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_wx_UsersModel">wx_Users实体</param>
/// <returns>新插入记录的编号</returns>
public int Insert(SqlTransaction sp, wx_UsersEntity _wx_UsersModel)
{
string sqlStr = "insert into wx_Users([RealName],[Phone],[Weixin],[Description],[OpenId],[ShopId],[RoleId],[Status],[Address],[Points],[Wallet],[AddTime],[UpdateTime],[ParentId]) values(@RealName,@Phone,@Weixin,@Description,@OpenId,@ShopId,@RoleId,@Status,@Address,@Points,@Wallet,@AddTime,@UpdateTime,@ParentId) select @@identity";
int res;
SqlParameter[] _param =
{
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Weixin", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@OpenId", SqlDbType.VarChar),
new SqlParameter("@ShopId", SqlDbType.Int),
new SqlParameter("@RoleId", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@Points", SqlDbType.Int),
new SqlParameter("@Wallet", SqlDbType.Decimal),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@ParentId", SqlDbType.Int)
};
_param[0].Value = _wx_UsersModel.RealName;
_param[1].Value = _wx_UsersModel.Phone;
_param[2].Value = _wx_UsersModel.Weixin;
_param[3].Value = _wx_UsersModel.Description;
_param[4].Value = _wx_UsersModel.OpenId;
_param[5].Value = _wx_UsersModel.ShopId;
_param[6].Value = _wx_UsersModel.RoleId;
_param[7].Value = _wx_UsersModel.Status;
_param[8].Value = _wx_UsersModel.Address;
_param[9].Value = _wx_UsersModel.Points;
_param[10].Value = _wx_UsersModel.Wallet;
_param[11].Value = _wx_UsersModel.AddTime;
_param[12].Value = _wx_UsersModel.UpdateTime;
_param[13].Value = _wx_UsersModel.ParentId;
res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param));
return(res);
}
/// <summary>
/// 得到 wx_users 数据实体
/// </summary>
/// <param name="dr">dr</param>
/// <returns>wx_users 数据实体</returns>
public wx_UsersEntity Populate_wx_UsersEntity_FromDr(IDataReader dr)
{
wx_UsersEntity Obj = new wx_UsersEntity();
Obj.UserId = ((dr["UserId"]) == DBNull.Value)?0:Convert.ToInt32(dr["UserId"]);
Obj.RealName = dr["RealName"].ToString();
Obj.Phone = dr["Phone"].ToString();
Obj.Weixin = dr["Weixin"].ToString();
Obj.Description = dr["Description"].ToString();
Obj.OpenId = dr["OpenId"].ToString();
Obj.ShopId = ((dr["ShopId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ShopId"]);
Obj.RoleId = ((dr["RoleId"]) == DBNull.Value)?0:Convert.ToInt32(dr["RoleId"]);
Obj.Status = ((dr["Status"]) == DBNull.Value)?0:Convert.ToInt32(dr["Status"]);
Obj.Address = dr["Address"].ToString();
Obj.Points = ((dr["Points"]) == DBNull.Value)?0:Convert.ToInt32(dr["Points"]);
Obj.Wallet = ((dr["Wallet"]) == DBNull.Value)?0:Convert.ToDecimal(dr["Wallet"]);
Obj.AddTime = ((dr["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["AddTime"]);
Obj.UpdateTime = ((dr["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["UpdateTime"]);
Obj.ParentId = ((dr["ParentId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ParentId"]);
return(Obj);
}
/// <summary>
/// 向数据表wx_Users更新一条记录。带事务
/// </summary>
/// <param name="sp">事务对象</param>
/// <param name="_wx_UsersModel">_wx_UsersModel</param>
/// <returns>影响的行数</returns>
public int Update(SqlTransaction sp, wx_UsersEntity _wx_UsersModel)
{
string sqlStr = "update wx_Users set [RealName]=@RealName,[Phone]=@Phone,[Weixin]=@Weixin,[Description]=@Description,[OpenId]=@OpenId,[ShopId]=@ShopId,[RoleId]=@RoleId,[Status]=@Status,[Address]=@Address,[Points]=@Points,[Wallet]=@Wallet,[AddTime]=@AddTime,[UpdateTime]=@UpdateTime,[ParentId]=@ParentId where UserId=@UserId";
SqlParameter[] _param =
{
new SqlParameter("@UserId", SqlDbType.Int),
new SqlParameter("@RealName", SqlDbType.VarChar),
new SqlParameter("@Phone", SqlDbType.VarChar),
new SqlParameter("@Weixin", SqlDbType.VarChar),
new SqlParameter("@Description", SqlDbType.VarChar),
new SqlParameter("@OpenId", SqlDbType.VarChar),
new SqlParameter("@ShopId", SqlDbType.Int),
new SqlParameter("@RoleId", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@Address", SqlDbType.VarChar),
new SqlParameter("@Points", SqlDbType.Int),
new SqlParameter("@Wallet", SqlDbType.Decimal),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@ParentId", SqlDbType.Int)
};
_param[0].Value = _wx_UsersModel.UserId;
_param[1].Value = _wx_UsersModel.RealName;
_param[2].Value = _wx_UsersModel.Phone;
_param[3].Value = _wx_UsersModel.Weixin;
_param[4].Value = _wx_UsersModel.Description;
_param[5].Value = _wx_UsersModel.OpenId;
_param[6].Value = _wx_UsersModel.ShopId;
_param[7].Value = _wx_UsersModel.RoleId;
_param[8].Value = _wx_UsersModel.Status;
_param[9].Value = _wx_UsersModel.Address;
_param[10].Value = _wx_UsersModel.Points;
_param[11].Value = _wx_UsersModel.Wallet;
_param[12].Value = _wx_UsersModel.AddTime;
_param[13].Value = _wx_UsersModel.UpdateTime;
_param[14].Value = _wx_UsersModel.ParentId;
return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param));
}
public void Update(wx_UsersEntity wx_UsersEntity)
{
wx_Usersdal.Update(wx_UsersEntity);
}
public int Insert(wx_UsersEntity wx_UsersEntity)
{
return(wx_Usersdal.Insert(wx_UsersEntity));
}
