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