/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(TSGLXT.Model.TSB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TSB set ");
strSql.Append("SKID=@SKID,");
strSql.Append("BKNAME=@BKNAME,");
strSql.Append("BKPRICE=@BKPRICE,");
strSql.Append("BKAUTHOR=@BKAUTHOR");
strSql.Append(" where BKISBN=@BKISBN ");
SqlParameter[] parameters =
{
new SqlParameter("@SKID", SqlDbType.VarChar, 6),
new SqlParameter("@BKNAME", SqlDbType.VarChar, 20),
new SqlParameter("@BKPRICE", SqlDbType.Int, 4),
new SqlParameter("@BKAUTHOR", SqlDbType.VarChar, 20),
new SqlParameter("@BKISBN", SqlDbType.VarChar, 13)
};
parameters[0].Value = model.SKID;
parameters[1].Value = model.BKNAME;
parameters[2].Value = model.BKPRICE;
parameters[3].Value = model.BKAUTHOR;
parameters[4].Value = model.BKISBN;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSGLXT.Model.TSB DataRowToModel(DataRow row)
{
TSGLXT.Model.TSB model = new TSGLXT.Model.TSB();
if (row != null)
{
if (row["BKISBN"] != null)
{
model.BKISBN = row["BKISBN"].ToString();
}
if (row["SKID"] != null)
{
model.SKID = row["SKID"].ToString();
}
if (row["BKNAME"] != null)
{
model.BKNAME = row["BKNAME"].ToString();
}
if (row["BKPRICE"] != null && row["BKPRICE"].ToString() != "")
{
model.BKPRICE = int.Parse(row["BKPRICE"].ToString());
}
if (row["BKAUTHOR"] != null)
{
model.BKAUTHOR = row["BKAUTHOR"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(TSGLXT.Model.TSB model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TSB(");
strSql.Append("BKISBN,SKID,BKNAME,BKPRICE,BKAUTHOR)");
strSql.Append(" values (");
strSql.Append("@BKISBN,@SKID,@BKNAME,@BKPRICE,@BKAUTHOR)");
SqlParameter[] parameters =
{
new SqlParameter("@BKISBN", SqlDbType.VarChar, 13),
new SqlParameter("@SKID", SqlDbType.VarChar, 6),
new SqlParameter("@BKNAME", SqlDbType.VarChar, 20),
new SqlParameter("@BKPRICE", SqlDbType.Int, 4),
new SqlParameter("@BKAUTHOR", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.BKISBN;
parameters[1].Value = model.SKID;
parameters[2].Value = model.BKNAME;
parameters[3].Value = model.BKPRICE;
parameters[4].Value = model.BKAUTHOR;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSGLXT.Model.TSB GetModel(string BKISBN)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 BKISBN,SKID,BKNAME,BKPRICE,BKAUTHOR from TSB ");
strSql.Append(" where BKISBN=@BKISBN ");
SqlParameter[] parameters =
{
new SqlParameter("@BKISBN", SqlDbType.VarChar, 13)
};
parameters[0].Value = BKISBN;
TSGLXT.Model.TSB model = new TSGLXT.Model.TSB();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
