/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.MessageUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update MessageUser set "); strSql.Append("MID=@MID,"); strSql.Append("UID=@UID,"); strSql.Append("Status=@Status"); strSql.Append(" where "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MID", DbType.Int32, model.MID); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "Status", DbType.Int16, model.Status); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.MessageUser DataRowToModel(DataRow row) { Model.MessageUser model = new Model.MessageUser(); if (row != null) { if (row["MID"] != null && row["MID"].ToString() != "") { model.MID = Convert.ToInt32(row["MID"].ToString()); } if (row["UID"] != null && row["UID"].ToString() != "") { model.UID = Convert.ToInt32(row["UID"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = Convert.ToInt32(row["Status"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.MessageUser GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select MID,UID,Status from MessageUser "); strSql.Append(" where "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); Model.MessageUser model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public Model.MessageUser ReaderBind(IDataReader dataReader) { Model.MessageUser model = new Model.MessageUser(); object ojb; ojb = dataReader["MID"]; if (ojb != null && ojb != DBNull.Value) { model.MID = Convert.ToInt32(ojb); } ojb = dataReader["UID"]; if (ojb != null && ojb != DBNull.Value) { model.UID = Convert.ToInt32(ojb); } ojb = dataReader["Status"]; if (ojb != null && ojb != DBNull.Value) { model.Status = Convert.ToInt32(ojb); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.MessageUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MessageUser("); strSql.Append("MID,UID,Status)"); strSql.Append(" values ("); strSql.Append("@MID,@UID,@Status)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "MID", DbType.Int32, model.MID); db.AddInParameter(dbCommand, "UID", DbType.Int32, model.UID); db.AddInParameter(dbCommand, "Status", DbType.Int16, model.Status); int result; object obj = db.ExecuteScalar(dbCommand); //if (!int.TryParse(obj.ToString(), out result)) //{ // return false; //} return(true); }