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