/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.OrgPkgList GetModel(string strWhere, List <SqlParameter> parameters)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SSPID,SPID,OrgId,OSPID,Status,CreateDate,RPID from OrgPkgList ");
Database db = DatabaseFactory.CreateDatabase();
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
if (parameters.Count > 0)
{
foreach (SqlParameter sqlParameter in parameters)
{
dbCommand.Parameters.Add(sqlParameter);
}
}
Model.OrgPkgList model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.OrgPkgList model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OrgPkgList set ");
strSql.Append("SPID=@SPID,");
strSql.Append("OrgId=@OrgId,");
strSql.Append("OSPID=@OSPID,");
strSql.Append("Status=@Status,");
strSql.Append("CreateDate=@CreateDate,");
strSql.Append("RPID=@RPID");
strSql.Append(" where SSPID=@SSPID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "SSPID", DbType.Int32, model.SSPID);
db.AddInParameter(dbCommand, "SPID", DbType.Int32, model.SPID);
db.AddInParameter(dbCommand, "OrgId", DbType.Int32, model.OrgId);
db.AddInParameter(dbCommand, "OSPID", DbType.Int32, model.OSPID);
db.AddInParameter(dbCommand, "Status", DbType.Byte, model.Status);
db.AddInParameter(dbCommand, "CreateDate", DbType.DateTime, model.CreateDate);
db.AddInParameter(dbCommand, "RPID", DbType.Int32, model.RPID);
int rows = db.ExecuteNonQuery(dbCommand);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public Model.OrgPkgList ReaderBind(IDataReader dataReader)
{
Model.OrgPkgList model = new Model.OrgPkgList();
object ojb;
ojb = dataReader["SSPID"];
if (ojb != null && ojb != DBNull.Value)
{
model.SSPID = Convert.ToInt32(ojb);
}
ojb = dataReader["SPID"];
if (ojb != null && ojb != DBNull.Value)
{
model.SPID = Convert.ToInt32(ojb);
}
ojb = dataReader["OrgId"];
if (ojb != null && ojb != DBNull.Value)
{
model.OrgId = Convert.ToInt32(ojb);
}
ojb = dataReader["OSPID"];
if (ojb != null && ojb != DBNull.Value)
{
model.OSPID = Convert.ToInt32(ojb);
}
ojb = dataReader["Status"];
if (ojb != null && ojb != DBNull.Value)
{
model.Status = Convert.ToInt32(ojb);
}
ojb = dataReader["CreateDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.CreateDate = Convert.ToDateTime(ojb);
}
ojb = dataReader["RPID"];
if (ojb != null && ojb != DBNull.Value)
{
model.RPID = Convert.ToInt32(ojb);
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.OrgPkgList GetModel(int SSPID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select SSPID,SPID,OrgId,OSPID,Status,CreateDate,RPID from OrgPkgList ");
strSql.Append(" where SSPID=@SSPID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "SSPID", DbType.Int32, SSPID);
Model.OrgPkgList model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.OrgPkgList DataRowToModel(DataRow row)
{
Model.OrgPkgList model = new Model.OrgPkgList();
if (row != null)
{
if (row["SSPID"] != null && row["SSPID"].ToString() != "")
{
model.SSPID = Convert.ToInt32(row["SSPID"].ToString());
}
if (row["SPID"] != null && row["SPID"].ToString() != "")
{
model.SPID = Convert.ToInt32(row["SPID"].ToString());
}
if (row["OrgId"] != null && row["OrgId"].ToString() != "")
{
model.OrgId = Convert.ToInt32(row["OrgId"].ToString());
}
if (row["OSPID"] != null && row["OSPID"].ToString() != "")
{
model.OSPID = Convert.ToInt32(row["OSPID"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = Convert.ToInt32(row["Status"].ToString());
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = Convert.ToDateTime(row["CreateDate"].ToString());
}
if (row["RPID"] != null && row["RPID"].ToString() != "")
{
model.RPID = Convert.ToInt32(row["RPID"].ToString());
}
}
return(model);
}
