/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(starweibo.Model.powerInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update powerInfo set ");
strSql.Append("userId=@userId,");
strSql.Append("zan=@zan,");
strSql.Append("pinglun=@pinglun,");
strSql.Append("at=@at,");
strSql.Append("guanzhu=@guanzhu,");
strSql.Append("jubao=@jubao,");
strSql.Append("zhuanfa=@zhuanfa,");
strSql.Append("shoucang=@shoucang,");
strSql.Append("fasong=@fasong");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@userId", SqlDbType.Int, 4),
new SqlParameter("@zan", SqlDbType.Char, 1),
new SqlParameter("@pinglun", SqlDbType.Char, 1),
new SqlParameter("@at", SqlDbType.Char, 1),
new SqlParameter("@guanzhu", SqlDbType.Char, 1),
new SqlParameter("@jubao", SqlDbType.Char, 1),
new SqlParameter("@zhuanfa", SqlDbType.Char, 1),
new SqlParameter("@shoucang", SqlDbType.Char, 1),
new SqlParameter("@fasong", SqlDbType.Char, 1),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.userId;
parameters[1].Value = model.zan;
parameters[2].Value = model.pinglun;
parameters[3].Value = model.at;
parameters[4].Value = model.guanzhu;
parameters[5].Value = model.jubao;
parameters[6].Value = model.zhuanfa;
parameters[7].Value = model.shoucang;
parameters[8].Value = model.fasong;
parameters[9].Value = model.id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public starweibo.Model.powerInfo DataRowToModel(DataRow row)
{
starweibo.Model.powerInfo model = new starweibo.Model.powerInfo();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["userId"] != null && row["userId"].ToString() != "")
{
model.userId = int.Parse(row["userId"].ToString());
}
if (row["zan"] != null)
{
model.zan = row["zan"].ToString();
}
if (row["pinglun"] != null)
{
model.pinglun = row["pinglun"].ToString();
}
if (row["at"] != null)
{
model.at = row["at"].ToString();
}
if (row["guanzhu"] != null)
{
model.guanzhu = row["guanzhu"].ToString();
}
if (row["jubao"] != null)
{
model.jubao = row["jubao"].ToString();
}
if (row["zhuanfa"] != null)
{
model.zhuanfa = row["zhuanfa"].ToString();
}
if (row["shoucang"] != null)
{
model.shoucang = row["shoucang"].ToString();
}
if (row["fasong"] != null)
{
model.fasong = row["fasong"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(starweibo.Model.powerInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into powerInfo(");
strSql.Append("userId,zan,pinglun,at,guanzhu,jubao,zhuanfa,shoucang,fasong)");
strSql.Append(" values (");
strSql.Append("@userId,@zan,@pinglun,@at,@guanzhu,@jubao,@zhuanfa,@shoucang,@fasong)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@userId", SqlDbType.Int, 4),
new SqlParameter("@zan", SqlDbType.Char, 1),
new SqlParameter("@pinglun", SqlDbType.Char, 1),
new SqlParameter("@at", SqlDbType.Char, 1),
new SqlParameter("@guanzhu", SqlDbType.Char, 1),
new SqlParameter("@jubao", SqlDbType.Char, 1),
new SqlParameter("@zhuanfa", SqlDbType.Char, 1),
new SqlParameter("@shoucang", SqlDbType.Char, 1),
new SqlParameter("@fasong", SqlDbType.Char, 1)
};
parameters[0].Value = model.userId;
parameters[1].Value = model.zan;
parameters[2].Value = model.pinglun;
parameters[3].Value = model.at;
parameters[4].Value = model.guanzhu;
parameters[5].Value = model.jubao;
parameters[6].Value = model.zhuanfa;
parameters[7].Value = model.shoucang;
parameters[8].Value = model.fasong;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public void charuP(string userName)
{
List <starweibo.Model.userInfo> shenqing = new List <starweibo.Model.userInfo>();
starweibo.BLL.userInfo oneshenqing = new starweibo.BLL.userInfo();
starweibo.BLL.powerInfo OP = new starweibo.BLL.powerInfo();
starweibo.Model.powerInfo IDP = new starweibo.Model.powerInfo();
shenqing = oneshenqing.GetModelList("userName='******'");
IDP.userId = shenqing[0].id;
IDP.zan = "1";
IDP.pinglun = "1";
IDP.at = "1";
IDP.guanzhu = "1";
IDP.jubao = "1";
IDP.zhuanfa = "1";
IDP.shoucang = "1";
IDP.fasong = "1";
OP.Add(IDP);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public starweibo.Model.powerInfo GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,userId,zan,pinglun,at,guanzhu,jubao,zhuanfa,shoucang,fasong from powerInfo ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
starweibo.Model.powerInfo model = new starweibo.Model.powerInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
