private PraiserRecordInfo FillList(IDataReader dataReader) { PraiserRecordInfo model = new PraiserRecordInfo(); object ojb; ojb = dataReader["Id"]; if (ojb != null && ojb != DBNull.Value) { model.Id = ( int)(ojb); } ojb = dataReader["StarId"]; if (ojb != null && ojb != DBNull.Value) { model.StarId = ( int)(ojb); } ojb = dataReader["PraiserId"]; if (ojb != null && ojb != DBNull.Value) { model.PraiserId = ( int)(ojb); } ojb = dataReader["CreateDate"]; if (ojb != null && ojb != DBNull.Value) { model.CreateDate = ( DateTime)(ojb); } ojb = dataReader["CreateIP"]; if (ojb != null && ojb != DBNull.Value) { model.CreateIP = ( string)(ojb); } return(model); }
public bool Delete(PraiserRecordInfo model) { Database db = DBHelper.CreateDataBase(); StringBuilder sb = new StringBuilder(); sb.Append("delete from PraiserRecord"); sb.Append(" where Id=@Id"); DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString()); db.AddInParameter(dbCommand, "@Id", DbType.Int32, model.Id); return(db.ExecuteNonQuery(dbCommand) < 1 ? false : true); }
public bool Update(PraiserRecordInfo model) { Database db = DBHelper.CreateDataBase(); StringBuilder sb = new StringBuilder(); sb.Append("update PraiserRecord set "); sb.Append("StarId=@StarId,PraiserId=@PraiserId,CreateDate=@CreateDate,CreateIP=@CreateIP"); sb.Append(" where Id=@Id"); DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString()); db.AddInParameter(dbCommand, "@Id", DbType.Int32, model.Id); db.AddInParameter(dbCommand, "@StarId", DbType.Int32, model.StarId); db.AddInParameter(dbCommand, "@PraiserId", DbType.Int32, model.PraiserId); db.AddInParameter(dbCommand, "@CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "@CreateIP", DbType.String, model.CreateIP); return(db.ExecuteNonQuery(dbCommand) < 1 ? false : true); }
public int Create(PraiserRecordInfo model) { Database db = DBHelper.CreateDataBase(); StringBuilder sb = new StringBuilder(); sb.Append("insert into PraiserRecord("); sb.Append("StarId,PraiserId,CreateDate,CreateIP"); sb.Append(") values("); sb.Append("@StarId,@PraiserId,@CreateDate,@CreateIP);SELECT @@IDENTITY;"); DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString()); db.AddInParameter(dbCommand, "@StarId", DbType.Int32, model.StarId); db.AddInParameter(dbCommand, "@PraiserId", DbType.Int32, model.PraiserId); db.AddInParameter(dbCommand, "@CreateDate", DbType.DateTime, model.CreateDate); db.AddInParameter(dbCommand, "@CreateIP", DbType.String, model.CreateIP); int id = Convert.ToInt32(db.ExecuteScalar(dbCommand)); return(id); }
public PraiserRecordInfo Get(int Id) { Database db = DBHelper.CreateDataBase(); StringBuilder sb = new StringBuilder(); sb.Append("select * from PraiserRecord where Id=@Id"); DbCommand dbCommand = db.GetSqlStringCommand(sb.ToString()); db.AddInParameter(dbCommand, "@Id", DbType.Int32, Id); PraiserRecordInfo model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = FillList(dataReader); } } return(model); }
public bool Delete(PraiserRecordInfo model) { return(dal.Delete(model)); }
public bool Update(PraiserRecordInfo model) { return(dal.Update(model)); }
public int Create(PraiserRecordInfo model) { int id = dal.Create(model); return(id); }