/// <summary> /// 更新一条数据 /// </summary> public bool Update(YueYePlat.Model.vehicletype model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update vehicletype set "); strSql.Append("VehicleTypeID=@VehicleTypeID,"); strSql.Append("VehicleTypeName=@VehicleTypeName"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@VehicleTypeID", MySqlDbType.VarChar, 50), new MySqlParameter("@VehicleTypeName", MySqlDbType.VarChar, 50), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.VehicleTypeID; parameters[1].Value = model.VehicleTypeName; parameters[2].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(YueYePlat.Model.vehicletype model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into vehicletype("); strSql.Append("VehicleTypeID,VehicleTypeName)"); strSql.Append(" values ("); strSql.Append("@VehicleTypeID,@VehicleTypeName)"); MySqlParameter[] parameters = { new MySqlParameter("@VehicleTypeID", MySqlDbType.VarChar, 50), new MySqlParameter("@VehicleTypeName", MySqlDbType.VarChar, 50) }; parameters[0].Value = model.VehicleTypeID; parameters[1].Value = model.VehicleTypeName; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public YueYePlat.Model.vehicletype DataRowToModel(DataRow row) { YueYePlat.Model.vehicletype model = new YueYePlat.Model.vehicletype(); if (row != null) { if (row["ID"] != null && row["ID"].ToString() != "") { model.ID = int.Parse(row["ID"].ToString()); } if (row["VehicleTypeID"] != null) { model.VehicleTypeID = row["VehicleTypeID"].ToString(); } if (row["VehicleTypeName"] != null) { model.VehicleTypeName = row["VehicleTypeName"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public YueYePlat.Model.vehicletype GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,VehicleTypeID,VehicleTypeName from vehicletype "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; YueYePlat.Model.vehicletype model = new YueYePlat.Model.vehicletype(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }