/// <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); }