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