/// <summary>
/// 增加一条数据
/// </summary>
public void Add(UserPermission.Model.USER_SHARE_PRODUCT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into USER_SHARE_PRODUCT(");
strSql.Append("PRODUCTID,PROJECTID,PRODUCTNAME,PRODUCTDESC,PRODUCTFLAG)");
strSql.Append(" values (");
strSql.Append("@PRODUCTID,@PROJECTID,@PRODUCTNAME,@PRODUCTDESC,@PRODUCTFLAG)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "PRODUCTID", DbType.String, model.PRODUCTID);
db.AddInParameter(dbCommand, "PROJECTID", DbType.String, model.PROJECTID);
db.AddInParameter(dbCommand, "PRODUCTNAME", DbType.String, model.PRODUCTNAME);
db.AddInParameter(dbCommand, "PRODUCTDESC", DbType.String, model.PRODUCTDESC);
db.AddInParameter(dbCommand, "PRODUCTFLAG", DbType.String, model.PRODUCTFLAG);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(UserPermission.Model.USER_SHARE_PRODUCT model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update USER_SHARE_PRODUCT set ");
strSql.Append("PROJECTID=@PROJECTID,");
strSql.Append("PRODUCTNAME=@PRODUCTNAME,");
strSql.Append("PRODUCTDESC=@PRODUCTDESC,");
strSql.Append("PRODUCTFLAG=@PRODUCTFLAG");
strSql.Append(" where PRODUCTID=@PRODUCTID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "PRODUCTID", DbType.String, model.PRODUCTID);
db.AddInParameter(dbCommand, "PROJECTID", DbType.String, model.PROJECTID);
db.AddInParameter(dbCommand, "PRODUCTNAME", DbType.String, model.PRODUCTNAME);
db.AddInParameter(dbCommand, "PRODUCTDESC", DbType.String, model.PRODUCTDESC);
db.AddInParameter(dbCommand, "PRODUCTFLAG", DbType.String, model.PRODUCTFLAG);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UserPermission.Model.USER_SHARE_PRODUCT GetModel(decimal PRODUCTID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select PRODUCTID,PROJECTID,PRODUCTNAME,PRODUCTDESC,PRODUCTFLAG from USER_SHARE_PRODUCT ");
strSql.Append(" where PRODUCTID=@PRODUCTID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "PRODUCTID", DbType.String, PRODUCTID);
UserPermission.Model.USER_SHARE_PRODUCT model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public UserPermission.Model.USER_SHARE_PRODUCT ReaderBind(IDataReader dataReader)
{
UserPermission.Model.USER_SHARE_PRODUCT model = new UserPermission.Model.USER_SHARE_PRODUCT();
object ojb;
ojb = dataReader["PRODUCTID"];
if (ojb != null && ojb != DBNull.Value)
{
model.PRODUCTID = (decimal)ojb;
}
ojb = dataReader["PROJECTID"];
if (ojb != null && ojb != DBNull.Value)
{
model.PROJECTID = (decimal)ojb;
}
model.PRODUCTNAME = dataReader["PRODUCTNAME"].ToString();
model.PRODUCTDESC = dataReader["PRODUCTDESC"].ToString();
ojb = dataReader["PRODUCTFLAG"];
if (ojb != null && ojb != DBNull.Value)
{
model.PRODUCTFLAG = (decimal)ojb;
}
return(model);
}
