/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(BCW.HP3.Model.SWB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_SWB set ");
strSql.Append("HP3Money=@HP3Money,");
strSql.Append("HP3IsGet=@HP3IsGet");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@HP3Money", SqlDbType.BigInt, 8),
new SqlParameter("@HP3IsGet", SqlDbType.DateTime),
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.HP3Money;
parameters[1].Value = model.HP3IsGet;
parameters[2].Value = model.UserID;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(BCW.HP3.Model.SWB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_SWB(");
strSql.Append("UserID,HP3Money,HP3IsGet)");
strSql.Append(" values (");
strSql.Append("@UserID,@HP3Money,@HP3IsGet)");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4),
new SqlParameter("@HP3Money", SqlDbType.BigInt, 8),
new SqlParameter("@HP3IsGet", SqlDbType.DateTime)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.HP3Money;
parameters[2].Value = model.HP3IsGet;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BCW.HP3.Model.SWB DataRowToModel(DataRow row)
{
BCW.HP3.Model.SWB model = new BCW.HP3.Model.SWB();
if (row != null)
{
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = int.Parse(row["UserID"].ToString());
}
if (row["HP3Money"] != null && row["HP3Money"].ToString() != "")
{
model.HP3Money = long.Parse(row["HP3Money"].ToString());
}
if (row["HP3IsGet"] != null && row["HP3IsGet"].ToString() != "")
{
model.HP3IsGet = Convert.ToDateTime(row["HP3IsGet"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BCW.HP3.Model.SWB GetModel(int UserID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UserID,HP3Money,HP3IsGet from tb_SWB ");
strSql.Append(" where UserID=@UserID ");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.Int, 4)
};
parameters[0].Value = UserID;
BCW.HP3.Model.SWB model = new BCW.HP3.Model.SWB();
DataSet ds = SqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
